GGemini in Google Sheets

Gemini in Google Sheets is Google’s spreadsheet agent, built into the Sheets side panel. Since April 2026 it can build a complete spreadsheet from one prompt: it gathers information, proposes a plan for approval, then creates the tables, formulas, pivot tables and charts. Google reports a 70.48% success rate on the full SpreadsheetBench dataset. It comes with Google Workspace Business Standard, listed at $14 per user per month, and higher plans.

It suits teams already on Google Workspace who want spreadsheets built from their Drive files and email. The newest features are US and English only, and Business Starter does not include it. We rate it 8.8/10 on our scale, with high marks for setup and autonomy.

Gemini in Google Sheets by the Numbers

Google announces Sheets features on its Workspace Updates blog, and its pricing page shows which plans include them.

The benchmark figure deserves context. SpreadsheetBench tests autonomous manipulation of real-world spreadsheets, and 70.48% means Gemini completed roughly 7 in 10 of those tasks. That is high for an agent, and it still leaves about 3 in 10 that need a person to fix or finish. Plan reviews accordingly. In practice, that means treating Gemini’s first build as a draft: check the formulas in key totals, confirm that pivot tables cover the full data range, and test any dropdown or scenario switch before the sheet goes to someone who will act on it.

The plan rows set the real entry price. Many small businesses run on Business Starter, and moving to Standard at the listed $14 from $7 doubles the per-user cost. That jump buys Gemini in Docs, Gmail and other apps too, so weigh it across the suite.

Inside a Gemini Spreadsheet Build

Gemini works from a side panel next to the grid. The steps below follow Google’s Workspace Updates posts.

Turning It On

Workspace smart features must be enabled, and the feature is on by default wherever Gemini for Workspace in Sheets is turned on. Enabling Workspace Intelligence widens what Gemini can draw on, since it lets the agent read relevant files, emails and chats. Admins manage both settings.

Building From One Prompt

A user opens the Gemini icon and describes the result, such as Google’s own example: build a P&L dashboard using historic service incidents and rate cards. Gemini gathers the inputs it needs, proposes a plan, and waits for approval. After approval, it builds the spreadsheet end to end, retrieving data and formatting it, with pivot tables, complex formulas, stylized tables and charts.

Editing an Existing Sheet

For sheets that already exist, Gemini refines models, budgets or analyses side by side. The October 2025 update lets a single request carry several actions. Chrome Unboxed described examples such as adding Status and Priority dropdowns, a Days Until Due Date formula column, a Completed checkbox column and a frozen header to a project tracker, or deleting rows for inactive reps and highlighting top performers above 120% of quota in a sales report.

Optimization Problems

Google says Gemini in Sheets can take on optimization problems, such as scheduling or allocation, using research from Google DeepMind and Google Research’s OR-Tools. This sets it apart from agents that only write formulas, though Google gives few details on the size of problems it handles.

A Small Business Budget Example

A bakery owner on Business Standard asks Gemini to build next quarter’s budget using last quarter’s supplier invoices in Drive and the payroll summary in her email. Gemini proposes a plan: an income tab, a cost tab by supplier, a payroll tab and a summary with monthly totals and a chart. She approves, and Gemini builds it. She then asks it to add a dropdown for scenario, best case or worst case, and a 10% flour price rise in the worst case. She checks the supplier totals against two invoices before sharing the file with her accountant.

Rolling It Out Across a Workspace Domain

Admins on Rapid Release saw the April 2026 features from April 22, and Scheduled Release domains from May 6, with up to 15 days for the feature to appear. For a controlled rollout, an admin can confirm that smart features and Gemini in Sheets are on for a pilot group, decide whether Workspace Intelligence should be enabled, and brief users on the plan-approval step. Because the feature is on by default where Gemini in Sheets is enabled, many users will find it without any announcement, so a short guide on reviewing plans and checking sources is worth sending early.

What the Owner Still Checks

People still confirm that Gemini found the right files and emails, check totals against source documents and decide what to share. The plan step is the moment to catch a wrong assumption before anything is built.

Google Workspace and Google AI Plans With Gemini in Sheets

Gemini in Sheets is not sold alone. It comes with these plans, according to Google’s announcement and pricing page.

Google’s pricing page has shown introductory discounts on these plans, so check the final price at checkout. The page labels an annual commitment option as a 16% saving.

Per-User Costs for Three Teams at List Price

• A 5-person agency on Business Standard: 5 users at $14 is $70 a month, or $840 a year.
• A 20-person company on Business Plus: 20 users at $22 is $440 a month, or $5,280 a year.
• A 10-person team moving up from Starter: the change from $7 to $14 adds $70 a month, or $840 a year, and brings Gemini in Sheets, Docs and Gmail.

Heavy users are the variable. After the July 15, 2026 promotional window, per-user limits apply, and only the AI Expanded Access or AI Ultra Access add-ons keep higher limits. Teams that build large models daily should watch for limit notices in the first months and price the add-on if needed.

Gemini in Google Sheets Compared With ChatGPT for Excel, Coefficient and Agent Mode in Excel

Spreadsheet agents now cover both Google Sheets and Excel.

Gemini’s advantage is context: it reads the files and emails a Workspace user already has. Coefficient adds live business data that Gemini does not connect to directly. Gemini Enterprise covers Google’s broader agent platform for companies. See more on our spreadsheet agents page.

Workspace Users Who Benefit Most From Gemini in Sheets

• Small businesses on Business Standard or Plus: the agent is already included.
• Operations and project teams: trackers with dropdowns, checkboxes and formula columns are built in one request.
• Managers who pull numbers from email and Drive: Workspace Intelligence finds the inputs.
• Planners with scheduling or allocation problems: the optimization feature targets these jobs.
• Schools on Google AI Pro for Education: the feature is listed for that plan, which suits staff building rosters and budgets.

Users Better Served by Another Spreadsheet Agent

• Teams on Business Starter: they would need to upgrade to get Gemini in Sheets.
• Users outside the US or working in other languages: the build-from-prompt features are US and English only for now.
• Excel-based finance teams: Claude for Excel or Agent Mode in Excel fit better.
• Teams needing scheduled CRM or database pulls: Coefficient adds connectors and refresh.

Usage Limits and Data Access in Gemini in Sheets

Language and region matter for global companies. A team split between the US and Europe will see different features, since the build-from-prompt release is US and English only. The October 2025 editing actions were described as available to eligible users, including most paid Workspace subscribers, so check which features each office sees before writing training material.

Usage limits changed after July 15, 2026. Google said per-user limits would apply and that it would publish details in the Help Center before they took effect. Heavy users should check those details and watch for notices in Sheets.

Workspace Intelligence is useful and needs thought. When it is on, Gemini can draw on files, emails and chats to build a sheet. Admins should decide whether to enable it for all users, and users should check which sources Gemini used before sharing a sheet built from private email.

The 70.48% SpreadsheetBench figure is strong for an agent, and it also means some tasks will be wrong or incomplete. Review formulas and totals, especially in sheets that feed payroll, pricing or tax.

Gemini in Sheets Updates From Google

On October 16, 2025, Google expanded Gemini’s editing capabilities in Sheets with multi-step requests and actions such as conditional formatting, dropdowns, checkboxes, pivot tables, sorting and filters. Chrome Unboxed reported on October 20, 2025 that the update let Sheets users run several changes from one command.

On April 22, 2026, Google announced end-to-end spreadsheet creation in Gemini in Sheets, with plan approval, Workspace Intelligence, optimization and a 70.48% SpreadsheetBench result, rolling out in the US in English.

How Gemini in Google Sheets Scores for Spreadsheet Work

Gemini in Google Sheets scores 8.8/10 on our scale. Setup is its highest score because licensed users find it already in the side panel. Autonomy and integrations score well thanks to plan-then-build and Workspace context. Pricing value is fair: it is bundled, though Starter users must upgrade. User sentiment stays neutral until allowed review sites rate it.

For Workspace teams on Standard or Plus, try it on one recurring tracker or budget this week, using the plan step to check assumptions before Gemini builds.

A fair test uses a job you already know the answer to. Rebuild last month’s report with Gemini from the same source files, compare the totals cell by cell, and note where the plan needed changes. If most of the work matches on the first or second try, roll it out to the rest of the team with a short checklist: approve the plan, check sources, review totals.

Workspace Admins’ and Users’ Questions About Gemini in Sheets

Which Google Workspace Plan Includes Gemini in Sheets?

Business Standard and Plus, Enterprise Standard and Plus, the AI Expanded Access and AI Ultra Access add-ons, Google AI Pro for Education, and consumer Google AI Pro and Ultra. Business Starter does not include it.

Can Gemini Build a Whole Spreadsheet From One Prompt?

Yes, in the US and in English. Gemini gathers information, proposes a plan for approval and then builds the spreadsheet with formulas, pivot tables and charts.

Does Gemini in Sheets Read My Gmail and Drive?

With Workspace Intelligence enabled, it can pull context from your files, emails, chats and the web to build the sheet. Admins control whether that is turned on.

How Accurate Is Gemini in Sheets?

Google reports a 70.48% success rate on the full SpreadsheetBench dataset. That is a benchmark result, so review formulas and totals on your own files.

Are There Usage Limits for Gemini in Sheets?

Yes. Promotional higher limits ran through July 15, 2026. After that, per-user limits apply, with higher limits for AI Expanded Access and AI Ultra Access add-ons.