Google Sheets MCP: No-Code SetupPorter Metrics gives Claude, ChatGPT and other AI clients one MCP server for the spreadsheets your team already keeps. MCP is the Model Context Protocol, the open standard AI apps use to reach other tools. Ask about a tab, then update it in the same chat. Range reads come straight from the live sheet.
Porter finds spreadsheets, reads tabs and ranges, writes values and appends rows, and puts your ad data next to them. The Claude-specific setup lives on the Google Sheets connector for Claude page.
Leads!A1:F500.One server, every spreadsheet you add: Porter connects Google Sheets to the AI clients, tabs, ranges and workflows marketing teams already use. The same Porter server URL works in Claude, ChatGPT and any MCP client that supports remote servers. Porter reads through Google’s Sheets API, so a range read shows the sheet as it is now.
Only one AI app?
Spreadsheets: spreadsheets you added · spreadsheet search by name · spreadsheet details · named ranges
Tabs and ranges: tab list with row and column counts · one range · several ranges · whole tabs
Spreadsheets and tabs: new spreadsheet · new tab · delete a tab
Values: write a range · append rows · clear a range · in-sheet formulas
Headers name the fields: a column headed Ad spend becomes the field sheets_source_ad_spend.
Metrics and dimensions: number columns are metrics · text and date columns are dimensions · a Date column lets Claude filter by date range
Sheets has no fixed field list: your header row is the list. Each one is in the full Google Sheets field reference.
The same Google Sheets connection also sends data to Data Studio (formerly Looker Studio), BigQuery and Google Sheets, at no extra cost.
A tab needs a header in its first row, and renaming a header renames its field. Google’s Sheets API usage limits allow 60 read and 60 write requests a minute per user. A request that runs past 180 seconds times out.
Porter’s Google Sheets MCP reaches only the spreadsheets you add and asks before it writes anything. Reading, writing, appending and clearing are separate actions. Overwrites, clears and tab deletes are flagged as permanent. An AI client working through Porter touches only as much of your Drive as the files you picked and the task allow.
You add spreadsheets with Google’s file picker, and Porter writes only to those. A spreadsheet Porter creates for you joins the list on its own. Every other file in your Drive stays out of reach.
Porter’s Sheets reads use Google’s drive.file scope. Google’s list of Sheets API scopes describes it as access to “only the specific Google Drive files you use with this app”, and recommends it.
Claude shows you the spreadsheet, the tab, the range and the values first. Porter writes to Google Sheets only after you say yes.
Logs and trackers grow with new rows under the last one, so last month’s numbers stay where they were. Writing a range replaces what’s in it, so Claude asks before it does.
Clearing a range removes its values and keeps formatting, data validation and other cell settings. Deleting a tab can’t be undone, so Claude names the tab and asks first.
Porter writes formulas that work on the spreadsheet itself, like SUM, VLOOKUP, IF and QUERY. Formulas that pull data from outside, like IMPORTRANGE, IMPORTDATA, IMPORTXML, IMPORTHTML, IMPORTFEED and IMAGE, are refused.
A shared sheet can hold text someone else typed, and Google’s own guide warns about indirect prompt injection. Every write still waits for your approval, so text in a cell can’t change your sheet on its own. The examples on this page use demo data.
Remove Porter from your Google account’s third-party access and the connection stops working at once. Nothing sits in a token file on someone’s laptop.
Porter’s Google Sheets MCP uses one server URL in every AI client, and you sign in with Google once. Claude takes Porter as a plugin or a custom connector. ChatGPT takes it through the Porter Metrics app or a custom MCP server. Either way, you finish by adding the spreadsheets Claude may use.
Use the Claude plugin for the guided setup, and Claude keeps the Porter plugin synced when new tools ship.
portermetrics/porter.portermetrics/porter.Anthropic’s guide to custom connectors using remote MCP walks through the same path, and custom connectors work on Free plans with a limit of one.
Click-by-click Google Sheets to Claude demo:
Use manual setup when Claude asks for a custom connector instead of a plugin.
Porter.https://mcp.portermetrics.com/mcp.
Use the Porter Metrics app for the fastest ChatGPT route.
OpenAI documents connected apps in ChatGPT and custom MCP servers in ChatGPT. The Google Sheets connector for ChatGPT page covers the ChatGPT side in full.
Click-by-click Google Sheets to ChatGPT demo:
Use the Porter MCP to get every new tool the day Porter ships it. It works on ChatGPT Business, Enterprise and Edu workspaces, and Pro accounts get read access, per OpenAI’s custom MCP server guide.
Porter and paste https://mcp.portermetrics.com/mcp under Connection.
Pick your coding agent. Each one uses the same server URL and a Google sign-in, so no API key or credentials file sits in a config.
/plugin marketplace add portermetrics/porter
/plugin install porter-metrics@portermetricsclaude mcp add --transport http porter https://mcp.portermetrics.com/mcp/mcp shows porter as connected. Ask: “Which Google Sheets accounts can you see?”mcp.json.{
"mcpServers": {
"porter": { "url": "https://mcp.portermetrics.com/mcp" }
}
}Ctrl/Cmd+Shift+P) and run MCP: Add Server → HTTP.https://mcp.portermetrics.com/mcp, name it porter and choose Global. Or add it to .vscode/mcp.json:{
"servers": {
"porter": { "type": "http", "url": "https://mcp.portermetrics.com/mcp" }
}
}codex mcp add porter --url https://mcp.portermetrics.com/mcpcodex mcp login portercodex mcp list shows porter as logged in. Start codex. Ask: “Which Google Sheets accounts can you see?”The same URL works in Windsurf, Cline, Zed and any client that supports remote MCP servers over HTTP.
Google’s own Sheets MCP server URL is:
Google’s guide to the Sheets MCP server covers its setup. It’s in Developer Preview and needs a Google Cloud project with an OAuth client you create. Use Porter’s URL to sign in with Google and get your ad data next to your sheets. Both go into the same MCP Server URL field, so the choice is the server, not the AI client.
The demos add Porter to the AI client, connect Google Sheets and ask the first question. Try this one once you’re connected:
List the tabs in my "Marketing 2026" spreadsheet with their row counts, then summarize the "Leads" tab by week for the last 4 weeks.Each Google Sheets skill in Porter’s MCP is a ready-made prompt for one spreadsheet job. A skill turns the sheets you already keep into a report, a check, a new row or a fresh spreadsheet. Copy a prompt into Claude or ChatGPT, then change the spreadsheet, tab and header names to match yours.
The research skills blend a tab with your ad accounts, so connect Meta Ads and Google Ads in Porter first.
Marketers who keep their plans, targets and logs in Google Sheets get the most from Porter’s Google Sheets MCP. Marketing managers, agencies, paid media teams and marketing analysts use it to turn a sheet into an answer, a fresh row or a scorecard. Nobody copies numbers by hand anymore.
Marketers whose source of truth is a spreadsheet.
Your boss isn’t asking what’s in the sheet. They’re asking whether the plan is on track.
One Google Workspace account, Sheets only, and you want to set formulas, insert rows or run structural edits from chat. Google’s server is first-party and covers that job well, once you’ve set up its Cloud project.
Google’s own Sheets MCP server and Porter’s MCP both connect Google Sheets to Claude and other AI clients. Google Workspace MCP servers gives each Workspace app its own server, Sheets included, in Developer Preview. Porter adds Google sign-in without a Cloud project, your marketing data, scheduled exports and skills.
Google’s server gives your AI deep edits inside one sheet. Porter’s MCP gives it your sheets next to the ads, site and store numbers that fill them.
Both are hosted, use one URL, sign in with Google and read and write cell values. Here is where they part.
| Porter | Google’s official server | |
|---|---|---|
| Same job, different reach | ||
| Status | Live | Developer Preview |
| Setup | Sign in with Google from the AI client | Developer Preview Program membership, a Google Cloud project, the Sheets MCP API and an OAuth client |
| Claude plan | Any plan with a custom connector, Free included | Claude Enterprise, Pro, Max or Team |
| Which files | The spreadsheets you add with Google’s file picker | The same files as your Google account |
| Writes | Values, appended rows, in-sheet formulas, new spreadsheets and tabs, after you approve | Values, formulas, row and column inserts, structural batch updates |
| Only one side | ||
| Ad platforms, GA4 and Shopify in the same answer | Yes, from Porter’s 30+ data sources | — |
| Blending sources into one number | Yes | — |
| Scheduled exports into a tab | Yes | — |
| Live dashboards at their own link | Yes | — |
| Data Studio and BigQuery | Yes | — |
| Skills: whole spreadsheet tasks, already written | Yes | — |
Google’s column follows Google’s Sheets MCP server guide and its tool list (as of November 2026).
Use Google’s own if you work in Sheets only, can run a Cloud project and want formulas, row inserts or structural edits from chat. Everything under Only one side is what happens when the sheet is one tool among several.
Google’s server signs in through an OAuth client you create yourself. You join the Google Workspace Developer Preview Program, open a Google Cloud project and enable the Sheets MCP API. Then you set up a consent screen and create a client marked “Use this client for an AI-powered agent”. Porter needs none of it: you sign in with Google and pick your files.
Plenty of them rank for this search, and they split three ways. The job tells you which one you’re looking at.
Porter reads, writes and fills your sheets with marketing data from one hosted server, starting on the free plan.
The Google Sheets MCP is included in every Porter plan, the free-forever plan too. Reporting is billed per connected account.
Reporting price for connected accounts, in USD. AI chats, queries and dashboards are unlimited. Annual billing is 10 months for 12.
The more accounts you connect, the lower the price per account. See the full calculator on Porter pricing.
Yes. Google runs its own Sheets MCP server at https://sheetsmcp.googleapis.com/mcp/v1, in Developer Preview, set up through a Google Cloud project and an OAuth client. Porter's Google Sheets MCP runs at https://mcp.portermetrics.com/mcp with a plain Google sign-in. Porter also adds your ad, GA4 and Shopify data, scheduled exports and skills.
Porter's Google Sheets MCP server URL is https://mcp.portermetrics.com/mcp, and Google's own is https://sheetsmcp.googleapis.com/mcp/v1. Paste either one into Claude, ChatGPT or another AI client as a custom connector. The URL decides which server answers, whatever client you use.
Porter's Google Sheets MCP is included in every Porter plan, the free-forever plan too. The free plan covers unlimited connected accounts, up to 30 days of history, 15 days in AI chats and 100 automation credits a month. Paid Reporting starts at $12.50 a month per data source account, billed annually.
Porter writes values, appends rows, clears ranges and adds spreadsheets and tabs, with in-sheet formulas like SUM or VLOOKUP. You format cells, build charts and insert rows in Google Sheets as usual. Google's own server also lists formula, row insert and structural update tools if you want those from chat.
Install the Porter plugin from Claude Settings → Customize → Plugins. Add the portermetrics/porter marketplace, install Porter Metrics from the Directory and sign in with Google. Add your spreadsheets in Google's file picker, then ask Claude about a tab.
Yes, several open-source Google Sheets MCP servers live on GitHub. You download one, create your own Google credentials and host it on your machine. Porter is hosted instead: you sign in with Google, and Porter keeps the server current when Google changes the API.
MCP is the Model Context Protocol, an open-source standard for connecting AI applications to external systems like Google Sheets. MCP isn't the agent. Claude and ChatGPT are the agents, and Porter's MCP is how they reach your spreadsheets.
Porter builds a tab's fields from its header row when the tab is first pulled in, so a column added later needs the tab pulled in again. Do that in app.portermetrics.com. Meanwhile, ask Claude to read the range directly, which always shows the current columns.
Porter reads values as your sheet displays them, and in report queries dates come back as YYYYMMDD text and numbers with a decimal, like 73.0. A renamed header also renames its field, so an older prompt can miss it. Ask Claude for the current headers and compare by range.
Porter writes only to spreadsheets you added to the connection. Ask Claude to connect Google Sheets, click Add Sheets next to your Google account and pick the spreadsheet in Google's file picker. Then ask again, and approve the write when Claude shows it.
Connect Google Sheets to Claude or ChatGPT and start with tab summaries, weekly logs and writes that wait for your approval.
Start free: unlimited connected accounts, no credit card. Or take the 14-day trial with everything unlimited.