Lessons 1-2 Free Beginner

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.

6 lessons
83 min
Certificate Included

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

→ Open a cell's sources and say in one word whether the page supports the value, instead of passing on what the AI said
→ Run a spot-check of a filled column and write a sentence about it that does not claim more than the sample shows
→ Catch blank cells, invented labels and misplaced money with five ordinary formulas before a sheet reaches a client
→ Fix only the cells that failed and keep a change log, so a reviewer can see what the AI wrote and what you changed
→ Show a manager or a client a one-page sign-off for an AI-filled column, a record you can add to your portfolio

What You'll Build

Source Check Card
A card for six looked-up cells: the value, what the opened source says and a verdict, built from the sample or a column of your own.
Spot-Check Log and Check Block
A log of the rows you read and why, with five formulas and pass rules you wrote before looking at the results.
Check the AI's Work in Google Sheets Certificate
A verifiable credential proving you can check an AI-filled column against its sources, sample it, test it with formulas and sign it off.

Course Syllabus

6 lessons · 83 min

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
The research says
56%
higher wages for professionals with AI skills
PwC 2025 AI Jobs Barometer
83%
of growing businesses have adopted AI
Salesforce SMB Survey
$3.50
return for every $1 invested in AI
Vena Solutions / Industry data
We deliver
443+
Courses
Teachers, nurses, accountants, and more
2
free lessons per course to try before you commit
Free account to start
9
languages with verifiable certificates
EN, DE, ES, FR, JA, KO, PT, VI, IT
Start Learning Now

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.

2 Lessons Free