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 🙌
Hello Faizan Ashraf, cool use case! You can log to Gsheet using Zapier or Make called with a Dust app (example: https://docs.dust.tt/docs/creating-google-calendar-events-from-a-dust-assistant) You can then plug this Gsheet using the Query Table tool. You can add it to the same agent or plug it to a new agent. If you do the former, I suggest explaining how/when to use each tool in the instructions. Hope this helps!
hey Remi thanks for the response .. is there any tutorial available on the youtube for this :?
let me check
sure
There aren't at this point unfortunately - but the doc should be pretty comprehensive
i can't plug it in the existing agent because I have created an agent .. not the dust app .. now as i want to push data to g-sheet which can only be done with dust app so i have to create the chat module inside the dust app right ??
To push data, you'll want to follow the instructions here: https://docs.dust.tt/docs/creating-google-calendar-events-from-a-dust-assistant) 😊 You can add the new tool (Dust app) to your agent at any point. Just click: new tool>Dust app. In the assistant's settings
Regarding this : " You can add the new tool (Dust app) to your agent at any point. Just click: new tool>Dust app. In the assistant's settings" I need some documentation please the only problem is that i'm confused b/w dust app and agents . i don't know i can connect them both or not
Faizan Ashraf Here is a quick video - let me know if you got any other questions 😊
there's a issue i'm facing . you can see here is mention sync 3 mins ago but I want to make it live because i have made some changes in the drive but it's not displayed in the dust.tt yet .. when I have progress bars the data would be changing in seconds then it won't be retrieving the updated data . what's the solution to this or i'm missing something may be ?
Faizan Ashraf The updates of the connected data aren’t 100% real time. There is a lag of a few minutes. To have data pushed instantaneously, you could use make or Zapier to upload the updated file in a Dust Folder (use “upload document” step in Zapier). You can trigger the zap every time there is a file change.
how many minutes of lag is there ?
it depends - I think it's <5 min
