Pricing

Pay per event + usage

Try for free

Go to Apify Store

Google Sheets MCP Server

Try for free

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

5.0

(1)

Developer

PowerAI

Actor stats

Bookmarked

Total users

Monthly active users

3 days 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 Sheet MCP SERVER

bhansalisoft/google-sheet-mcp-server

Google Sheet MCP SERVER for unique tool for Google Sheet integration with all functionality on Any AI Tool

bhansalisoft

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

MCP Server Directory Scraper

consummate_mandala/mcp-server-directory-scraper

Scrape MCP server directories. Extract server names, capabilities, tool counts, authentication, and install methods.

Donny Nguyen

MCP Server Directory Scraper — 28K+ AI Servers

lovely_sequoia/mcp-directory-scraper

Scrape and aggregate MCP (Model Context Protocol) servers from glama.ai, PulseMCP, and mcp.so. The only unified MCP directory dataset on Apify.

Kris Jensen

Smithery MCP Scraper

consummate_mandala/smithery-mcp-scraper

Scrape Smithery MCP server registry. Extract server names, descriptions, tool lists, and deployment URLs.

Donny Nguyen

MCP YouTube Transcript - Video Transcripts & Chapters for AI

consummate_mandala/mcp-youtube-transcript

MCP server for YouTube transcripts. Extract timestamped text, metadata, and chapter markers. AI agent video analysis tool.

Donny Nguyen

AI Data Bridge: Multi-Database Connector

the.beast/ai-data-bridge

Stop juggling 7 different database tools. AI DataBridge connects PostgreSQL, MySQL, MongoDB, Airtable, Notion, and Google Sheets through a single MCP interface. Ask questions in plain English—get answers from any database instantly. AI database connector, multi-database integration

mr beast

5.0

(2)

Web Scraper

apify/web-scraper

Crawls arbitrary websites using a web browser and extracts structured data from web pages using a provided JavaScript function. The Actor supports both recursive crawling and lists of URLs, and automatically manages concurrency for maximum performance.

Apify

105K

4.7

(68)

Website Screenshot Generator

apify/screenshot-url

Create a screenshot of a website based on a specified URL. The screenshot is stored as the output in a key-value store. It can be used to monitor web changes regularly after setting up the scheduler.

Apify

4.4K

4.4

(14)

Instagram Leads Generator

caprolok/instagram-leads-generator

Extract verified emails, usernames, follower counts, and more from Instagram profiles using just a keyword and location. Perfect for building lead lists, finding influencers, or enriching contact data.