Google Sheets is Google’s cloud-based spreadsheet application for data management and collaboration. The Google Sheets MCP server lets you read, write, and manipulate spreadsheet data using natural language.Documentation Index
Fetch the complete documentation index at: https://docs.gumloop.com/llms.txt
Use this file to discover all available pages before exploring further.
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.