Integration · Productivity
Connect Claude & ChatGPT to Google Sheets
Give your AI a spreadsheet link and ask what is in it, which rows need attention, or to add today's numbers. It can read and write cell ranges, append rows under a table, create new spreadsheets and change tabs, sorting and formatting. Your sheets stay the place where the data lives, and you stop copying values back and forth by hand.
Free plan, no credit card. Takes about a minute.
Try asking
“Here is our budget sheet. Which lines are over budget?”
The AI takes the spreadsheet ID from the link, reads the tab names and the cell values, and points out the rows where actual is above budget.
“Add today's three new leads to the Leads tab.”
It appends three rows after the last row of the table. Existing data is not overwritten.
“Set the status in D14 to Paid and the date in E14 to today.”
It writes to those cells as if you had typed the values, so dates and formulas are parsed the usual way.
What your AI can do
Read cells and tabs
Get a spreadsheet's title and tabs, and read cell values from any range in A1 notation, like A1:D50 on the tab you name.
Write and append
Overwrite a range, write several ranges in one call, append rows under a table, or clear a range while keeping its formatting.
Structure and formatting
Create spreadsheets, add, rename, sort or delete tabs, apply formatting and copy a tab to another spreadsheet.
“Create a spreadsheet called Q4 campaigns with tabs for Leads and Spend.”
It creates the new spreadsheet with the two tabs and gives you its ID.
“Sort the Orders tab by date and add a tab called Archive.”
It sends a structure update that sorts the range and adds the new tab.
“Copy the Template tab into the 2027 budget spreadsheet.”
It copies the tab into the other spreadsheet, where it shows up as a new tab.
9 tools for Google Sheets
These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.
append_rowsChanges dataAdd rows after the last row of a table, e.g. `range` = `Sheet1!A1`, `values` = list of rows. Set `value_input_option` to USER_ENTERED. Existing data is not overwritten.clear_rangeChanges dataClear all values in a range (formatting stays), by `spreadsheet_id` and `range`; pass `body` as an empty object. The cleared values cannot be restored by this tool.copy_sheet_to_spreadsheetVisible to othersCopy one sheet tab (`sheet_id`, the numeric tab ID) from `spreadsheet_id` into another spreadsheet given as `destination_spreadsheet_id`.create_spreadsheetChanges dataCreate a new spreadsheet. Set the title in `properties.title`; optionally add sheet tabs in `sheets`.get_spreadsheetGet a spreadsheet's title and its sheet tabs (names, IDs, sizes) by `spreadsheet_id`. Leave `include_grid_data` off; use read_range to read cell values.read_rangeRead cell values from one range in A1 notation, e.g. `Sheet1!A1:D50`, by `spreadsheet_id` and `range`.update_spreadsheet_structureVisible to othersChange a spreadsheet's structure or formatting with Sheets `requests` (e.g. addSheet, deleteSheet, updateSheetProperties, repeatCell, sortRange). Pass the spreadsheet ID as `batch_update_id`. Requests like deleteSheet remove data permanently.write_rangeChanges dataOverwrite the cells in one range with `values` (a list of rows). Set `value_input_option` to USER_ENTERED so formulas and dates are parsed like typed input. Existing values in that range are replaced.write_rangesVisible to othersWrite several ranges in one call: `data` is a list of {range, values}. Set `value_input_option` to USER_ENTERED. Replaces existing values in those ranges.
Set up in three steps
- 1
Pick the app
Create a free PipMCP account and choose Google Sheets from the app list.
- 2
Paste your key
Paste the OAuth client ID and client secret from your own Google Cloud project, then sign in with Google once. In the Google Cloud console create a project and enable the Google Sheets API (APIs & Services > Library). Set up the OAuth consent screen as Internal for Google Workspace, or as External and then click Publish app, because apps left in Testing get refresh tokens that expire after 7 days. Then go to Credentials > Create credentials > OAuth client ID > Web application, add the redirect URI https://pipmcp.com/oauth/callback and copy the client ID and secret. PipMCP renews access automatically after that.
- 3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
Click your name, then Settings › Connectors › Add custom connector. Paste your link as the Remote MCP server URL. Switch it on from the + menu in a chat.
Questions
What can the AI do in Google Sheets?
It can read a spreadsheet's tabs and the values in any range. It can write to one or several ranges, append rows, clear ranges, create spreadsheets, change the structure and formatting with Sheets requests such as addSheet, sortRange or deleteSheet, and copy a tab to another spreadsheet.
Does the AI see my Google Sheets credentials?
No. Your OAuth client secret and the access from your Google sign-in are encrypted at rest and never shown to the AI. After you save them, they are not shown again, not even to you. The AI only sees the results of the tools it calls.
Can I control what the AI is allowed to do?
Yes. You choose which tools are switched on, so you can start read-only. Writing to a range replaces what is there, a cleared range cannot be restored by the tool, and deleting a tab removes its data permanently, so these tools can require your approval before they run. Every tool call is logged.
Does it work with ChatGPT?
Yes. In ChatGPT go to Settings › Apps & Connectors › Advanced and turn on Developer mode, then add your PipMCP link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.
What does it cost?
Google Sheets connects with OAuth, and OAuth connections need the PipMCP Pro plan or above. PipMCP also has a free plan with no credit card, but it does not include this connection. Paid plans bill per completed task. You also need your own Google account.
Can the AI find a spreadsheet by its name?
Not with Google Sheets alone. The Sheets API cannot list or search spreadsheets, so you give the AI the spreadsheet link or the ID from the URL. If you also connect Google Drive, the AI can search for the file there first.
Let your AI work in Google Sheets today.
Start free. Your key stays encrypted, and you decide what the AI may do.
Connect Google Sheets freePipMCP is not affiliated with Google Sheets. Product names are trademarks of their owners.