Google Sheets
→
Anthropic Claude
GOOGLE SHEETS connector for Claude (MCP)
Ask Anthropic Claude about your Google Sheets data using all available fields — without exporting a single CSV.
- +500 Google Sheets fields plus calculated metrics — every dimension and breakdown Google Sheets reports.
- Your Google Sheets data already lives in Porter. Enable MCP and start asking Claude — no new integrations, no tokens, no servers.
- Cross your Google Sheets performance with Google Analytics 4 revenue in one Claude conversation to see real outcomes, not just clicks.
Free forever plan · 14-day full trial · No credit card
How to connect Google Sheets to Claude
-
Connect Google Sheets to Porter
Log in to Porter with your Google Sheets account and grant read-only access. Takes 2 minutes — no engineering, no exports.
-
Pick your ad account
Select one or blend multiple spreadsheets into a single data source — useful for agencies managing several clients.
-
Add Porter MCP to Claude
In Claude, paste the URL
https://mcp.portermetrics.com/mcpas a custom connector. No JSON-RPC, no local servers. -
Authorize Claude to read Porter
One click. Claude now has read-only access to your Google Sheets data through Porter — same scope as your Porter account.
-
Ask in plain English
“Show me Google Sheets performance trends over the last 14 days.” Claude returns a filtered table in seconds.
+500 Google Sheets fields, ready for Anthropic Claude
Every field in Google Sheets Manager — plus calculated metrics, every attribution window, and creative preview URLs — accessible to Claude on demand.
All Ads Manager fields (and more)
500 fields total — every native Google Sheets field plus calculated metrics that aren’t offered natively.
Every breakdown
Segment by campaign, ad set, creative, audience, placement, device, region, hour, date — every breakdown Google Sheets supports.
Creative previews and assets
Ad preview URLs plus links to creative assets — Claude can reason over performance + creative in the same answer.
Marketer-friendly naming
Fields named exactly as in Google Sheets (e.g. “Cost” not cost_micros). Claude understands them natively.
Full granularity
Hour, day, week, month, year — plus every dimension Google Sheets reports.
Cross-channel blending
Same field naming standard across Porter’s connectors — Claude can join Google Sheets with GA4, BigQuery, or other sources in one prompt.
Copy-paste prompts for Google Sheets × Claude
Add Porter MCP to Claude (paste https://mcp.portermetrics.com/mcp), open a new conversation, and paste any prompt below.
Budget Pacing Tracker
Open the 'Budget Tracker' tab in my Google Sheet. For each Campaign Name, compare total Spend in the last 30 days against the Monthly Budget column. Flag any campaign projected to exceed 100% of budget before month-end, and list them in order of urgency with current Cost per Conversion. Output as a ranked table with columns: Campaign Name, Spend MTD, Budget Remaining, Days Left, Projected Overspend %.Cross-Channel ROAS Comparison
In the 'Cross-Channel Summary' tab, filter data from the last 30 days. Group by channel (Meta, Google, LinkedIn) using Campaign Name prefixes. Calculate total Spend, total Conversions, and average Cost per Conversion for each channel. Write a 3-bullet summary of which channel has the best return and which needs attention, then output a comparison table with Channel, Spend, Conversions, CPA, and a ROAS score.Weekly Client Performance Summary
Using the last 7 days of data in the 'Performance' tab, write a short client update paragraph that mentions total Impressions, total Clicks, average CTR, and total Conversions. Identify the top-performing Campaign Name by Conversions and one metric that dropped week-over-week. Keep it under 100 words, formatted for copy-paste into a client email or Slack message.Creative Fatigue Detector
In the 'Creative Performance' tab, group rows by Campaign Name for the last 14 days. For each campaign, calculate CTR (Clicks / Impressions) and Cost per Conversion for Week 1 (days 1-7) versus Week 2 (days 8-14). Flag any campaign where CTR dropped more than 20% week-over-week or Cost per Conversion rose more than 25%. Output a table with Campaign Name, Week 1 CTR, Week 2 CTR, CTR Change %, Week 1 CPA, Week 2 CPA, and a fatigue alert flag.Attribution Comparison by Campaign
In the 'Attribution' tab, compare the last 30 days of data. For each Campaign Name, calculate total Spend, total Conversions, and Cost per Conversion. Then compare these numbers against the same campaign's data from the previous 30-day period. Flag campaigns where Conversions dropped more than 15% while Spend stayed flat or increased. Output a ranked list with Campaign Name, Period 1 Conversions, Period 2 Conversions, Change %, Spend Change %, and a recommended action.Multi-Account Agency Rollup
In the 'Agency Rollup' tab, filter the last 7 days. Group rows by client using the first segment of Campaign Name (e.g., 'ClientA_'). For each client, calculate total Spend, total Impressions, total Clicks, total Conversions, and CPC (Spend / Clicks). Compute CTR (Clicks / Impressions) for each client. Output a client scorecard table with Client, Spend, Impressions, Clicks, CTR, CPC, Conversions, and a status flag (green/yellow/red) based on whether Conversions met the prior week's average.Daily Anomaly Detection
In the 'Daily Metrics' tab, look at the last 30 days of data. For each Campaign Name, calculate the trailing 7-day average for Spend, Cost per Conversion, and Conversions. Compare yesterday's values against these averages. Highlight any campaign where Spend moved more than 20% up or down, Cost per Conversion moved more than 20%, or Conversions changed more than 25%. Output a ranked alert table with Campaign Name, Metric, Yesterday Value, 7-Day Average, Change %, and a suggested cause.Automated Budget Alert Trigger
In the 'Budget Tracker' tab, evaluate the last 7 days of Spend per Campaign Name. For each campaign, calculate the daily run rate and project it forward to month-end. Compare projected total Spend against the Monthly Budget. Create an alert list of campaigns projected to exceed 90% of budget within 5 days or 100% within 10 days. Include current Cost per Conversion and flag whether the campaign is accelerating or decelerating spend. Output as a priority-ranked table with Campaign Name, Projected Month-End Spend, Budget, Days Until 90%, and Alert Level.Audience Overlap Scanner
In the 'Audience Analysis' tab, filter the last 14 days. Group Campaign Names by audience segment (use the second segment of the name, e.g., 'Segment_Retargeting'). For each segment, calculate total Impressions, total Clicks, CTR, and total Conversions. Identify segments that appear in multiple campaigns with high overlap (similar Impressions and Clicks across campaigns). Flag segments where CTR differs by more than 30% between campaigns. Output an overlap matrix with Segment, Campaign A, Campaign B, Impressions A, Impressions B, CTR A, CTR B, and Overlap Risk.Video Drop-Off Analysis
In the 'Video Performance' tab, filter the last 30 days for campaigns with 'Video' in the Campaign Name. Calculate total Impressions, Clicks, CTR, and Conversions for each video campaign. Compare Week 1 (days 1-7) versus Week 4 (days 22-30) performance. Flag video campaigns where Impressions stayed flat or grew but CTR dropped more than 20% or Conversions dropped more than 25% over the month. Output a drop-off report with Campaign Name, Week 1 Impressions, Week 4 Impressions, Week 1 CTR, Week 4 CTR, Week 1 Conversions, Week 4 Conversions, Drop-Off Flag, and a recommended next step.Google Sheets MCP safety
Porter authenticates to Google Sheets with the read-only scope you already approved for your reports. Anthropic Claude queries Porter — not Google Sheets directly — so every conversation is rate-limited and cached at Porter side. No new permissions, no ban risk.
- Caching. Porter caches recent query results for 15 minutes per (account, field set) so repeated Claude prompts don’t hit the API again.
- Batching. Multiple field requests are merged into a single `spreadsheets.values.batchGet` call when possible (max 10,000 cells per call).
- Backoff & retry. Exponential backoff on 429 responses (1s → 2s → 4s → 8s).
- Per-account quotas. Porter tracks per-account daily usage and pauses queries before hitting 80% of the 300 req/min project quota.
- Read-only enforcement. Porter never requests write scopes from Google Sheets, so even compromised tokens cannot modify spreadsheet data, formulas, or sharing settings.
- Audited tools. The MCP exposes 6 read-only methods:
get_blend_id,list_accounts,list_categories,list_data_sources,list_fields,query_data.
GDPR compliant · 1,600+ marketers trust Porter with their Google Sheets data.
Start free. Pay per data source account
- +500 Google Sheets fieldsEvery native field plus calculated metrics — accessible to Claude in plain English.
- All attribution windowsCompare 1d-click, 7d-click, 28d-click and 1d_click+1d_view side by side from one connection.
- Same plan, every destinationSend to Anthropic Claude, ChatGPT, Looker Studio, Google Sheets, BigQuery and Slack — one subscription.
- Unlimited usersNo extra cost per team member or seat.
Number of Google Sheets spreadsheets
Billed annually · $12.5/account
Unlimited 14-day free trial + Free forever plan
Other connectors & destinations
Porter supports 15+ data sources and 10+ destinations. Mix and match in one subscription — no extra seats or hidden per-destination fees.
Questions about Google Sheets + Anthropic Claude
What is MCP and how does it connect Google Sheets to Claude?
Do I need technical skills or coding to set this up?
Will connecting my Google Sheets account get it banned?
What Google Sheets metrics can I analyze in Claude?
Can I create or edit campaigns from Claude, or is this read-only?
I already use Porter for Google Sheets reporting — do I need to reconnect?
How much does the Google Sheets MCP integration cost?
Chat with your Google Sheets data in Claude
Your Google Sheets data already lives in Porter. Enable MCP and start asking Claude about campaigns, creatives, and ROAS — no new integrations, no tokens, no servers. Get live, conversational access to all 500 Google Sheets fields including creative previews, every attribution window, and multi-account blends.
Free forever plan · 14-day full trial · No credit card