The Three Google Sheets AI Layers
Layer 1: Gemini in Sheets. Google's native AI, available as of Q1 2026 through Workspace Business Standard and above ($14–$22/user/month depending on tier). You open the side panel, describe what you want, and Gemini either suggests a formula or drafts a new tab. It works inside the active sheet — it reads your column headers, sees your visible data range, and generates formulas from there.
Layer 2: AI formula assistants. These sit in the formula bar itself. You type = and start describing the logic in plain English. Tools like Gemini's formula suggestions (rolled out in Workspace in late 2025) or third-party extensions translate natural language into formulas. The output is a static formula — no ongoing connection, no memory.
Layer 3: Sidebar agents. Add-ons with persistent AI sessions that can read from and write to your sheet, hold context across turns, and execute multi-step workflows. These vary wildly in what they can actually access.
What Google Sheets AI Actually Sees in Your Model
This is where most write-ups gloss over the critical detail.
Gemini's built-in AI reads your active sheet only — the tab you're currently on. If you're on the Returns Analysis tab and you ask it to summarize revenue trends, it can't see 'P&L'!C:C. It doesn't know your model has 8 tabs. It sees what you see in front of it, nothing more.
That's a real problem when your revenue driver is:
=SUMIFS('P&L'!C:C, 'P&L'!B:B, ">=" & Assumptions!$B$3, 'P&L'!A:A, Returns!$A$7)
Gemini can generate that formula if you describe it precisely. It cannot independently discover that Assumptions!$B$3 holds your start date, or that Returns!$A$7 is a segment filter. You have to tell it. That's a meaningful limitation when you're three hours into a bank syndicate DCF and want the AI to spot why your FCFF tab isn't tying to the BS.
According to Google's Workspace documentation, Gemini in Sheets "analyzes data in your spreadsheet to generate helpful suggestions" — the key word is your spreadsheet, singular. Cross-tab reasoning requires you to either consolidate data first or use a layer-3 agent that has been explicitly granted access to the full file.
AI formula assistants have an even narrower window. They see adjacent cells for context — maybe 50–100 rows — which is enough to suggest =IFERROR(VLOOKUP(...)) but not enough to navigate a 500-row P&L feeding into a waterfall chart on a separate tab.
Where Each Layer Breaks Down on Real Models
| Layer | Good at | Breaks on |
|---|---|---|
| Gemini (built-in) | Drafting single-tab formulas, explaining error messages, building simple pivot tables | Cross-tab references, linked 3-statement models, any formula that depends on another tab's range |
| Formula assistants | Autocompleting SUMIFS / COUNTIFS logic you've half-written | Long formula chains, structured references, anything with indirect tab references |
| Sidebar agents | Multi-turn conversations, reading full sheets, writing data back | Model-specific logic it hasn't been told about, proprietary assumptions it can't infer |
The 30%/70% split roughly holds: AI handles about 30% of formula work cleanly (simple lookups, basic aggregations, error wrapping), while the other 70% — the cross-tab dependencies, the sensitivity tables, the runway models where every row feeds the next — still requires a human who knows the model structure.
For quarterly board pack prep, Gemini's formula generation is genuinely useful for the mechanics: =ARRAYFORMULA(IF(LEN(A2:A), B2:B/C2:C-1, "")) to compute period-over-period growth across a column, without having to type it 40 times. That's real time savings. But when your VP asks why the contribution margin by SKU diverged from the EBITDA build, you're not asking Gemini — you're tracing references yourself.
What Google Sheets AI Gets Right: The $5K Threshold
There's a useful mental model here: if fixing a problem in your model is worth less than about $5K of analyst time (roughly 20 minutes of manual cell-chasing), AI formula assistants break even or win. If it requires understanding how 8 tabs connect, or why your terminal value is shifting when you change only the WACC input in Assumptions!B12, the built-in AI layers aren't there yet.
What changes with full-spreadsheet access is the ceiling. A sidebar agent that can read every tab — 'P&L', 'Balance Sheet', 'FCFF', 'Assumptions', 'Returns Analysis' — can actually answer "why doesn't the cash flow tie?" rather than just generating another formula that misses the same structural issue. ModelMonkey takes this approach: the agent is scoped to your current file and can read across tabs in context, so when you describe the model structure once, it retains that context for the whole session rather than resetting on each formula request.
Google Sheets AI: The Honest Takeaway for FP&A
As of April 2026, Google Sheets artificial intelligence is genuinely useful for maybe 30% of what an FP&A analyst does in Sheets day-to-day. Single-tab formula generation, error explanation, basic data transformation — these work. Cross-tab reasoning, multi-sheet model navigation, and anything that requires understanding how your Assumptions tab drives 6 downstream sheets — these don't, at least not without significant scaffolding from you.
The productivity wins are real but narrow. If you're building a new model from scratch, Gemini can draft the skeleton of your SUMIFS logic faster than you can. If you're debugging a model someone else built — the classic "why is the WACC cell circular" situation — you're still doing that yourself.
The 10-million-cell limit that Google Sheets imposes is a useful reminder that Sheets is a mid-market tool. The AI built into it reflects that positioning: solid for standard FP&A work, not built for massive portfolio models or real-time data pipelines.
What's actually improving is the agent tier — layer 3 — where full-file access and session memory close the gap meaningfully. That's the part worth watching.