€12 Digital Guide · MCP Setup

Connect Google Sheets to Claude Desktop — complete MCP setup guide

Read, write, and create Google Sheets directly from Claude Desktop using the Model Context Protocol. Step-by-step for Mac and Windows — OAuth 2.0, both APIs, troubleshooting, and 5 integration templates included.

Get the guide — €12 → See what's inside
The Science Talk · Digital Guide
Connect Google Sheets to
Claude Desktop via MCP
01Install uv & uvx
02Create Google Cloud Project & Enable Both APIs
03Create OAuth 2.0 Credentials
04Configure OAuth Consent Screen & Test User
05Create Credentials Directory
06Configure Claude Desktop
07Launch & Authenticate
085 Integration Templates
thesciencetalk.com 8 steps · Mac & Windows
8
Clear setup
steps
~20
Minutes to
full setup
Mac & Windows
Full instructions
for both platforms
5 templates
Real-world integration
prompt templates
What this guide covers · Key highlights

Everything they don't tell you in the docs

The setup has several non-obvious steps where most people get stuck. This guide documents every one of them.

OAuth 2.0
Full OAuth walkthrough — the recommended path
Service accounts are often blocked by Workspace org policies. OAuth uses your personal login and bypasses this entirely. Full Cloud Console setup included.
Most common failure point — covered in detail
Two APIs required
Enable Google Sheets API AND Google Drive API
The MCP server requires both APIs. Enabling only Sheets causes silent failures with no useful error message. This guide covers both — step by step.
Silent failure — easy to miss
Token management
7-day token expiry — explained and solved
OAuth Testing mode tokens expire every 7 days. The guide explains why this happens and gives you the exact 30-second fix to re-authenticate without rebuilding anything.
Recurring issue — documented
uvx path
Use the full absolute path — not just "uvx"
Using "uvx" as a shorthand in the Claude Desktop config causes the MCP server to fail silently. The guide shows you how to find your exact path and where to place it.
Silent failure — documented fix
Integration templates
5 ready-to-use prompt templates
Read data ranges, append rows, create trackers, run analysis, and search across sheets — real-world prompts you can use immediately after setup.
Included with the guide
Troubleshooting
Every common error — with exact fixes
Hammer icon not appearing, "Access blocked" error, auth failures, permission denied, directory missing — each error is documented with the exact solution.
Full troubleshooting section
What's inside

8 steps to a working Google Sheets integration

From installing uv to your first authenticated read — every step documented for Mac and Windows, with all the pitfalls flagged in advance.

01
Install uv & uvx
Mac & Windows
One-line install for Mac (curl) and Windows (PowerShell)
Verify installation with uvx --version
Find the full absolute path (required for Step 7)
02
Google Cloud Project & APIs
Both APIs
Create a free Google Cloud project
Enable Google Sheets API
Enable Google Drive API (required — they don't auto-enable)
03
OAuth 2.0 Credentials
Desktop app type
Create OAuth Client ID (Desktop app type)
Download credentials JSON
Why OAuth over Service Account — explained
04
OAuth Consent Screen
Test user required
Configure External consent screen
Add yourself as a Test User
Why skipping this causes "Access blocked" error
05
Credentials Directory
Mac & Windows
Create ~/.config/mcp-gsheets/ directory
Move and rename credentials.json
Why the directory must exist before launch
06
Find Your Username
Paths & config
Get exact system username (whoami / echo %USERNAME%)
Why absolute paths are required (not relative)
Where your username appears — 3 places
07
Configure Claude Desktop
JSON config
Full claude_desktop_config.json with correct paths
command, CREDENTIALS_PATH, and TOKEN_PATH explained
Settings → Developer shortcut for opening config
08
Launch, Authenticate & Use
5 templates
Restart Claude Desktop and verify hammer icon
Browser OAuth flow — what to expect
5 ready-to-use prompt templates for Sheets
Written by

Built and tested end-to-end by a practitioner

This guide was written by Dr. Pranoti Kshirsagar — founder of The Science Talk, science communicator, and daily Claude Desktop user. Every step was built and documented from a real working setup, including the troubleshooting rabbit holes so you don't have to go down them.

9+
Years in digital
tools & science comms
250+
Scientists
supported
EIC
Official service
provider
What you can do once it's set up
→Read data ranges: "Show me all rows in Sheet 1 of [URL]"
→Write data: "Add a new row with today's date and value 500"
→Create sheets: "Create a new Google Sheet called Newsletter Tracker"
→Analyse data: "Summarise the data in columns A to D of [URL]"
→Search rows: "Find all rows where column C contains 'pending'"
€12 · One-time payment

Get the complete setup guide

Everything you need to connect Claude Desktop to Google Sheets — in one clear, tested PDF.

The Science Talk · Digital Guide
Connect Google Sheets to
Claude Desktop via MCP
01Install uv & uvx
02Create Google Cloud Project & Enable Both APIs
03Create OAuth 2.0 Credentials
04Configure OAuth Consent Screen & Test User
05Create Credentials Directory
06Configure Claude Desktop
07Launch & Authenticate
085 Integration Templates
thesciencetalk.com 8 steps · Mac & Windows
What's included

A single, well-organised PDF that takes you from zero to a working Google Sheets + Claude Desktop integration — with every pitfall documented and every error solved.

✓Complete OAuth 2.0 setup walkthrough — the recommended path for all users
✓Both Google APIs covered — Sheets and Drive (required, often missed)
✓5 real-world integration templates ready to use immediately
✓Full Mac and Windows instructions with exact commands
✓Troubleshooting section covering every common failure mode
✓Instant PDF delivery + email support included
Purchase — €12 →

Secure payment via Stripe. PDF delivered instantly after purchase.