
Check the AI's Work in Google Sheets
Open a cell's sources, spot-check a filled column, catch bad cells with formulas and sign off. 6 lessons, first 2 lessons free.
On 28 October 2026, Google’s Workspace team announced that Fill with Gemini now shows the web sources behind each cell it fills in Google Sheets on the web, and that it supports up to 3,000 cells per request. Sources make a cell easier to check. They do not make it right, and many cells, such as a category, have no page behind them at all.
This course is about what you do after the fill. You open the source, read it, sample the column, let a few formulas read every row, fix the cells that fail and sign off with a note that says what you checked. It needs a plan with Gemini in Sheets for the Fill steps, and it says so in the first lesson. The checks themselves work on a column any assistant filled, so the skill outlives the feature.
For more on using AI inside a sheet, try AI for Google Sheets & Excel (first 2 lessons free) or AI for Google Workspace (first 2 lessons free).
What You'll Learn
- Explain what Fill with Gemini and the AI function do, which plans Google lists for them, and the limits Google documents
- Apply a source check to looked-up cells: open the page and write supports, doesn't support or can't tell
- Use a random sample and a set of risky rows to spot-check a filled column, and state what a clean sample does not prove
- Analyze a column with five ordinary formulas for blanks, labels off your list, agreement with an answer key and misplaced money
- Create a change log and a reusable cite-your-source prompt
- Evaluate a filled column and write a one-page sign-off that says what you checked and what you did not
After This Course, You Can
What You'll Build
Course Syllabus
Prerequisites
- You work in Google Sheets and have tried a chat assistant such as ChatGPT, Claude or Gemini
- For the Fill with Gemini steps, a Google plan that includes it (lesson 1 lists them); the checks also work on a column any assistant filled
Who Is This For?
- Bookkeepers and accountants who receive or build sheets with AI-filled columns
- Financial and operations analysts who send numbers to a manager or a client
- Virtual assistants who fill research and data-entry sheets for clients
- Anyone who works in Google Sheets weekly and has started using an assistant to fill columns
Frequently Asked Questions
Do I need a paid Google plan?
To use Fill with Gemini, Google says you need an eligible Google Workspace or Google AI plan (its help page also mentions the Google Workspace Experiments trusted tester program), and Google's 28 October 2026 post lists the plans. A free personal Google account is not on that list. The checks in the course work on a column filled by any assistant, so you can still take it.
Does the course say how often Fill with Gemini is wrong?
No. As of 19 November 2026 we found no accuracy study of Fill with Gemini. The course teaches you to measure your own column instead.
Is this only about Gemini?
No. Lesson 1 starts from Fill with Gemini, and from lesson 2 every check also works on a column filled by ChatGPT, Claude or another assistant.
Do the lessons use real client data?
No. The lessons run on a small sample we wrote, 12 expense memos with invented amounts. You may use a column of your own, with no client names in anything you paste into a chat.
Is this course free?
Lessons 1 and 2 are free with a free account. The rest of the course and the certificate come with Pro.
Will I get a certificate?
Yes, with Pro: finish every lesson and score at least 70% on the quizzes for a verifiable certificate.
How long does it take?
Six lessons; the course page shows the total time. Lesson 2 ends with a source check card, and lesson 6 with a sign-off page.








