When I run an agent, how do I select the Google Sheet that I want the agent to append data to? I tried creating an action outside of the main process loop to select the Google Sheet that I want to update, but when I run the agent, there’s no option for selecting the actual spreadsheet that it should write to. I tried providing the instructions in the memories section of the settings, but also failed. The agent wrote the data to a completely different sheet than the one I instructed it to.
Hey Brandon - Thanks for sending! If you're using an Agent step, you can choose the URL for the sheet within the agent step. If that doesn't work, you can move the sheets action to outside of the agent step, which will provide you a side panel specifically for the append row action that will allow you to choose which sheet you'd like to use 🙂 Example in screenshot!
Alon J. there's no option to select the sheet from within the 'Google Sheets -> Append row' skill in the agent step. I thought I'd created a workaround, but it failed me when I presented live to about 80 people at a cybersecurity marketing conference on Monday.
Hi Brandon -- That's correct, you'll have to specify it in the prompt. As of now, there is no configuration that can be done in Agent Steps, other than prompting. If you'd like more customization, you can separate the action where you can have more control in the side panel! Let me know if that makes sense
Alon J. I did so in the prompt too, but it didn't execute what I asked it to do. I'll have to do what you just recommended.
