Google Sheets AI (Gemini in Sheets) — Full Profile ( 2026-09)

Google LLC, Mountain View CA; Workspace surface powered by Gemini (DeepMind); NASDAQ: GOOGL public-traded; Sheets MCP server first-party https://sheetsmcp.googleapis.com/mcp/v1 Developer Preview Jul 2026; not a standalone SaaS (bundled in Workspace), not per-seat-AI (per-user Workspace seat + feature-use caps), not acquired, not bootstrap, not PE. Aligns Klaviyo/Cloudflare FB-Ads-API as public-traded platform-primitive-with-AI-surface.

Website

Field	Value
Official Website	https://workspace.google.com/products/sheets/ · Gemini in Sheets Help: https://support.google.com/docs/answer/14356419 · AI function =AI()/=Gemini() docs · MCP: https://sheetsmcp.googleapis.com/mcp/v1 (Dev Preview Jul 2026) · Sheets API v4: https://developers.google.com/workspace/sheets
Company	Google LLC (Alphabet NASDAQ:GOOGL/GOOG), Mountain View; Sheets launched 2006, Gemini in Sheets GA US-English Apr 2026 (expanded 28 langs Jun 2026); public-traded platform-primitive + AI surface, not standalone SaaS, not acquired, not PE, not bootstrap, not open-source (Apps Script open-ish but core closed)
Status	Active, Gemini in Sheets GA (US-en Apr 2026, 28 langs Jun 2026), MCP Dev Preview Jul 2026
Category	ai-productivity-data
Pipeline Stage	none

Title

Field	Value
Product	Google Sheets AI → “Gemini in Google Sheets” (AI surface of Google Sheets)
Descriptive Title	Google Sheets + Gemini — Collaborative Cloud Spreadsheet with Embedded Generative AI: =AI()/=Gemini() cell function (generate/summarize/categorize/sentiment/Search-live), “Build whole spreadsheet from prompt” (end-to-end creation + side-by-side edit, SpreadsheetBench 70.48% autonomous success), Convert-to-Table paste, Fill-with-Gemini, Workspace Intelligence cross-Drive/Gmail/Chat context, Smart Fill pattern recognition; bundled in Workspace (Business Starter $7 no AI → Standard$ 14 100 builds/mo + 5,000 AI-fn calls → Enterprise 500/mo); First-Party Sheets MCP server Dev Preview (sheetsmcp.googleapis.com/mcp/v1, 6 tools, OAuth 2.0, Claude/Cursor/Codex, preview-gated not GA); REST v4 + Apps Script + Vertex AI custom functions (2006 Mountain View, GOOGL)
One-line Positioning	User opens a Sheet → types `=AI("summarize sentiment", B2)` or clicks Gemini side-panel “build a P&L from my rate cards + incidents” → Gemini orchestrates tables/pivots/formulas/charts, fills columns from web, pulls Drive/Gmail context → output lands in cells with version-history attribution; admins meter by feature-use caps (100 builds/mo Standard, 500 Enterprise) not by seat-AI; engineers use Sheets API v4 or first-party MCP Dev Preview to let Claude read/write ranges; free consumer sheet = $0 + Gemini AI Pro/Ultra add-on for AI features, business sheet = Workspace seat price + AI included on Standard+.

Features

Field	Value
AI Cell Functions	`=AI(prompt, range)` and `=Gemini(poly)` — generate text, summarize, categorize, sentiment, translate, live Google Search lookup; “AI column” autofill; refresh-on-edit; 5,000 calls/mo cap on Standard (feature-metered not row-metered)
Prompt-to-Sheet	“Build and edit entire spreadsheets with Gemini” GA Apr 2026 — end-to-end creation (multi-sheet workbook from one prompt), side-by-side editing in side panel, Workspace Intelligence pulls Drive/Gmail/Chat context; SpreadsheetBench autonomous manipulation 70.48% (near human-expert per Google DeepMind)
Data Ops AI	Paste-unformatted-text → “Convert to table” (Apr 2026), Fill-with-Gemini (drag/context fill columns), Smart Fill pattern recognition (pre-Gemini but Gemini-enhanced), dedupe/clean/normalize via prompt, classify rows, extract entities
Visualization	Gemini proposes pivot tables, conditional formatting, bar/line/scatter from natural language; charts inserted inline; dashboard scaffolding (“add scorecards above sales data”)
Workflow / Agents	Apps Script + Gemini/Vertex AI custom functions (=FACT_CHECK() etc.), AppSheet Enterprise Plus Gemini extract bots, Workspace Intelligence cross-app; no autonomous agent loop inside Sheets (Gemini proposes, human approves plan)
MCP Server (Dev Preview Jul 2026)	First-party `https://sheetsmcp.googleapis.com/mcp/v1` — OAuth 2.0, 6 tools (get_values, get_spreadsheet, update_spreadsheet [passthrough to batchUpdate 69 req types], update_values, update_formulas, insert_dimension), Drive MCP sibling for name-resolution; Developer Preview Program gated (no service-account enrollment, no public-app-before-GA per terms) — joins Klaviyo/Feedly first-party MCP cluster but preview-state (distinct from Rezi/Miro/Supabase GA)
API	Sheets API v4 REST (spreadsheets.* + spreadsheets.values.*, OAuth 2.0 user/service-account, 300 reads+300 writes/min/project, 60/user), Apps Script (bound/unbound, UrlFetchApp→Vertex AI), Drive API for file resolve
Integrations	Drive/Gmail/Docs/Slides/Chat/Calendar native, Forms→Sheet, BigQuery connected sheets, Looker Studio, Zapier/Make, 1,000+ Workspace Marketplace add-ons; MCP bridges to Claude/Cursor/Codex (preview)
Security	Workspace enterprise controls (VPC-SC, DLP, Vault, regional), Gemini not trained on Workspace content without permission, Admin Smart-Features toggle disables AI, HIPAA/SOC 2 via Workspace Enterprise

Pricing (2026-09, Workspace seat + feature-use caps, AI not separately billed per call)

Field	Value
Consumer (free sheet)	$0 Google account — no Gemini in Sheets unless Google AI Pro (~$ 19.99/mo) or AI Ultra (~$125/qtr) add-on attached; then =AI() + side-panel build enabled, consumer caps softer than Workspace
Business Starter	$7/user/mo — NO Gemini in Sheets/Slides (Gemini in Gmail side-panel only); AI features absent, frequently misread as “Workspace includes AI”
Business Standard	$14/user/mo — Gemini in Sheets 100 builds/edits per user/mo + 5,000 AI-function calls/mo + 30 canvases; side-panel, =AI(), Fill-with-Gemini, Convert-to-Table; AI Ultra Access add-on raises caps
Business Plus	$22/user/mo — same Sheets AI caps as Standard (100/5,000); pays for security/compliance/meetings not more AI; common misbuy
Enterprise Standard / Plus	Custom quote (~$18-30/user/mo list) — 500 builds/mo + higher AI-fn cap, VPC-SC, no-training opt-out, AI Expanded/Ultra Access add-ons for power users
AI Ultra Access Add-on	~$125/qtr per user — Gemini 3 Pro, higher Sheets limits, Veo in Slides, post-Jul-15-2026 promotional limits expire → per-user usage caps enforced
Type	workspace-seat-metered + feature-use-cap (not per-call, not per-seat-AI, not per-row); starting_paid_with_AI= $14/user/mo (Standard); free consumer needs$ 19.99 AI Pro
Note	“100 builds/mo” counts prompt-to-workbook + side-panel edits as 1 each; =AI() cell calls separate 5,000 pool; Business Plus does NOT raise AI caps (only Enterprise does) — finance trap

Reviews

Field	Value
G2	4.3/5 (~13+ reviews on “Google Sheets” spreadsheet category, G2 aggregates Sheets inside Spreadsheet Software grid not separate “Sheets AI” profile) — primary B2B star by proxy; praise real-time collab 95% rated, autosave 96%, Gemini =AI() faster first-draft, IMPORTRANGE/Apps Script power; gripes large-file slowdown, Gemini output needs human review (“almost right”), Business Starter has no AI (confusion), 100/mo cap hits power users, MCP preview not GA
Capterra	4.7/5 (~13,165-13,216 verified on Google Sheets brand, Feb-Aug 2026) — auxiliary, G2-acquired Feb 2026 corpus separate; ease 4.7 value 4.6 support 4.2; IDP-style barbell absent (B2B-only)
Trustpilot	No Google Sheets standalone page — Google/Meta-style brand TP (1.8-2.2/5) is Android/Play/account-ban rage, excluded from B2B avg (aligns FFmpeg/MonkeyLearn-standalone/Qualtrics/Feedly pattern)
Product Hunt	4.9/5 ~29 launch-era not reweighted
Editorial	G2 Learn “best spreadsheet 2026” collaborative rating 95%, ToolRadar 4.4, Lumetric Mar 2026 “Business Standard is minimum viable AI plan”, Zelobiz Sep 2026 cap-table confirm
Praise	Best real-time multiplayer spreadsheet, Gemini =AI() kills first-draft friction, prompt-to-workbook 70.48% SpreadsheetBench near-expert, Convert-to-Table + Fill-with-Gemini remove data-entry drudgery, Workspace Intelligence cross-Drive context is unique vs Excel+Copilot silo, MCP first-party (preview) future-proofs agent integrations, $14 Standard cheaper than Excel+Copilot per seat
Gripes	Business Starter ( $7) buyers think they get Gemini in Sheets — they don't, 100 builds/mo evaporates for daily power users, Gemini "almost right" needs review (not trustable blind), large datasets (>100K rows heavy formulas) choke vs Excel, MCP Dev Preview gated (no service account, no public app), consumer AI needs$ 19.99 Pro add-on many don’t know about, Workspace admin can disable Smart Features killing AI org-wide

Review Sources Breakdown

Field	Value
G2.com	4.3/5 ~13 in Spreadsheet Software grid (Sheets not separate AI profile) — primary B2B proxy star
Capterra	4.7/5 ~13,200 — auxiliary, G2-owned Feb 2026 corpus separate
Trustpilot	none for Sheets → Google brand 1.8-2.2 excluded, not API/AI signal
Product Hunt	4.9/29 launch-era not reweighted
Editorial (G2 Learn/Lumetric/Zelobiz/ToolRadar)	cap-table + 95% collab + Standard-minimum confirm
Conclusion	Prints “G2 4.3 (spreadsheet-grid proxy, no separate Sheets-AI profile), Capterra 4.7/13.2K aux, Trustpilot none-excluded, MCP preview not in star math” — split-source rule holds; note no dedicated ‘Google Sheets AI’ G2 profile (unlike Klaviyo/Qualtrics/Motion which have product profiles)

Access

Field	Value
Web / Mobile	sheets.google.com, iOS/Android, offline edit (sync on reconnect); Gemini side-panel requires Workspace Smart Features on + eligible plan
API	Sheets API v4 REST (OAuth 2.0 user token / service account domain-delegation), quotas 300 reads+300 writes/min/project, 60/user; Apps Script Bound/Unbound; Vertex AI custom functions via UrlFetchApp
MCP	First-party Dev Preview `https://sheetsmcp.googleapis.com/mcp/v1` — OAuth 2.0, 6 tools, Claude Desktop/Cursor/Codex/Claude Agent SDK; Developer Preview Program terms (no service-account, no public app pre-GA, Domain-enrolled only); Drive MCP sibling for file-name resolve; aligns Klaviyo/Feedly first-party cluster but preview-gated (distinct from Rezi/Miro/Supabase/Framer/GitHub/Webflow/Netlify/Cloudflare/Lokalise/Smartlead/Slack/Klaviyo GA MCP, distinct from Nanonets/Composio 3rd-party, distinct from Motion/Todoist/Qualtrics none)
Integrations	Drive/Gmail/Docs/Slides/Chat/Calendar/Forms native, BigQuery connected sheets, Looker Studio, Zapier/Make, Marketplace add-ons; MCP host = Claude/Cursor/Codex
Login	Google account / Workspace SSO; Admin console Smart-Features toggle; DLP/Vault/Context-Aware on Enterprise
Self-host	None — Google cloud only, Workspace Enterprise regional options, no on-prem

Best For

Field	Value
Audience 1	Teams already on Workspace wanting collaborative reporting + light AI assist without new SaaS (Standard $14/seat covers it)
Audience 2	Ops/marketing/finance building trackers/campaign-calendars/AP-aging from prompts, 70-90% first-draft acceptable
Audience 3	Data analysts pulling =AI() categorization/sentiment over 1K-50K rows of survey/text data
Audience 4	Agent builders prototyping Claude→Sheets read/write via first-party MCP (accepting Dev Preview gating)
Audience 5	Educators/students on free sheet + AI Pro add-on for assignment data-cleaning

Not For

Field	Value
Exclude 1	Enterprise-scale financial modeling (100K+ rows, 10K volatile formulas) — Excel/Power Query/Python beats Sheets performance-wise
Exclude 2	Buyers on Business Starter ( $7) expecting Gemini in Sheets — it's absent, must jump to Standard$ 14
Exclude 3	Teams needing GA first-party MCP in production B2B app — Sheets MCP is Dev Preview Jul 2026, terms bar public-app pre-GA
Exclude 4	Regulated orgs refusing any Workspace data-residency ambiguity (though Enterprise VPC-SC + no-train opt-out exists)
Exclude 5	Users wanting trustable blind AI output — Gemini in Sheets “almost right” needs human review, not autonomous
Exclude 6	Offline-first field crews with flaky connectivity (Sheets offline OK but AI needs online)

Competitors

Field	Value
Microsoft Excel + Copilot	Closest rival, per-seat Copilot $30/user/mo add-on (vs Sheets AI bundled in$ 14 Standard), stronger heavy-modeling, weaker real-time collab, no first-party MCP GA (2026)
Apple Numbers + no AI	Consumer lightweight, no Gemini-equiv, no MCP
Smartsheet	Work-management grid, AI Assist add-on, not general spreadsheet
Airtable AI	Database-grid + AI, per-record credits, different shape (schema-bound not cell-free)
Notion AI Tables	Doc-db hybrid, AI summaries, weaker formula/pivot depth
Zoho Sheet + Zia	Cheaper Workspace-alt, Zia AI weaker than Gemini, no MCP