Lesson 03 · Gemini Mastery Pro ~13 min 4 workflows

Gemini in Sheets: analysis without the headache.

Google Sheets has long been the underdog to Excel — but Gemini closes that gap fast. Four workflows turn Sheets into a real analytical tool: formula generation in plain English, Smart Fill, data cleaning, and charts from a sentence. We'll start with the one that feels like magic.

The mental model

Roughly Excel + Copilot, in your ecosystem.

If you've eyed Excel because Copilot makes data work easier — Gemini does most of the same things in Sheets, with tighter ties to the rest of Workspace. The capabilities are close; the real choice is which ecosystem you already live in.

Sheets + Gemini

formulas · Smart Fill · cleaning · charts

≈

Excel + Copilot

the same moves, other ecosystem

Do it · Smart Fill

Type two, get the rest.

Column A has names with the company in parentheses. You've typed the company into column B for the first two rows. Hit Smart Fill and watch Gemini spot the pattern and finish the column.

📊 contacts.gsheet2 examples typed

A · Full name (Company)

B · Company

Gemini will infer column B from your two examples.

Two examples were enough. Smart Fill read the pattern — "the bit in parentheses" — and applied it to every row. Gotcha: for ambiguous patterns, give it 4–5 examples instead of 2, and spot-check the result.

The four workflows

Your Sheets toolkit.

🧮 Formula generation

Describe the result; get the formula. SUMIFS, QUERY(), rolling totals, gnarly IF chains.

"Add a rolling 30-day total per salesperson."

✨ Smart Fill

Type 2–3 examples in a new column; it fills the rest from the pattern.

Extract company → fill 800 rows.

🧹 Data cleaning

Describe what's wrong in the side panel; it suggests the transform.

"Normalize column D's dates to YYYY-MM-DD."

📈 Charts from words

Skip the chart wizard — describe the chart you want.

"Stacked bar: revenue by product line by quarter, blue tones."

Your call · which move?

Pick the right Sheets workflow.

Verify before you trust it

Spot-check generated formulas on edge cases (month boundaries, empty cells). Work on a copy before cleaning — some transforms aren't cleanly reversible. And Gemini's charts are functional, not magazine-quality, so tidy labels and legends before anything customer-facing.

Rebuild a real spreadsheet with Gemini

Pick a sheet you once spent 60+ minutes building by hand. In a fresh Sheet, rebuild it using only the four workflows — generate the formulas, Smart Fill the derived columns, clean the messy data, chart the result. Time yourself against the original.

Try a prompt in the playground → Back to Gemini Mastery

What you can do now

Generate complex formulas by describing the result you want
Use Smart Fill for any derived-column work — two examples, then go
Clean messy data with side-panel suggestions (on a copy)
Build charts from a one-sentence description
Spot-check Gemini's edge-case errors before trusting the output

Pro

Up next in Gemini Mastery

Lesson 4 · NotebookLM: the research tool that's eating academia

Set up notebooks with source documents, ask questions across PDFs, and generate study guides and podcasts — the free Google tool every researcher should know. Start lesson 4 →