Lesson 03 · Gemini Mastery Pro ~13 min read 4 workflows

Gemini in Sheets: analysis without the headache.

Google Sheets users have historically been the underdog vs. Excel — but Gemini in Sheets closes that gap fast. This lesson covers the four workflows that turn Sheets into a real analytical tool: formula generation, Smart Fill, data cleaning, and chart creation from natural language.

The mental model

Sheets + Gemini ≈ Excel + Copilot for most knowledge worker use cases.

If you've been Excel-curious because Copilot makes it easier, here's the news: Gemini does most of the same things in Google Sheets, and the integration with the rest of Workspace is tighter. The capabilities are similar; the choice is mostly about which ecosystem you live in.

Workflow 01 Formula generation in plain English

1

Stop Googling Sheets functions

Ask Gemini for the formula you need by describing what you want.

The prompt that works

Formula promptI have a table where column A is date, column B is salesperson, column C is amount. Add a column showing rolling 30-day total for each salesperson.

Best use cases

  • SUMIFS, COUNTIFS, and other conditional formulas
  • Date arithmetic and rolling totals
  • QUERY() with proper syntax
  • Complex IF chains
Gemini's Sheets formulas can have subtle errors on edge cases (dates near month boundaries, empty cells). Spot-check the first few rows.
Time savings: Formula research: 30 min → 1 min.

Workflow 02 Smart Fill: pattern-recognition magic

2

Type 2 examples, get 1000

In a new column, type 2-3 examples of what you want. Smart Fill recognizes the pattern and offers to fill the rest.

The prompt that works

Use patternColumn A has full names like "Sarah Chen (Acme Corp)." In column B, type the company for the first 2 rows: "Acme Corp," "Globex." Smart Fill suggests filling B for all rows.

Best use cases

  • Extracting parts of structured strings
  • Reformatting dates, names, addresses
  • Generating derived columns from existing data
  • Common cleaning tasks
Smart Fill only works on patterns it can recognize from your examples. For ambiguous patterns, give it 4-5 examples instead of 2.
Time savings: Manual derived-column work: gone.

Workflow 03 Data cleaning at speed

3

Fix messy data with Gemini in the side panel

Open the Gemini side panel in Sheets. Describe what's wrong with your data. Gemini suggests transformations.

The prompt that works

Cleaning promptColumn D has dates in five different formats. Help me normalize them all to YYYY-MM-DD.

Best use cases

  • Standardizing dates, currencies, addresses
  • Removing duplicates with custom matching rules
  • Splitting/combining columns
  • Validating data against rules
Always work on a copy first. Cleaning operations are not always reversible if you don't have an undo path.
Time savings: Hours of manual cleanup: minutes.

Workflow 04 Charts from natural language

4

Describe the chart, get the chart

Instead of fighting the chart wizard, describe what you want.

The prompt that works

Chart promptShow me a stacked bar chart of revenue by product line by quarter for 2025. Sort by total descending. Use blue tones.

Best use cases

  • Executive dashboards
  • Trend visualizations
  • Comparison charts
  • Quick-look summaries of data
Gemini's chart formatting is functional but not magazine-quality. For customer-facing visuals, clean up labels and legend after.
Time savings: Chart-fiddling: 15 min → 30 sec.

Final challenge: rebuild a real spreadsheet with Gemini

Pick a spreadsheet you previously spent 60+ min building manually. Open a fresh Sheet. Use only the four workflows above to rebuild it. Time yourself; compare to the original.

Back to Gemini Mastery → See pricing →

What you can do now

  • Generate complex formulas by describing what you want
  • Use Smart Fill for any derived-column work
  • Clean messy data with Gemini suggestions
  • Build charts from natural-language descriptions
  • Recognize Gemini's edge-case errors and verify outputs
Pro
Up next in Gemini Mastery

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

Setting up notebooks with source documents, asking questions across PDFs, generating study guides and podcasts. The free Google tool every researcher should know. See pricing →