Google Sheets MCP Server

Pricing

Pay per event + usage

Google Sheets MCP Server

Google Sheets MCP Server provides seamless access to Google Sheets API, enabling AI assistants to create, read, update, and manage Google Spreadsheets programmatically.

Pricing

Pay per event + usage

Rating

0.0

(0)

Developer

👁 PowerAI

PowerAI

Maintained by Community

Actor stats

Bookmarked

Total users

Monthly active users

4 months ago

Last modified

Google Sheets MCP Server

The Google Sheets MCP Server provides seamless access to Google Sheets API, enabling AI assistants to create, read, update, and manage Google Spreadsheets programmatically. It simplifies integration of Google Sheets data into AI workflows and development environments.

About this MCP Server: To understand how to connect to and utilize this MCP server, please refer to the official Model Context Protocol documentation at mcp.apify.com.

Connection URL

MCP clients can connect to this server at:

https://powerai--google-sheets-mcp-server.apify.actor/mcp

Client Configuration

To connect to this MCP server, use the following configuration in your MCP client:

{
"mcpServers":{
"google-sheets":{
"url":"https://powerai--google-sheets-mcp-server.apify.actor/mcp",
"headers":{
"Authorization":"Bearer YOUR_APIFY_TOKEN",
"X-Google-Client-Id":"your-google-client-id",
"X-Google-Client-Secret":"your-google-client-secret",
"X-Google-Refresh-Token":"your-google-refresh-token"
}
}
}
}

Headers 说明：

Header	Description
`Authorization`	Apify API token (required)
`X-Google-Client-Id`	Google OAuth Client ID
`X-Google-Client-Secret`	Google OAuth Client Secret
`X-Google-Refresh-Token`	Google OAuth Refresh Token

Note: The Google credentials (X-Google-* headers) are stored per-session and used for all tool calls within that session. These headers are only required on the initial connection request.

Environment Variables

This MCP server requires the following environment variables:

Variable	Description
`GOOGLE_CLIENT_ID`	Google OAuth 2.0 Client ID
`GOOGLE_CLIENT_SECRET`	Google OAuth 2.0 Client Secret
`GOOGLE_REFRESH_TOKEN`	Google OAuth 2.0 Refresh Token

Obtaining Google Credentials

Go to the Google Cloud Console
Create a new project or select an existing one
Enable the Google Sheets API and Google Drive API
Go to "Credentials" and create an OAuth 2.0 Client ID
Set the redirect URI to http://localhost
Generate a refresh token using the OAuth flow

Available Tools

Tool	Description	Documentation
`google-sheets-create-spreadsheet`	Create a new Google Spreadsheet	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/create
`google-sheets-get-spreadsheet`	Get details of a Google Spreadsheet	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get
`google-sheets-list-spreadsheets`	List all accessible spreadsheets	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/get
`google-sheets-get-values`	Get values from a specific range	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/get
`google-sheets-update-values`	Update values in a range	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update
`google-sheets-append-values`	Append values to a sheet	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/append
`google-sheets-clear-values`	Clear values from a range	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/clear
`google-sheets-add-sheet`	Add a new sheet to a spreadsheet	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/batchUpdate
`google-sheets-delete-sheet`	Delete a sheet from a spreadsheet	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/batchUpdate
`google-sheets-rename-sheet`	Rename a sheet	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/batchUpdate
`google-sheets-copy-sheet`	Copy a sheet to another spreadsheet	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/sheets/copyTo
`google-sheets-batch-get-values`	Get values from multiple ranges	https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/batchGet

References

To learn more about Apify and Actors, take a look at the following resources:

Google Sheets Mcp

salesmart-srl/google-sheets-mcp

MCP server for Google Sheets integration. Read, write and format cells. Create spreadsheets and sheets. Append rows, clear ranges. Works with Claude, Cursor and any MCP-compatible AI assistant. Authenticate with Google Service Account.

Salesmart Srl

👁 Google Sheets MCP Server avatar

Google Sheets MCP Server

constant_quadruped/google-sheets-mcp-server

MCP server for Google Sheets. AI agents can read, write, and manage spreadsheets. 14 tools: cell/range CRUD, formulas, batch operations, JSON export, and sheet tab management. Service account or API key auth.

👁 User avatar

👁 Google Sheets Import & Export avatar

Google Sheets Import & Export

lukaskrivka/google-sheets

Import data from datasets or JSON files to Google Sheets. Programmatically process data in Sheets. Easier and faster than the official Google Sheets API and perfect for importing data from scraping.

👁 User avatar

Lukáš Křivka

3.9K

4.9

👁 Google Sheets Monitoring avatar

Google Sheets Monitoring

dtrungtin/google-sheets-monitoring

This actor will monitor the google sheets file and do actions correspondingly.

👁 User avatar

Tin

google-search

parse/google-search

👁 User avatar

parse

484

1.0

👁 Financial Datasets MCP Server avatar

Financial Datasets MCP Server

agentify/financial-datasets-mcp-server

This MCP server provides access to stock market data from Financial Datasets. It allows Claude and other AI assistants to retrieve income statements, balance sheets, cash flow statements, stock prices, and market news directly through the MCP interface.

👁 User avatar

agentify

👁 WordPress MCP Server avatar

WordPress MCP Server

extremescrapes/wordpress-mcp-server

A lightweight MCP server for WordPress automation. Enables REST API access for LLMs and agents to publish, update, and manage content programmatically using Application Passwords.

👁 User avatar

Extreme Scrapes

👁 Confluence MCP Server avatar

Confluence MCP Server

scraper_guru/confluence-mcp-server

A Model Context Protocol (MCP) server that enables AI assistants to interact with Confluence Cloud. Search pages, read content, create and update documentation, manage spaces — directly from Claude, Cursor, or any MCP client.

👁 User avatar

LIAICHI MUSTAPHA

👁 LinkedIn MCP Server - AI Assistant avatar