Fill with Gemini in Sheets: automate data without formulas

What is Fill with Gemini, and why does it matter this week?

Fill with Gemini is the Google Sheets feature that populates cells with AI-generated data —text, summaries, categories, sentiment analysis— without writing a single formula. Google launched it in April 2026, and on July 7 expanded it to 11 additional languages (Mandarin, Dutch, Hebrew, Polish, Turkish, Czech, Indonesian, Swedish, Danish, Norwegian, and Malay), adding to Spanish, Portuguese, English, French, German, Italian, Japanese, and Korean.

Here’s the urgent part: usage limits change starting July 15, 2026. Until then, all Workspace users get promotional access to high Fill with Gemini limits. After that date, those higher limits are reserved for accounts with the paid AI Expanded Access add-on. If your B2B business relies on Sheets daily for prospecting, catalogs, or reporting, this week is the window to test the feature thoroughly before the limits drop.

How Fill with Gemini works (no complex formulas)

Google reports that Fill with Gemini populates data up to 9x faster than manual entry for 100-cell tasks. It’s triggered two ways: dragging the fill handle from an already-completed cell so the AI infers the pattern down the column, or selecting empty cells to open the prompt menu and ask directly for what you need.

• Generate text: draft product descriptions or summaries from other columns.
• Categorize data: classify leads, tickets, or expenses without pivot tables.
• Analyze sentiment: tag reviews or survey responses as positive, neutral, or negative.
• Extract information: pull data out of free text (a pasted email, for example) and organize it into columns.

Unlike a traditional formula, the output doesn’t auto-recalculate: it’s generated content that lands as a static value in the cell, built for one-time data prep rather than live reports that change in real time.

What changes on July 15 (and how to prepare)

This is the part most small businesses will miss: promotional access to high Fill with Gemini and AI-in-Sheets limits is temporary. Starting July 15, 2026, keeping those higher limits requires the AI Expanded Access add-on. If your team hasn’t evaluated this yet, this week is the time to:

1. Check the Workspace admin console to see if your organization already has AI Expanded Access or Gemini Business/Enterprise enabled.
2. Test Fill with Gemini on a real sheet (a catalog, lead list, or budget) before the cutoff to measure how much volume you actually process per day.
3. Decide with data —not assumptions— whether the paid add-on is worth it based on the usage you saw during the promotional window.

This «broad access first, paid limit later» pattern has already shown up with other Gemini features in Workspace, so it’s worth treating as the tool’s real cost rather than a surprise. If your business is already delegating tasks to AI agents elsewhere, it’s worth applying the same measure-before-you-scale logic covered in how to avoid the AI agent surprise bill.

How to activate and use Fill with Gemini step by step

1. Open a Google Sheet with your Workspace account (with Gemini enabled by your admin).
2. Manually fill the first cell of a column with the result you want (for example, a product category).
3. Hover over the corner of the cell: the Gemini icon appears to «fill column.»
4. Review the row-by-row preview before confirming —Gemini shows the proposed result before writing it.
5. For empty columns, select the range and use the prompt menu to describe what you need generated.

Use cases for B2B small businesses

Fill with Gemini pays off most on repetitive data-prep work someone currently does by hand or with fragile formulas:

• Sales prospecting: categorize a lead list exported from LinkedIn or a form by industry, company size, or buying intent.
• Support and CX: classify tickets or survey responses by sentiment and urgency before routing them.
• Catalogs and pricing: generate short product descriptions from spec sheets, ready to upload to an e-commerce store.
• Simple finance: categorize corporate card expenses by cost center before they hit a report.

Plenty of small businesses pay for Google Workspace and use less than half of what the plan includes; we already covered 7 Google Workspace features your business pays for and isn’t using, and Fill with Gemini is a strong candidate to join that list if you don’t turn it on now.

Fill with Gemini doesn’t replace your BI, it feeds it

Fill with Gemini prepares and cleans data inside a single sheet; it’s not a substitute for a business intelligence dashboard that pulls from multiple sources and updates itself. If your business already has enough data volume to need recurring reports, it’s worth reviewing what business intelligence (BI) is and how to implement it as the next step after cleaning up your data in Sheets.

What to do this week

• Confirm whether your organization has Gemini enabled in Sheets and which language your team needs.
• Test Fill with Gemini on a real sheet before July 15 to measure your actual usage volume.
• Evaluate with your Workspace admin whether the AI Expanded Access add-on is worth it based on that usage.
• Document the process so it doesn’t depend on a single team member.

The promotional window is short, but the habit of prepping data without fragile formulas is worth keeping no matter what happens to the usage limits.