To analyze data with Gemini in Google Sheets, open your spreadsheet, click Ask Gemini (the star icon at the top right), and type a plain-English prompt such as “Identify trends in this table and list the top three insights.” Gemini reads your sheet, answers in the side panel, and can insert pivot tables, charts, and formulas directly into the grid. As of July 2026, the side panel requires a paid plan — Google Workspace Business Standard or higher, or a personal Google AI Pro subscription — and it is not available on free personal Google accounts.
Key Takeaways
- Click the Ask Gemini star icon at the top right of any sheet — available on Business Standard+, Google AI Pro/Ultra, and AI add-on plans, not free Gmail accounts.
- One prompt can summarize a sheet, find outliers, build a pivot table, or insert a chart — no formulas needed.
- Since the April 2026 update, Gemini can build and edit entire spreadsheets and scored 70.48% on the SpreadsheetBench benchmark.
- Promotional higher usage limits end July 15, 2026; per-user limits apply afterwards.
- For repetitive per-cell tasks (categorize, extract, translate), the =AI() function is usually faster than the side panel.
In this guide:
- Which Plans Include Gemini in Google Sheets?
- How Do You Open Gemini in Google Sheets?
- 7 Copy-Paste Prompts to Analyze Data with Gemini
- Can Gemini Analyze Data Across Multiple Tables?
- Gemini Side Panel vs the =AI() Function
- What Are the Usage Limits After July 2026?
- Frequently Asked Questions
Which Plans Include Gemini in Google Sheets?
As of July 2026, Gemini in Sheets is included in Google Workspace Business Standard and above, and in the consumer Google AI Pro and AI Ultra subscriptions. Free personal Google accounts do not get the side panel. Google’s April 2026 Workspace update lists the eligible plans explicitly.
| Account type | Gemini side panel? | Notes (as of July 2026) |
|---|---|---|
| Free personal Google account | No | Workaround: free Gemini API + Apps Script (see below) |
| Google AI Pro (consumer, $19.99/month) | Yes | AI Ultra also included |
| Workspace Business Starter | No | AI Expanded Access add-on is not offered on Starter |
| Workspace Business Standard ($14/user/month, annual) | Yes | Standard usage limits |
| Business Plus / Enterprise Standard / Enterprise Plus | Yes | Higher limits with AI Expanded or AI Ultra Access add-ons |
Prices and plan boundaries change often — check Google’s official plan pages before buying, and note that your Workspace admin must leave Gemini features and smart features enabled for the icon to appear.
How Do You Open Gemini in Google Sheets?
Open any spreadsheet at sheets.google.com, then click the star-shaped Ask Gemini icon at the top right of the toolbar. A side panel opens with suggested prompts based on your data; type your own prompt at the bottom. That is the whole setup — there is nothing to install.
Exact steps:
- Go to sheets.google.com and open the spreadsheet you want to analyze (or create one and paste your data in).
- Click Ask Gemini at the top right (star icon, next to your profile picture).
- Optional but recommended: select the range you care about first — Gemini focuses its analysis on your selection.
- Type a prompt in the side panel and press Enter.
- When Gemini proposes a pivot table, chart, or formatting change, click Insert to place it in the sheet — nothing changes until you approve it.
If you don’t see the icon, your account plan is not eligible, smart features are turned off in your settings, or your admin has disabled Gemini — see the FAQ below.
7 Copy-Paste Prompts to Analyze Data with Gemini
These seven prompts cover the analysis tasks Gemini in Sheets handles best: trends, outliers, pivot tables, charts, formulas, formatting, and summaries. Paste them as-is, then swap the column letters and metric names for your own. Each prompt lists what you should expect back.
1. Find trends
Identify trends in this table and list the top 3 insights, with the numbers that support each one.
Expected output: a bulleted list in the side panel, e.g. “Revenue grew 18% month-over-month from March to June, driven mostly by the EMEA region.” Ask “show your reasoning” if a claim looks off — always spot-check numbers against the sheet.
2. Spot outliers
Find outliers in column D and explain what makes each one unusual compared to the rest of the column.
Expected output: the specific cells (row numbers and values) plus a short explanation, such as “Row 47: $92,300 is 6x the column median.”
3. Build a pivot table
Create a pivot table that shows the sum of sales by region and month.
Expected output: a preview of the pivot table in the panel with an Insert button; clicking it adds the pivot to a new area of your sheet, already configured.
4. Insert a chart
Create a chart with month on the x-axis and total revenue on the y-axis.
Expected output: a chart preview (Gemini picks a sensible type, usually line or column) that inserts directly into the grid. You can follow up with “make it a bar chart” to change the type.
5. Write and explain a formula
Write a formula that calculates what percentage of rows in column F are marked "Overdue", and explain how it works.
Expected output: a working formula such as =COUNTIF(F2:F200,”Overdue”)/COUNTA(F2:F200) with a plain-English explanation and an Insert option. If you mostly need formula help, our guide on writing Google Sheets formulas with ChatGPT compares the AI options for that job.
6. Apply conditional formatting
Highlight every value in column C below 100 in red.
Expected output: Gemini creates the conditional-formatting rule for you — one of the “advanced actions” it can take directly in the sheet, alongside adding dropdowns and filters.
7. Summarize for someone else
Summarize this sheet in three sentences for a manager who has never seen it, then suggest two follow-up analyses.
Expected output: a short executive summary plus concrete next steps like “compare refund rates by product line.” Useful right before a status meeting.
Can Gemini Analyze Data Across Multiple Tables?
Yes. Since late 2025, Gemini in Sheets can reference several tables in the same spreadsheet at once — for example, building a single pivot table that combines a sales table and a returns table, or applying consistent formatting across every table in the file. In practice, results are more reliable when each table has a clear header row and a name.
The bigger change came in April 2026: Gemini can now build or restructure an entire spreadsheet from one prompt (“build a P&L dashboard from this transaction data”), planning the steps and asking for your approval before it edits anything. Google reports a 70.48% success rate on the SpreadsheetBench benchmark for autonomous spreadsheet manipulation — impressive, but far from perfect, which is why the approval step and your own spot-checks still matter.
Gemini Side Panel vs the =AI() Function: Which Should You Use?
Use the side panel for whole-sheet analysis and multi-step jobs; use the =AI() function for repetitive per-cell work; use the Gemini API with Apps Script when you are on a free account or need scheduled automation. They complement each other rather than compete.
- Choose the Ask Gemini side panel if you want insights, pivot tables, charts, or a whole spreadsheet built — anything where the “unit of work” is the sheet itself.
- Choose =AI() if the unit of work is a cell: categorizing 500 support tickets, extracting company names, translating a column. Write the prompt once and drag it down — our full guide to the =AI() function in Google Sheets has seven ready-made examples.
- Choose the Gemini API + Apps Script if you are on a free personal account (no side panel) or want analysis to run automatically on a schedule — see our walkthrough on using AI to write Apps Script for Sheets.
What Are the Usage Limits After July 2026?
Through July 15, 2026, Google gave Workspace customers promotional access to higher limits for the improved Gemini in Sheets experience. From now on, per-user usage limits apply: standard plans get standard limits, while the AI Expanded Access and AI Ultra Access add-ons carry higher ones. Google publishes the current numbers in its Workspace usage-limits Help Center page rather than fixing them in stone, so check there if you hit a cap.
Practical advice: the limits are counted per user, not per spreadsheet, and ordinary use — a handful of analysis prompts per day — is unlikely to hit them. If your team leans on Gemini heavily (daily dashboard builds, long multi-step sessions), that is the scenario the add-on licenses are priced for. When a prompt fails with a limit warning, batching questions into one prompt (“find trends, then build a pivot by region”) uses fewer requests than asking one at a time.
Frequently Asked Questions
Is Gemini in Google Sheets free?
No. As of July 2026 the Ask Gemini side panel is not available on free personal Google accounts — it requires Google AI Pro ($19.99/month), AI Ultra, or a Workspace plan from Business Standard up. The free workaround is calling the Gemini API from Apps Script with a free API key, which works on any account but without the built-in panel.
Can Gemini in Google Sheets create pivot tables and charts?
Yes. Prompts like “create a pivot table of sales by region” or “create a chart with date on the x-axis” produce a preview in the side panel, and one click inserts the result into your sheet. Gemini can also add dropdowns, filters, and conditional formatting the same way.
Why don’t I see the Ask Gemini button in Sheets?
Three common reasons: your plan is not eligible (Business Starter and free accounts do not include it), Workspace smart features are turned off in your personal settings, or your admin has disabled Gemini for Workspace. Check Settings > General > Smart features first, then ask your admin — Google’s official Help Center page lists the full eligibility rules.
Gemini in Sheets has crossed the line from novelty to a tool that saves real time on everyday analysis — as long as you treat its numbers the way you would treat a new analyst’s: useful, fast, and worth double-checking. Start with the seven prompts above on a copy of your data, and you will know within ten minutes which parts of your workflow it can take over.