Three hours for a spreadsheet. Create columns, type formulas, fix the formatting, break something, start over. Sound familiar?
Some people even apologize for not knowing Excel. As if that were a character flaw.
Google says that's yesterday's problem. Gemini — Google's AI model (a language model that understands text and responds to it) — can now handle this for you. You describe what you need. Sheets builds it.
How Does It Work?
Open Google Sheets, click the Gemini icon, and type in plain language:
"Create a monthly budget spreadsheet with categories, planned budget, actual spending, and automatic difference calculation."
Gemini reads it, builds the table, adds the formulas. No VLOOKUP gymnastics. No "how does conditional formatting work again?" Just describe it, done.
Works for more complex tasks too: project plans with deadlines and status columns, campaign trackers with budget vs. actual costs, travel planners with automatic totals, inventory management. And if you want to extend an existing spreadsheet — "add a column for tax rate" — that works just as well.
New addition: Gemini in Sheets can also create interactive mini-apps — dashboards, heat maps, kanban boards — right inside the spreadsheet. Sounds like developer territory, but it's accessible through a plain-text description.
What's Free?
Honest answer: right now, nothing for regular users.
The AI features in Sheets run on Google Workspace — Google's business package. You need at least "Business Standard" (currently around $14 per user per month). Nothing cheaper works yet. If you have a regular Gmail account: no access.
Technically interesting: Google has benchmarked Gemini in Sheets at around 70% success on complex spreadsheet tasks — not perfect, but significantly better than hunting through forum threads for the right formula.
Enhanced usage limits apply on promotional terms until mid-July 2026 — what comes after remains to be seen.
What Can I Try Right Now?
If you have Google Workspace Business Standard or higher: start now. Open the Gemini icon in Sheets (top right), describe your table, click generate.
Good first test: a simple expense tracker with three categories. You'll immediately see how Gemini structures data and which formulas it picks.
If you don't have access, there are two things to wait for. First: Google opening this to more users — that'll come sooner or later. Microsoft 365 has similar Copilot features for Excel, with similar access restrictions. No cheap shortcut in sight.
Second — and the more interesting bet: open source catching up. In our experience, that doesn't take long. The moment an AI feature lands, the community builds an open version of it. The catch: it probably won't come as a comfy subscription, but only via the API with your own key — that's BYOK ("Bring Your Own Key," meaning you supply your own access to an AI provider). Less one-click convenience than Google. But far more flexible — and you keep control over your data.
Is This for Me — or Developers Only?
Explicitly not built for developers. This is for anyone who regularly works with spreadsheets: accountants, project managers, assistants, small business owners. Anyone who currently Googles formulas and manually builds columns will save real time here.
Developers can access Gemini in Sheets through an API — but the main audience is clear: regular office workers who'd rather not deal with formula syntax.
The Verdict
AI that genuinely handles spreadsheet work has arrived. Not as a demo, not "coming soon" — it works, today. The only downside: you have to pay for it right now.
If you're already on the right Workspace plan, try it immediately. If not — maybe it's time to ask your boss. Or wait for the day Google opens this to everyone. Or for open source to deliver its own answer — a bit more rough-and-ready, but in your hands.
Both are coming.