How to Use Fill with Gemini Cell-Level Citations in Sheets

Google Sheets now shows the exact web sources Gemini used for each AI-generated cell. Announced on October 28, 2026, the update adds cell-level citations so you can audit results without leaving the sheet.

This change applies to the AI function (=AI() or =Gemini()) and Fill with Gemini workflows. It is available on the web version of Sheets for eligible plans. Gradual rollout started October 20 and can take up to 15 days.

If you already fill columns with Gemini, this builds on that foundation. See our earlier guide on filling Google Sheets columns with the Gemini AI function.

What changed and who can use it

When Gemini generates a value from web information, the sources now appear inside that individual cell. You no longer rely on a single list at the end of a request. Each cell carries its own citations.

Capacity increased to 3,000 cells per request. Processing is faster and more consistent across cells. An internal Google study with 95 participants found up to 55 times faster results than manual entry on a 500-cell English-language task.

Available on:

• Business Standard and Plus
• Enterprise Standard and Plus
• Google AI Pro and Ultra
• Google AI Pro for Education
• AI Expanded Access

Admins must have Gemini in Sheets enabled. The feature appears by default for eligible users. Access it via the Ask Gemini spark button in the top-right corner.

Prerequisites

Open Google Sheets in a browser. The cell-level sources appear only on the web version.

Confirm your plan matches one of the listed options. If you do not see the feature, wait for the rollout or check admin settings for Gemini access.

Have sample data ready. A list of company names, product descriptions, or feedback comments works well for testing.

Step-by-step: generate values and view citations

1. Open your spreadsheet on sheets.google.com.

2. Click the Ask Gemini spark button in the top-right corner to open the side panel. Or insert the function directly.

3. In a cell, type =AI(“your prompt here”, optional_range) or =Gemini(). Example: =AI(“Find the official website for this company”, A2).

4. Select the cell or range. Click Generate and Insert.

5. After the value appears, click into the cell. Hover over the generated content and click Sources. The web pages Gemini referenced appear for that specific cell.

6. Open the links to verify the information matches the output. Correct any mismatches manually.

For larger ranges, select multiple empty cells and use the Fill option in the prompt menu. You can process up to 3,000 cells in one request.

The help center notes that generation attributes the edit to you in version history. Refresh a cell with Refresh and Insert if source data changes.

Practical examples

Company research: Column A lists company names. Use =AI(“Write a one-sentence summary of the main products. Prefer official sources.”, A2). Check Sources in each result cell before sharing the sheet.

Sentiment analysis: Column B holds customer feedback. Prompt: =AI(“Classify as positive, neutral, or negative.”, B2). Citations help confirm the model drew from relevant context.

Data enrichment: Empty column for headquarters location. Prompt: =AI(“What is the headquarters city?”, A2). Verify each citation points to a reliable page.

Start with a small batch of 10–20 rows. Confirm citations align with your requirements, then expand.

Tips for better results

Write specific prompts. Ask for “official website” or “from the company about page” rather than a vague request. This improves source quality.

Reference existing sheet data with the optional range argument. Gemini does not see your whole spreadsheet or Drive files unless you include them.

Review citations before relying on numbers or claims for decisions. Sources are a verification starting point, not a guarantee of accuracy.

For very large jobs, break them into batches near the 3,000-cell limit. Monitor generation limits; long-term caps may pause Generate after heavy use.

If Sources does not appear, confirm you are on the web version and the rollout has reached your account. Language settings can also affect availability.

Limitations to know

Responses stay text-based. The AI function cannot embed other functions. It does not access your full spreadsheet automatically.

Generation is limited to the first 350 selected cells in one go for some operations; process the rest afterward.

Citations apply when Gemini pulls web information. Pure generation from your provided range may show fewer or different sources.

Conclusion

Cell-level citations turn Fill with Gemini from a speed tool into a verifiable workflow. You can generate summaries, categories, or research at scale and check each result against its web sources in the same cell.

Eligible Workspace and Google AI users can start today on the web. Open Sheets, run a small test with =AI(), and click Sources on the result.

The faster processing and 3,000-cell capacity make larger projects practical. Pair this with careful prompt design and manual review for trustworthy sheets.

Sources

• Google Workspace Updates: Fill with Gemini now provides cell-level citations for web sources and supports larger requests (October 28, 2026)
• Google Docs Editors Help: Use the AI function in Google Sheets
• Google Docs Editors Help: Collaborate with Gemini in Google Sheets