How to Select the Correct Google Sheet for Your Agent to Update

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.