What it does
When Google Sheets is enabled on an agent, the agent can automatically perform spreadsheet actions as part of its reasoning process. You ask a question or give it a task — the agent decides when and how to use your Google Sheets account on your behalf.Prerequisites
You must have an active Google Sheets connection in your workspace before enabling this tool. If no active connection exists, the toggle is disabled.- Go to Integrations for your workspace.
- Find Google Sheets in the integrations grid.
- Click Connect and complete the OAuth flow.
- Return to your agent and enable the tool.
Adding the tool to an agent
- Open an agent in the editor.
- Click the button with the tooltip Add MCP Tool or Sub Agent.
- In MCP Tools, click Google Sheets. The Google Sheets node appears on the canvas.
- Click the node to open the Settings panel on the right.
- In the Authentication field, select the connected Google Sheets account the agent should use.
- If no active connection is found, the settings panel shows a warning with a link to Integrations to connect first.
Use cases
- Create a spreadsheet from structured workflow output.
- Search for a spreadsheet by name and read its sheet names.
- Append new rows after a workflow collects form responses.
- Update values in an existing range when a report is refreshed.
Notes
- The agent uses your connected Google Sheets account to perform actions. Make sure the OAuth connection has access to the spreadsheets your workflows need.
- This tool counts as 1 credit per action the agent performs.
- OAuth may show third-party authorization branding during the connect flow.
- If a previous connection stops working, reconnect Google Sheets in Integrations, then select the new account on the tool node.