Free guide · part of the Claude Code Course
Get the full Claude Code Course
Every build, every prompt, the security setups, and every future section — yours forever for one payment. This guide is a free taste of what’s inside.
Google Sheets + Claude Code Setup
I just hooked Claude Code into Google Sheets so it can read and update any sheet I share with it. Free, takes 10 minutes, and you never type a row by hand again.
By Ryan Frizelle · 5 min read
I just connected Claude Code to Google Sheets and now I never touch a spreadsheet by hand again. I tell Claude what I want, it updates the sheet. That simple.
Here is what you will do:
- 1.Create a free service account in Google Cloud. This is the email Claude will use to log into your sheets.
- 2.Share any Google Sheet with that service account email.
- 3.Tell Claude Code to read and update the sheet from now on, just by talking.
100% free. You do not need a paid Google Cloud tier or a credit card on file. Your sheets stay exactly where they are. Only the service account email you create gets access.
Wire Claude Code into your Google Sheets
Help me connect Claude Code to my Google Sheets so I can read and update sheets just by talking to you. I am not a developer. Walk me through every step.
Here is what I need from you:
1. Tell me exactly what to do in Google Cloud Console (console.cloud.google.com) to:
- Create a new project (or use one I already have)
- Enable the Google Sheets API and the Google Drive API
- Create a service account named "sheets-bot"
- Generate a JSON key for that service account and download it
- Give me the service account email so I can share my sheets with it
2. Once I have the JSON key file, help me set up Claude Code to use it. In whatever project I am working in:
- Create a file at scripts/sheets.mjs that uses the googleapis npm package to read, write, append, clear, and inspect Google Sheets
- Add my service account email and private key to a .env.local file at the project root, never commit it to git
- Add .env.local to .gitignore if it is not already there
- Install the googleapis package with npm
3. Test it together. After everything is wired up:
- Show me how to share a Google Sheet with my new service account email (Editor access)
- Read 5 rows back from any sheet I share with you, to prove the connection works
- Tell me the exact way I should phrase requests from here on out (for example, "add a row to my Q4 sheet with today's revenue")
Walk me through it one step at a time, wait for me to finish each step before moving to the next, and explain what every command does in plain English. If I get stuck on anything, give me the exact fix.Liked this? There's 50x more in the course.
One-time purchase. Keep forever.
That prompt is the whole setup. Claude walks you through Google Cloud step by step. Builds the script in your project. Saves your key into a .env.local file. Installs the npm package. Tests the whole thing live with you. You go from zero to a working sheets bot in about 10 minutes.
What that unlocks is wild. I stopped opening Google Sheets to type. Instead I tell Claude things like "add a row to my Q4 revenue sheet with today's number," or "pull the last 30 rows of my email list and tell me how many duplicates we have." Claude does it in seconds, then tells me what landed. The sheet updates live, and I never left my terminal.
Here is what you will see when you do the Google Cloud part, so nothing surprises you:
- 1.A free Google Cloud project. New users get $300 in free credits, but you will not use a single cent for Sheets. It is genuinely free.
- 2.Two APIs to enable. The Sheets API and the Drive API. One click each.
- 3.A service account. Think of it like a fake user that only Claude controls. You give it a name (something like "sheets-bot") and that is it.
- 4.A JSON key file. Google downloads it to your computer when you create the key. That file is your password. Treat it like one.
- 5.Two fields to copy from the JSON. The client_email and the private_key. Both go into a .env.local file at the root of your project, where the service account credentials live.
Update your sheet by just talking to Claude Code
Add a row to my Google Sheet at [PASTE YOUR SHEET URL HERE]. The row should contain [WHAT YOU WANT TO ADD, for example "today's date, $1,200 in revenue, and a note that says 'first big day this month'"].
Use my scripts/sheets.mjs script and the service account I already set up. After you add it, read me back the last 3 rows so I know it landed correctly.That single prompt updates the sheet for you. No clicking into cells. No tab switching. You stay in Claude Code and the spreadsheet just updates in the background. From the sheet's side, it looks like a teammate typed it. From your side, you said one sentence.
Pro move. Once it works, you can ask Claude for anything. "Make me a fresh sheet that tracks my YouTube views every Sunday." "Add today's revenue to my Q4 sheet." "Pull every email signup from last week and dedupe it." Claude just does it.
One thing to know. Your service account email is fine to share. It is just an address. The JSON key file is not. Treat it like a password. Never commit it to git, never paste it into a public chat. Claude Code sets up your .gitignore correctly when you run the install prompt above, but it is worth knowing yourself so you never slip.
That is the whole thing. Make a service account. Share your sheet. Run the prompt. Now Claude Code IS your spreadsheet team. No more clicking between tabs. No more typing rows by hand. You just say what you want, and the sheet updates. Forever.
Want more skills like this that turn Claude Code into your personal operator?
Liked this? There's 50x more in the course.
One-time purchase. Keep forever.
Keep going
More walkthroughs from the library.
Microsoft Clarity + Claude Code Setup
Connect Microsoft Clarity to Claude Code. Your site gets smarter off real user behavior, dead clicks, rage clicks, and session replays you can act on.
Dashboard Builder Prompt
One prompt that scaffolds a complete dashboard with auth, sidebar navigation, and data tables. Deploy it in under 30 minutes.
Make Claude Code Know You
The exact Obsidian + Claude Code setup that gives your AI context on your actual life. Free. 10 minutes. Includes a starter vault and the prompts that make it work.