On this page7
Connect Google Sheets to Claude by authorizing your Google account once via OAuth inside Otto and adding Otto's hosted HTTP MCP server (https://otto.islaintel.com/api/mcp) to Claude with a single otto_mcp__ token—or configure Google's Developer Preview Sheets MCP server in Google Cloud. In Otto MCP, Google Sheets is strictly read-only across 227 tools and 15 integrations, letting you reconcile KPI tabs against live GA4, Shopify, Search Console, and paid ads while cutting Claude token usage by 80–90% versus 3,000-row CSV uploads.
Copy-paste Claude prompts for Google Sheets KPI reporting and cross-channel ops (start here)
Once connected through Otto MCP, paste these five prompts directly into your chat:
- Inspect tabs and KPI targets: List worksheets, then pull
Targets!A1:G50withmajorDimension=ROWS. - Reconcile revenue and CAC: Read
KPIs!A1:E25, query Shopify net sales and GA4 engaged sessions by landing page, and table pacing vs. target. - Audit paid media pacing: Read
Pacing!A1:F15, compare seven-day spend on Meta Ads, LinkedIn Ads, X Ads, ChatGPT Ads, and Google Ads, and flag over/under pacing. - Compare Search Console to content plan: Match top Search Console queries to
Content_Plan!A1:D30and draft a WordPress post for the best gap keyword. - Audit Core Web Vitals: Run
psi_analyze_urlon URLs inConversion_Tracker!A2:B12and list pages below 80 on mobile speed.
Exporting CSVs by hand vs. Google's Developer Preview Sheets MCP vs. Claude + Otto MCP
| Feature / Capability | Manual CSV Uploads | Google Developer Preview Sheets MCP | Claude + Otto MCP Gateway |
|---|---|---|---|
| Setup complexity | None. Manual download from Google Sheets, Ads Manager, and GA4 every Monday. | High. Requires Google Workspace Developer Preview Program membership, Google Cloud project, and OAuth 2.0 Web client. | Low. Connect Google account once via OAuth inside Otto; paste one endpoint and token into Claude. |
| Connection endpoint | None (file attachment). | https://sheetsmcp.googleapis.com/mcp/v1 via Google Cloud. | https://otto.islaintel.com/api/mcp remote HTTP server. |
| Token efficiency | Low. Full spreadsheet and Ads Manager CSV uploads fill Claude context windows. | High. Reads targeted ranges via API tools. | High. Aggregated Otto MCP tool calls use far fewer tokens than raw CSV uploads. |
| Read/write scope | Read-only upload of point-in-time data. | Read and write (update_spreadsheet, update_values, update_formulas, insert_dimension). | Strictly read-only for Google Sheets, GA4, Search Console, Google Ads, and Shopify. |
| Cross-channel data | Manual joining across detached spreadsheets and CSV exports. | Google Sheets only. Cannot query GA4, Shopify, or ads. | Joins Sheets, Shopify, GA4, Search Console, ads, and website data in one chat. |
| Execution safety | Manual changes in each platform. | Mutation tools carry indirect prompt-injection risk on formulas. | Website edits wait on WordPress drafts or GitHub PRs; ad writes require approval. |
Uploading a raw 3,000-row CSV into Claude can consume 40,000 to 80,000 tokens in a single turn; Otto MCP cuts token usage by 80–90% by querying only the ranges and metrics you ask for.
Connect Claude to Otto MCP to query Google Sheets ranges alongside live analytics.
DIY and local Google Sheets MCP servers
A fourth option is a local or self-hosted MCP connector. Unlike remote MCP servers, local servers require installation and configuration on each device you use, and credential handling stays on that machine. Otto's hosted gateway at https://otto.islaintel.com/api/mcp is a remote HTTP MCP server: Google OAuth stays on Otto's server, Claude holds only one otto_mcp__ token, and you can reconcile spreadsheet KPI ranges alongside 227 tools across 15 integrations while Google Sheets stays read-only in Otto MCP.
Otto MCP
Ask your AI assistant what changed in your ads
Connect Claude or ChatGPT to Otto, then ask about Meta Ads, Google Ads, GA4, and Search Console in the same chat. The logins stay in Otto.
How Google Sheets API v4 ranges, OAuth scopes, and rate limits work under the hood
spreadsheets.values.get reads a range by spreadsheetId and A1 notation (for example Summary!B2:F20). Use majorDimension=ROWS or majorDimension=COLUMNS to orient results, and valueRenderOption to return formatted display values, raw numbers, or formula strings (default FORMATTED_VALUE). OAuth scopes apply to the whole spreadsheet file, not a single tab; spreadsheets and spreadsheets.readonly are Sensitive. Google's usage limits recommend a 2 MB payload ceiling and 300 read or write requests per minute per project (60 per minute per user); pull targeted ranges instead of whole tabs to avoid HTTP 429 errors.
How to connect Claude to Google Sheets in five steps with Otto MCP
- Authorize inside Otto: Complete Google OAuth at /introduction/connect/sheets and connect GA4, Search Console, Shopify, and ads on the same screen.
- Copy endpoint and token: Use
https://otto.islaintel.com/api/mcpand yourotto_mcp__bearer token from profile settings. - Add Otto to Claude or Cursor: Follow /introduction/mcp/claude or /introduction/mcp/cursor and paste the HTTP MCP URL plus token.
- Pull A1 ranges in chat: Ask for named tabs and cell ranges instead of CSV exports (80–90% fewer tokens than 3,000-row uploads).
- Reconcile and stage changes: Compare sheet targets to live channel data; draft WordPress posts or ad updates behind approval gates.
When to use Google's native Developer Preview Sheets MCP server (and what to watch out for)
Google's remote server at https://sheetsmcp.googleapis.com/mcp/v1 is documented in Configure the Sheets MCP server. You join the Google Workspace Developer Preview Program, enable sheets.googleapis.com and sheetsmcp.googleapis.com, and register an OAuth 2.0 Web client with https://claude.ai/api/mcp/auth_callback and access_type=offline so Claude is not prompted every hour. Six tools cover reads (get_values, get_spreadsheet) and writes (update_spreadsheet, update_values, update_formulas, insert_dimension), each counting toward the 300-per-minute project quota. Google warns that write tools raise indirect prompt-injection risk on formula-heavy KPI sheets; Otto MCP keeps Google Sheets read-only so chat cannot mutate your models.
Four cross-channel KPI workflows combining Google Sheets, Shopify, GA4, and paid ads
Enrique Vásquez, COO at IslaIntel, writes operations guides on Shopify orders, inventory, and Google Sheets live KPI reporting; the four workflows below are patterns COOs can run in Claude once Sheets and Otto MCP are connected.
1. Reconciling Shopify orders, GA4 landing pages, and Google Sheets KPIs
With /introduction/connect/shopify and /introduction/connect/google-analytics connected, ask Claude to read Ecommerce_Targets!B2:D14, pull Shopify gross sales and refunds, compare GA4 landing-page sessions, and summarize variance—without the 40,000 to 80,000-token cost of full CSV exports. See GA4 paid landing page analysis for related patterns.
2. Weekly paid media pacing and MER audit
/product/ai-paid-ads reads pacing rows and live Meta Ads, LinkedIn Ads, X Ads, ChatGPT Ads, and Google Ads spend in one turn.
Say your team keeps monthly spend caps in a pacing tab and asks Claude to compare live Meta Ads, Google Ads, and LinkedIn Ads spend mid-month.
New LinkedIn Ads campaigns start as DRAFT; activating or pausing needs confirm=true and Reviewer or Admin access. $0 budgets are rejected. For Meta setup, see how to connect Claude to Meta Ads.
3. Turning spreadsheet content trackers into draft-first website updates
/product/ai-website-manager lets Claude read keyword rows from your sheet, pull Search Console clicks and impressions, and run psi_analyze_url on target URLs. Otto v1.1.5 compresses uploaded images automatically during maintenance passes. New WordPress posts and pages stay in draft across 29 tools; GitHub edits open as pull requests with Vercel preview URLs. Enrique Gomez, owner of Enzo Maverick Pilates and Experiences Sensory, shared: "Otto has been pivotal for us. The ease of making website changes on the fly lets us sharpen our brand and revise as fluidly as we need."
4. The plain-English weekly briefing for owners who hate spreadsheets
/product/website-analytics joins Google Sheets targets with GA4, Search Console, Google Business Profile, YouTube, and connected ad accounts in one narrative, as outlined in why automated weekly digests replace manual Monday reports. Otto v1.2.0 added automated weekly SEO reports, and v1.1.0 WhatsApp lets owners approve or reject proposed site changes from their phone.
Read-only spreadsheet safety vs. approval-gated execution: plans, honest limitations, and FAQs
Opteo, Madgicx, Synter, and Ryze AI each cover a slice of ads or SEO without tying spreadsheet KPIs to live website deploys the way Otto does. See Ryze AI alternatives for a longer comparison. Otto manages websites, SEO, and paid media together and requires human review before changes go live or spend money.
Plans and pricing
Otto MCP uses the same transparent tiers as the core platform. Review all options on our pricing page:
- $1 3-Day Trial: Full access to Pro features, including website updates, SEO maintenance, and read-only access to ads and socials, plus an owner-approved homepage redesign.
- Pro ($199/mo or $99/mo billed annually): Complete website management, SEO tools, and read-only monitoring across ad channels and social accounts. Users can cancel anytime.
- Master ($3,500/mo or $3,000/mo billed annually): Full Pro capabilities plus approval-gated write operations across paid ads and organic social publishing.
Honest limitations
- Google Sheets, GA4, Search Console, Google Ads, Google Business Profile, YouTube, Shopify, and PageSpeed Insights are strictly read-only within Otto MCP.
- Write access for ad campaigns and social media publishing requires the Master plan.
- While WordPress posts default to drafts, publishing to Facebook Pages and Instagram through Otto MCP goes live immediately and requires the Master plan plus Reviewer or Admin credentials.
- Checkout, contact, and legal pages always require human approval in Otto core, even when other pages use drafts or pull-request previews.
- Platforms such as Wix, Webflow, and TikTok are not supported in the live MCP catalog.
- The Otto CLI for terminal agents is coming soon; remote MCP is the live path today.
Frequently asked questions
Can Claude modify my Google Sheets via Otto? No—Sheets is read-only in Otto MCP.
Do I need Google Cloud? No—authorize once via OAuth inside Otto.
Can Claude change ad budgets from the KPI sheet? On Master, Claude can stage LinkedIn Ads or Meta Ads edits, but approval and Reviewer or Admin permissions apply before anything goes live.
Connect Claude to Otto MCP to run live cross-channel KPI reporting across your spreadsheets, analytics, and advertising accounts.
Otto Website Analytics
Monday should say what actually changed.
Otto checks that the numbers are still counting, then sends the week in plain language. Visitors, the pages that moved, and the fix worth doing next.
See how Otto does it