Skip to main content
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.

​
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

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:
  1. Open your agent’s configuration
  2. Click Add tools → Connect an app with MCP
  3. Search for the integration and select it
  4. Authenticate with your account
You can control which tools your agent has access to. After adding an integration, click on it to enable or disable specific tools based on what your agent needs.

​
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.
To create a custom MCP node:
  1. Go to your node library and search for the integration
  2. Click Create a node with AI
  3. Describe the specific action you want (e.g., “Read the sales data from column A”)
  4. 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

​
Example Prompts

Use these with your agent or in the Agent Node: Read data:
Write data:
Append rows:
Search:
Get info:
Format cells:
Sort data:
Find and replace:
Create a chart:

​
Troubleshooting

Agents are smart enough to chain multiple API calls together. For example, asking “Update the total in my budget sheet” will read the current data first, then update. If results seem off, check the agent’s step-by-step reasoning.

​
Need Help?

Use this integration directly in Claude or Cursor. Connect remotely via the Google Sheets MCP server using credentials from your Connectors page.