Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIDeepSeekDeepSeekMuseMuse+22 more

    Google Sheets MCP Automation

    1

    Connect your AI agent to Google Sheets. Read, write, format cells, create tabs, add dropdown validations, and batch update data with 11 native MCP tools.

    Free

    Security scanned
    Google Sheets MCP Automation

    Google Sheets MCP Automation

    Example session with this skill installed

    Connect to my Google Sheet and create a new tab called "Q4 Pipeline".

    Add these columns: Lead Name, Deal Size, Status, Close Date.

    Populate it with 3 sample enterprise deals ($15,000 to $45,000), add a dropdown validation in the Status column with options ["Qualified", "Proposal Sent", "Negotiation", "Closed Won"], and format the header row with a dark navy background and bold white text.

    • Read your context and instructions
    • Compiled the google sheets mcp

    I have connected to your Google Sheet and configured the "Q4 Pipeline" tab:

    1. Created New Tab: Added Q4 Pipeline to your spreadsheet.
    2. Inserted Deal Data (A1:D4):
      • Acme Corp β€” $28,000 β€” Proposal Sent β€” 2026-12-15
      • Apex Logistics β€” $42,000 β€” Negotiation β€” 2026-12-22
      • Nexus Cloud β€” $15,500 β€” Qualified β€” 2027-01-10
    3. Added Dropdown Validation: Configured column C (Status) with options:
      ["Qualified", "Proposal Sent", "Negotiation", "Closed Won"]

    Formatted Header: Styled row A1:D1 with bold white text, centered alignment, and a dark navy background (#1A2B4C).

    Your live Google Sheet has been updated!

    Connects securely to your tools. The creator never sees your data.

    About this skill

    πŸ“Š Google Sheets MCP Automation

    Connect any AI assistant (Claude, Cursor, ChatGPT, Codex, Windsurf, or VS Code) directly to Google Sheets using the Model Context Protocol (MCP).

    Stop writing one-off Python scripts or exporting messy CSVs. Now your AI agent can read, update, format, and organize live spreadsheets directly from your conversation.


    πŸš€ What This Skill Does

    • πŸ“– Read & Query Data: Read any range or entire columns using standard A1 notation.
    • ✏️ Write & Batch Update: Insert rows, update cell blocks, and batch-update multiple tabs atomically without hitting API limits.
    • 🎨 Visual Cell Formatting: Apply fonts, bold styling, alignments, and custom RGB background/text colors.
    • πŸ“‹ Dropdown Data Validation: Automatically generate strict dropdown menus to prevent bad data entry.
    • πŸ“‚ Spreadsheet Management: Create new Google Sheets, add new tabs, and share sheets with specific permissions directly via chat.
    • πŸ”„ Auto Token Refresh: Access tokens refresh automatically in the backgroundβ€”zero manual maintenance required.

    🧰 11 Native MCP Tools Included

    1. get_sheet_data β€” Read values from designated cell ranges
    2. update_cells β€” Write data to targeted cells
    3. batch_update_cells β€” Update multiple ranges or tabs in a single atomic call
    4. format_google_sheet β€” Custom fonts, sizes, text colors, and background highlights
    5. add_dropdown_validation β€” Add dropdown selection lists to columns
    6. copy_data_validation β€” Duplicate validation rules across columns
    7. list_sheets β€” View all tabs and dimensions inside a spreadsheet
    8. create_sheet β€” Add new tabs on the fly
    9. list_spreadsheets β€” Search and discover spreadsheets in your Google Drive
    10. create_spreadsheet β€” Generate brand-new spreadsheets from scratch
    11. share_spreadsheet β€” Share sheets with team members by email

    πŸ“¦ What’s in the Package

    • SKILL.md β€” The complete agent instructions and execution playbook.
    • mcp_server.js β€” The production-ready Node.js MCP server.
    • generate_token.js β€” One-click OAuth 2.0 token generator.
    • reference/google-cloud-guide.md β€” Foolproof, step-by-step Desktop OAuth setup guide (no domain verification required).
    • reference/tools-reference.md β€” Complete reference manual with input schemas and example prompts.

    ⚑ Requirements

    • Node.js 18+
    • A free Google Cloud account (guided step-by-step in the package)
    • Any MCP-compatible AI agent (Claude, Cursor, Codex, etc.)

    Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Workflow Automation.

    • Requires a one-time Google OAuth login in the browser to generate access and refresh tokens.
    • Subject to standard Google Sheets API rate limits (recommended to use batch_update_cells for large multi-cell operations).
    • Connects specifically to Google Sheets and Google Drive; does not support offline Microsoft Excel (.xlsx) files without importing them to Drive first.
    • Requires Node.js 18+ installed on the local machine to run the MCP server.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before buying a skill.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Free to use

    No account required to browse

    Trust & safety

    Security scan

    Security scan passed 2 days ago

    • Free with an Agensi account

    Accounts
    Google AccountGoogle Cloud Account (Free)
    Software
    Node.js 18+Google Sheets API enabled
    Optional
    Google Drive(needed only for list_spreadsheets and share_spreadsheet)

    Includes a foolproof step-by-step guide (reference/google-cloud-guide.md) to set up free Desktop OAuth credentials in 2 minutes with zero domain verification.

    Permissions

    Terminal / Shell
    Write Files
    Read Files
    Browser
    Network Access
    Environment Variables

    Allowed Hosts

    accounts.google.com
    drive.googleapis.com

    File Scopes

    .env
    ./*

    Terminal/Shell is used to run the local Node.js MCP server. Network access communicates securely with Google Sheets and Drive APIs over HTTPS. File read/write permissions are strictly limited to the local .env file to store and automatically refresh OAuth tokens.

    Listed3 days ago

    What's inside

    Frequently Asked Questions

    No. A 100% free Google Cloud account is all you need. Google Sheets and Google Drive APIs offer generous free tier quotas that are more than enough for daily automation and queries.

    No. During the initial setup, Google grants a refresh_token. The server automatically uses this refresh token in the background to fetch fresh access tokens silently, so you never have to re-authenticate manually.

    By default, operations target the specific sheet_id you set in your .env. However, you can instruct the agent to operate on any spreadsheet your Google account has access to by providing its URL or ID, or use list_spreadsheets to browse files in your Drive.

    It works with any client supporting the Model Context Protocol (MCP), including Claude Desktop, Claude Code, Cursor, Codex CLI, Windsurf, and VS Code (via Cline/Copilot). Requires Node.js 18+.

    New in Workflow Automation

    Free