- Home
- Skills
- Workflow Automation
- Google Sheets MCP Automation
Works with the AI Agents you already use
Google Sheets MCP Automation
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
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:
- Created New Tab: Added
Q4 Pipelineto your spreadsheet. - 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
- 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
get_sheet_dataβ Read values from designated cell rangesupdate_cellsβ Write data to targeted cellsbatch_update_cellsβ Update multiple ranges or tabs in a single atomic callformat_google_sheetβ Custom fonts, sizes, text colors, and background highlightsadd_dropdown_validationβ Add dropdown selection lists to columnscopy_data_validationβ Duplicate validation rules across columnslist_sheetsβ View all tabs and dimensions inside a spreadsheetcreate_sheetβ Add new tabs on the flylist_spreadsheetsβ Search and discover spreadsheets in your Google Drivecreate_spreadsheetβ Generate brand-new spreadsheets from scratchshare_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.)
- 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
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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
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 forever
No account required to browse
Trust & safety
Security scan
Security scan passed 2 days ago
- Free with an Agensi account
Requires
Permissions
Allowed Hosts
File Scopes
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.