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.