Under maintenance

Pricing

Pay per usage

Try for free

Go to Apify Store

Google Sheets Mcp Server

Under maintenance

Try for free

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.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Actor stats

Bookmarked

Total users

Monthly active users

5 hours ago

Last modified

Features

Read/Write cells and ranges — single cells, ranges, or batch operations
Append rows — add data after existing content
Sheet management — create, delete, and list sheet tabs
Formula support — get and set formulas in cells
JSON export — export sheet data with automatic header detection
Batch operations — read/write multiple ranges in one API call
Flexible auth — service account (full access) or API key (read-only)
URL parsing — accepts spreadsheet URL or ID

Input

{
    "credentialsJson": "{ ... service account JSON ... }",
    "spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms",
    "toolCall": {
        "name": "sheets_read_range",
        "arguments": {
            "range": "Sheet1!A1:D10",
            "include_headers": true
        }
    }
}

Authentication Options

Parameter	Access Level	Description
`credentialsJson`	Full read/write	Google service account JSON (raw or base64)
`apiKey`	Read-only	Google API key

Spreadsheet Selection

Provide either:

spreadsheetId: The spreadsheet ID (from the URL)
spreadsheetUrl: Full Google Sheets URL (ID extracted automatically)

Tools (14)

Tool	Description
`sheets_read_cell`	Read a single cell value
`sheets_read_range`	Read a range with optional headers
`sheets_write_cell`	Write to a single cell
`sheets_write_range`	Write a 2D array to a range
`sheets_append_rows`	Append rows after existing data
`sheets_list_sheets`	List all sheet tabs
`sheets_create_sheet`	Create a new sheet tab
`sheets_delete_sheet`	Delete a sheet tab
`sheets_clear_range`	Clear values from a range
`sheets_get_formula`	Get formula from a cell
`sheets_set_formula`	Set formula in a cell
`sheets_to_json`	Export sheet as JSON (headers = first row)
`sheets_info`	Get spreadsheet metadata and stats
`sheets_batch_update`	Read/write multiple ranges in one call

Setup

Create a Google Cloud project
Enable the Google Sheets API
Create a service account and download the JSON key
Share your spreadsheet with the service account email
Pass the JSON key as credentialsJson in the actor input

Output

Each tool call returns a result with success: true/false and relevant data.

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 Server

powerai/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.

PowerAI

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 Directory Scraper - Scrape 10,500+ MCP Servers

lovely_sequoia/mcp-directory-scraper

Aggregate 10,500+ MCP (Model Context Protocol) servers from Glama.ai, PulseMCP, and mcp.so into one unified dataset. The only MCP directory aggregator on Apify. Includes cross-directory deduplication and optional 0-100 quality scoring via GitHub API.

Kris Jensen

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

(1)

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

108K

4.7

(71)

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.5K

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.

Caprolok

1.2K

3.6

(5)

All Social Media Posts Extractor (by Hashtag and Username)

caprolok/all-social-media-posts-extractor-by-hashtag-and-username

Effortlessly extract posts from Instagram, TikTok, YouTube, LinkedIn, and Twitter. Search by specific keywords and locations to quickly get structured results, including usernames, captions, engagement stats, and direct post links. Ideal for marketers, creators, and researchers.

Caprolok

245

Youtube Leads Generator

caprolok/youtube-leads-generator

Turn YouTube searches into verified lead lists. Extract channel names, emails, handles, and profile links using just a keyword and country. Perfect for sales, influencer outreach, PR, recruiting, and B2B targeting.

Caprolok

133

5.0

(1)