Overview:
We need to be able to create a google sheet and then add to that google sheet rows of data within the same agent.
Use Case:
We would like to create a net new spreadsheet from an agent, then within the looping subagent, add 10 rows of information at a time to that newly created spreadsheet. This allows us to not require an aggregation of data at the end of the looping agent where we frequently hit token limits.
Recommended Solve:
In the create spreadsheet step, allow this to be tokenized to be referenced in the add to spreadsheet action.