カテゴリ 古民家暮らしモカとの記録セキュリティの記録副業の記録

The record with MokaNovember 21, 2026

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:

  1. In a cell, write =AI() with what you want done and the range it should look at
  2. Use “Generate and insert” to place the values
  3. Click a generated cell, hover over its content, and open “Sources”
  4. 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

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

Record of this article
  • 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)

#AI #Google Sheets #Functions #Moka #Beginners

← Back to the article list / ← Back to the English top page