Hi Lindy Support, I'm working with a custom agent in my workspace that uses the following Google Sheets functions: GoogleSheets-get-spreadsheet-by-id GoogleSheets-copy-worksheet GoogleSheets-updateColumn The agent analyses the transcript of a recording, sorts the information, retrieves the correct spreadsheet, copies an existing worksheet within that spreadsheet, and updates the columns with the new data. The agent works fine except it keeps retrieving an old spreadsheet which I used to test it instead of the spreadsheet ID that it's been given. The spreadsheet ID is in a shared drive. When attempting to call GoogleSheets-get-spreadsheet-by-id, I receive an error stating the ID is invalid — the function appears to be restricted to a predefined list of spreadsheet IDs via a sheetId schema constraint. Is there a away I can configure this predefined list? Or a reason it's overriding the spreadsheet ID that's been given? Thanks in advance, would appreciate any insight/advice.
Hey Josh! If you could share the task URL of the example that's pulled the incorrect Spreadsheet, I can take a look. That will help me visualize what's going on 🙂
Thanks!
Hey Josh! Ah, apologies. I see you have two agents with two respective spreadsheets:
Charlotte Koff KPIs
Charlotte Koff Account Management
Within those agents, you have the 'update column' actions. Are you looking to update columns within both of those spreadsheets? Which spreadsheet is it updating that's old? Is it one of those or a different one?
I'm looking to update two different spreadsheets in one workflow. The issue is that I originally copied all the spreadsheets to a different folder to test the process, so it wouldn't mess up the originals. But now I've updated the spreadsheet IDs to the correct spreadsheets (which are on a shared drive) it keeps defaulting to the 'test' spreadsheets. Even though there's no record of them left in the workflow. I've tried uploading the correct spreadsheets to the knowledge base too but it keeps reverting back to the old 'test' ones. It says something about it being restricted to it's pre-defined list.
Oh interesting 🤔 A couple things you could try:
You could change the 'Get Spreadsheet by ID' skill to the 'Get Spreadsheet' skill instead ->
You could also try using the 'Get Spreadsheet' action before the AI Agent. This will allow you to input the specific spreadsheet within the field so you don't have to prompt it.
You can also try using its own action for 'copy spreadsheet', right after the 'Get Spreadsheet' action
Hey, thanks for the help. I ended up putting the copy spreadsheet function outside the agent, didn't need the get spreadsheet function in the end, I was making it overly complicated.
