{"repo":"mkummer225/google-sheets-mcp","free":true,"listed":false,"github":"https://github.com/mkummer225/google-sheets-mcp","clone":"git clone https://github.com/mkummer225/google-sheets-mcp.git","description":"Google Sheets MCP Server 📊🤖","language":"JavaScript","stars":137,"topics":[],"license":"MIT","category":"mcp-servers","readme_excerpt":"Google Sheets MCP A Model Context Protocol (MCP) connector for Google Sheets that allows AI agents to interact with spreadsheets directly. Demo https://github.com/user-attachments/assets/cc4729d9-4e6e-437b-848b-6da9a09418c3 Setup 1. Clone this repository: 2. Install dependencies: npm install 3. Build: npm run build 4. Create OAuth credentials in Google Cloud Platform: - Create a new project in Google Cloud Console - Enable the Google Sheets API - Configure the OAuth consent screen - Create OAuth client ID credentials (Desktop application) with an appropriate redirect URI (ex: http://localhost:3000/oauth2callback) - Download the credentials and save as gcp-oauth.keys.json in the dist subdirectory 5. Start the MCP server (you'll automatically be prompted to authenticate/re-authenticate your Google account when necessary): npm run start Usage Sample config: Then you should be able to simply specify your spreadsheetId or ask your agent to create a new one for you. Available Actions Action Description -------- ------------- refresh auth Re-authenticate your Google Account when credentials expire list sheets List all sheets/tabs in a Google Spreadsheet create sheet Create a new sheet/tab in a Google Spreadsheet create spreadsheet Create a new Google Spreadsheet read all from sheet Read all data from a specified sheet read headings Read the column headings from a sheet read rows Read specific rows from a sheet read columns Read specific columns from a sheet edit cell Edit a single c","default_branch":null,"files":null,"tree":[],"storefront":"/r/mkummer225","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mkummer225/google-sheets-mcp/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}