Dust Community Icon
Join the Community
Help

Automating Dust Agent Setup for Daily CSV Exports

Avatar of Thomas Van SundertThomas Van Sundert
·
·

Hi all, I need a bit of help setting up my Dust Agent. At our company we're using Productive to manage planning, revenue forecasts etc. Productive does not have the concept of snapshots, so I have set it up to generate daily CSV exports of some important data (for instance the amount of scheduled revenue per project per period of time). I now want to automatically feed these daily snapshots to a Dust agent. I already saw that query tables seems to lead to the best results for my bot, but I can't seem to auto-add query tables. What I would like to be able to do is select a Google Drive folder or Dust folder or Google Drive file so that it dynamically picks up any table that appears in it. Today I only seem to be able to manually select a table, so I would need to update my agent knowledge every day manually. Any tips on how I can achieve this?

5 comments

  • Avatar of Remi
    Remi
    ·
    ·

    Hello Thomas Van Sundert, you can put data in a Dust folder using the Dust API or the Make/Zapier integration. 😊

  • Avatar of Thomas Van Sundert
    Thomas Van Sundert
    ·
    ·

    But I can't add a query table folder? When adding a query table, I have to select them all individually

  • Avatar of Remi
    Remi
    ·
    ·

    If you push a table with the same id (I think it’s the title) it will overwrite the existing one without breaking the connection

  • Avatar of Thomas Van Sundert
    Thomas Van Sundert
    ·
    ·

    But I do want to keep the history as well

  • Avatar of Remi
    Remi
    ·
    ·

    If you can't add the history in the same table, you'll need to replug de new Gsheet everytime unfortunately :s