Google Sheets API MCP Server

Created By
mattcoatswortha year ago
Overview

What is Google Sheets API MCP Server?

Google Sheets API MCP Server is a comprehensive Model Context Protocol (MCP) server designed for interacting with the Google Sheets API, providing tools for managing spreadsheets, sheets, values, and developer metadata.

How to use Google Sheets API MCP Server?

To use the server, clone the repository, install the dependencies, set up your Google API credentials in a .env file, and run the server using npm start.

Key features of Google Sheets API MCP Server?

  • Create, read, update, and delete spreadsheets
  • Manage sheets within spreadsheets
  • Read, write, append, and clear values
  • Work with developer metadata
  • Access spreadsheet data through MCP resources

Use cases of Google Sheets API MCP Server?

  1. Automating spreadsheet management tasks
  2. Integrating Google Sheets with other applications
  3. Building custom tools for data analysis and reporting

FAQ from Google Sheets API MCP Server?

  • What are the prerequisites for using this server?

You need Node.js 16 or higher, a Google Cloud Platform project with the Google Sheets API enabled, and OAuth 2.0 credentials.

  • How do I run the server?

You can run the server by executing npm start after setting up your environment.

  • Can I manage multiple spreadsheets?

Yes! The server allows you to create and manage multiple spreadsheets and their respective sheets.

Project Info
Created At
a year ago
Updated At
a year ago
Author Name
mattcoatsworth
Star
0
Language
JavaScript
License
-

Recommend Servers

View All
Fixmypdf

17 hours ago
Ghl Command
@Elite DCs LLC

GoHighLevel MCP server for Claude. 212 tools across 43 modules, including the only programmatic GHL workflow builder (private API, reverse-engineered), funnel + page editor, form builder, pipeline builder, pre-deploy validator, multi-sub-account switching, bulk operations, and full account export. $97 one-time, lifetime updates. GHL Command gives Claude full programmatic control of GoHighLevel through 212 tools across 43 modules. Built for GoHighLevel agency operators who manage many client sub-accounts and want to onboard new clients in minutes instead of days. Exclusive capabilities (none of the free GHL MCPs have these): - Programmatic workflow builder. Create, edit, clone, publish, and validate complete GHL workflows from a single prompt. GHL's public API has no workflow write endpoints; this uses their internal API (the same one their UI calls). - Funnel + page editor and form builder (also private API). - Pipeline builder, goal event builder, full 57-native-trigger registry. - Pre-deploy validator that catches GHL's silent invalid-ID failure (a common workflow-breaking bug GHL never warns you about). - Multi-sub-account token registry. Switch between any client account mid-conversation; API keys swap automatically. - Bulk operations: tag, update, enroll, delete hundreds of contacts in one command. - Full account export and side-by-side location diff for audit or migration. Works with Claude Desktop App, Claude Code (terminal), and headless on a Linux server or droplet. $97 one-time, 3 machines, no subscription, lifetime updates. 30-day time-back guarantee: save 5+ hours on one real client build or full refund.

a day ago