Automating Dust Agent Setup for Daily CSV Exports
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?