Google Sheets' AI Function Now Shows Its Sources — Every =AI() Value Can Be Checked, Cell by Cell
The result first
The AI function in Google Sheets now shows where its answers came from.
When =AI() fills a cell from the web, the cell now carries its sources — the actual pages Gemini used. Click the cell, open “Sources,” and you can check the number against the original page. One request can now cover up to 3,000 cells at a time.
That is the whole change in one paragraph. Below is what it means, how it works, and the honest limits: it is a paid-plan feature, my own house does not use functions in its lists, and we have not tried this one yet.
I am Kurashiki Bouzu (kurashiki-bouzu), born in 1971, a former funeral director now living in an old house in Kurashiki, Okayama, writing articles every day by talking with Moka (Muse), my AI butler.
What changed
According to Google’s official announcement (Google Workspace Updates, October 28, 2026), the AI function and “Fill with Gemini” in Google Sheets now display, for each generated cell, the web pages that were referenced. Sources are attributed cell by cell, in Google Sheets on the web.
The scale grew at the same time: up to 3,000 cells per request. Google also reports speed: on a 500-cell task, the updated Fill with Gemini performed up to 55 times faster than manual entry, in an internal study with 95 participants.
A note on words: a “function” is an instruction you type into a cell. For example, =AI(“Write the location of this company’s headquarters”, A2) asks Gemini to look it up and put the answer in the cell. =GEMINI() works the same way.
Why it matters: check first, then use
AI answers can be wrong in a very convincing way. Numbers in a spreadsheet tend to travel — into reports, decisions, and prices. “Because the AI wrote it” is not a reason to trust a figure.
My house keeps a rule for exactly this: the person who looked something up does not check their own work. A separate set of eyes — in our case, a dedicated checking unit — verifies it. This update gives the tool itself a door for that second look. A source being attached does not make a value correct; you still have to open the page and compare. But there is a world of difference between “can check” and “cannot check.”
How it works
Following Google’s guidance, the flow is:
- In a cell, write =AI() with what you want done and the range it should look at
- Use “Generate and insert” to place the values
- Click a generated cell, hover over its content, and open “Sources”
- Open the original page and compare it with the value in the cell
Two cautions. Sources appear when the value was generated from web information; classifying or summarizing your own text may not attach any. And the sources are visible in Google Sheets on the web (on a computer browser), per the announcement.
The honest limits
This feature is for people whose plan includes Gemini in Sheets. For individuals, that means Google AI Pro or Google AI Ultra; for work accounts, Business Standard and above are among the editions listed in the announcement. On the free tier, this function cannot be touched yet.
Our house tests what the free tier can do — with Moka, and with Gemini. So we have not used this function. This article is a record of an announcement, not a hands-on report, and I want that line to stay clear.
One more honest note about the numbers. The announcement says up to 3,000 cells per request, but the function’s help pages still carry a line saying that, when multiple cells are selected, the first 350 are generated. Japanese explainers (Keiei AX; AXIA, November 5, 2026) have pointed out this mismatch. Which figure applies where is something to confirm on the actual screen — the same lesson as the sources themselves: do not swallow an announcement whole.
Our own house rule, kept separate
One more line, so there is no misunderstanding. In my house’s own lists, we do not use functions, and we do not use scripts (GAS) either. A sheet stays a table of contents; counting and calculations are Moka’s job. That is how we protect human time.
So this article is not “how our house uses functions.” It is information for readers who fill their own sheets with AI: now you can check where the numbers came from. The house rule and the reader’s information are two different things, and I keep them separate on purpose.
Cost, and where the numbers come from
- We spent 0 yen on this article. We read the official announcement and checked it against our candidate list
- The change itself (cell-level sources, up to 3,000 cells, the 55-times figure and its study conditions, the eligible plans) is from the Google Workspace Updates blog, October 28, 2026
- The plan prices (AI Pro at 2,900 yen per month, AI Ultra at 14,500 yen per month) are the figures shown on screen during our Gemini trials on November 19, 2026. We have not subscribed
What comes next
If this function ever reaches the free tier, we will try it and record how far the sources actually help. Google app changes keep arriving every day; our plan is to write them up one at a time, as standalone articles.
Sources
- Google Workspace Updates, “Fill with Gemini now provides cell-level citations for web sources and supports larger requests” (October 28, 2026): https://workspaceupdates.googleblog.com/2026/10/fill-with-gemini-now-provides-cell-level-citations-for-web-sources-and-supports-larger-requests.html
- Keiei AX, “GoogleスプレッドシートのAI関数がセルごとのWeb出典に対応”: https://keieiax.jp/blog/sheets-ai-citations/
- AXIA, “SheetsのGeminiがセルごとのWeb出典に対応。生成データを確認して使う手順” (November 5, 2026): https://ax.gsgs.co.jp/sheets-gemini-cell-web-citations-check/
- November 21, 2026 ― English draft (result-first rewrite of the Japanese article, not yet published)(4,579 characters)
- November 21, 2026 ― Published (all 7 languages at once, on the user's instruction). Japanese original: ledger No. 1150. New URL form with the ledger number at the end.(4,579 characters)
