Integrating AI Project Management with Google Sheets for Tracking
I’ve built an AI Project Manager agent in Dust that evaluates developer updates using unique IDs (like M-02) and compares them against the SOW stored in our knowledge base. It gives feedback based on whether the task is complete, incomplete, or needs correction — and it’s working well so far. Now I’m working on the next step: I want to log each update to Google Sheets and then have the agent reference that sheet to:
Check task progress
See what’s already been submitted
Calculate % completion for each developer
Has anyone done something similar or have tips on the best way to let an agent or Dust App use data from Sheets this way? Appreciate any guidance — happy to share back what I build 🙌
