What Can It Do?
- Read spreadsheet data from any range or entire sheets
- Write and update cells with new values or formulas
- Create and manage sheets within spreadsheets
- Format cells with bold, colors, font size, number formats, and alignment
- Manage rows and columns — insert or delete as needed
- Sort and find-replace data across ranges
- Create charts — bar, line, pie, scatter, area, and column charts from data
- Search and filter data based on conditions
Where to Use It
In Agents (Recommended)
Add Google Sheets as a tool to any agent. The agent can then work with your spreadsheets conversationally, choosing the right actions based on context. To add an MCP tool to your agent:- Open your agent’s configuration
- Click Add tools → Connect an app with MCP
- Search for the integration and select it
- Authenticate with your account
In Workflows (Via Agent Node)
For automated pipelines, use an Agent Node with Google Sheets tools. This gives you the flexibility of an agent within a deterministic workflow.As a Custom MCP Node
You can also create a standalone MCP node for a specific action. This generates a reusable node that performs one task, useful when you need the same operation repeatedly in workflows.- Go to your node library and search for the integration
- Click Create a node with AI
- Describe the specific action you want (e.g., “Read the sales data from column A”)
- Test the node and save it for reuse
Custom MCP nodes are single-purpose by design. For tasks that require multiple steps or dynamic decision-making, use an agent instead.
Available Tools
| Tool | Description |
|---|---|
| Create Sheet | Create a new Google Sheets document |
| Add Sheet | Add a new sheet tab to an existing spreadsheet |
| Get Spreadsheet Info | Retrieve spreadsheet metadata (title, sheets, etc.) |
| Get Sheet Names | List all sheet tab names in a spreadsheet |
| Batch Get | Read values from multiple ranges |
| Batch Update | Write values to multiple ranges |
| Append Values | Append values to the end of a range (like inserting rows) |
| Lookup Row | Search for a row by column value in a specified range |
| Clear Values | Clear values from a given range |
| Copy Sheet | Copy a sheet from one spreadsheet to another |
| Format Cells | Apply formatting to a cell range (bold, colors, font size, number format, alignment) |
| Manage Rows/Columns | Insert or delete rows and columns in a sheet |
| Manage Sheet | Rename or delete a sheet tab in a spreadsheet |
| Sort Range | Sort a range of cells by one or more columns |
| Find Replace | Find and replace values in a spreadsheet |
| Add Chart | Create a chart (bar, line, pie, scatter, area, column) from a data range |
Example Prompts
Use these with your agent or in the Agent Node: Read data:Troubleshooting
| Issue | Solution |
|---|---|
| Agent not finding the right data | Specify the spreadsheet name and sheet tab clearly |
| Action not completing | Check that you’ve authenticated and have edit access |
| Unexpected results | The agent may chain multiple tools (e.g., reading first, then writing). Review the agent’s reasoning to understand its approach. |
| Tool not available | Verify the tool is enabled in your agent’s MCP configuration |
Need Help?
- Agents documentation for setup and best practices
- Agent Node guide for workflow integration
- Gumloop Community for questions and examples
- Contact support@gumloop.com for assistance
Use this integration directly in Claude or Cursor. Connect remotely via the Google Sheets MCP server using your Gumloop credentials.