A small team workspace, two colleagues reviewing a printed spreadsheet-style grid of cells on a table, colored pens, coffee.By skill

Google Workspace for Work: Sheets, Gmail and Gemini

What you’ll be able to do: Use the Google apps your team already has: a Google Sheets job tracker that totals itself, Gmail filters and checked AI drafts, Gemini in Gmail, and cited answers and briefings from your own documents.

Who it’s for
Office staff, owners and team leads at small businesses that run on Gmail, Google Sheets and Drive. A free Google account is enough to start.
Time needed
About 61 minutes of hands-on practice: 9 modules of 4 to 15 minutes each.
Cost
Free. No credit card, no trial, and no sign-up needed to start.
Level
Beginner to Intermediate
Prerequisites
None for the practice: a web browser on a desktop or laptop. Helpful first: Gemini Jump Start: Gmail, Sheets, Slides, Deep Research and NotebookLM. To repeat the modules in your own tools: a free Google account.
Format
Self-paced and online. Each module runs in a practice copy of the real tool that checks every step, then a checklist walks you through doing it for real.
Tools you practice in
Google Sheets, Gmail, Gemini, Gemini Notebook and Google Slides.

Google Workspace for Work: Sheets, Gmail and Gemini is a free, hands-on AI course for office staff, owners and team leads at small businesses that run on Gmail, Google Sheets and Drive: 9 short modules (about 1 hour in all) where you do each step yourself in a safe practice copy of Google Sheets, Gmail, Gemini, Gemini Notebook and other tools, which checks your work. No coding, no cost, and you can start without signing up.

9 modulesBeginner to Intermediate~1 hr of practiceFree

Why this course

Most small teams already use Google Workspace, paid or free, and still lose hours to the same jobs: a job list nobody trusts because three people keep their own copy, an inbox sorted by hand, and long threads and documents someone has to read before every meeting.

This course starts with the spreadsheet everyone needs, built on real Google Sheets screens, then moves to Gmail and the Gemini features that summarize, draft and answer from your own files. Each module is a hands-on practice, then a checklist to do it in your own account.

What you’ll build

  • Module 1: A Google Sheet called "Jobs, October" with eight jobs, a frozen header, a Status drop-down (Booked, Done, Invoiced, Paid), SUMIF totals for each status, a yellow highlight on every job that is done but not invoiced, and a saved "Crew A" filter view.
  1. Module 1 · Google Sheets · Beginner · ~15 min

    Google Sheets: Build a Job Tracker That Totals Itself

    A beginner Google Sheets walkthrough on real screens: freeze the header, make Status a drop-down, total each status with SUMIF, highlight finished-but-unbilled jobs and save a filter view for each crew. Free Google account.

  2. Module 2 · Gmail · Intermediate · ~8 min

    Gmail Filters, Labels and AI Drafts With a Human Check

    Make Gmail label every website quote request automatically, draft the reply with Help me write, and catch the made-up price before it's sent.

  3. Module 3 · Gmail + Gemini · Beginner · ~7 min

    Gemini in Gmail: Summarize a Thread and Draft the Reply

    Catch up on a long email thread in seconds with Summarize this email, ask Gemini what you owe, then write, refine and polish the reply with Help me write.

  4. Module 4 · Gemini Notebook · Beginner · ~7 min

    NotebookLM (Now Gemini Notebook): Cited Answers and a Briefing from Your Docs

    Create a notebook, add a PDF, a Google Doc from Drive and a web page as sources, ask a question and check its citations, save the answer to a note, and turn it all into a Briefing Doc.

  5. Module 5 · Gemini Notebook · Beginner · ~6 min

    NotebookLM Audio Overview: Turn Your Documents into a Podcast

    Paste a new hire handbook and meeting notes into a notebook, customize an Audio Overview for two new accountants, listen, join the conversation with Interactive mode, and share it with the new hires.

  6. Module 6 · Gemini · Beginner · ~6 min

    Gemini Deep Research: a cited brief before a client meeting

    Ask Gemini Deep Research to research a prospect's industry, read its plan before it starts, then check where the key numbers really came from.

  7. Module 7 · Gemini · Beginner · ~4 min

    Gemini: Make a Tenant Notice as a PDF and Fix It Right in the Chat

    Ask Gemini for a one-page PDF notice, expand it full screen, fix the lines it made up by selecting them or typing over them, then export it. An 8-step practice checked in the real Gemini app.

  8. Module 8 · Google Sheets · Beginner · ~4 min

    Google Sheets: Fill a Research Column with Gemini and Check Its Sources

    Select empty cells, click Fill and let Gemini look up where six companies are headquartered, then open one cell's web sources before the list goes to a client. A 7-step practice based on Google's published screens.

  9. Module 9 · Google Slides · Beginner · ~4 min

    Gemini in Google Slides: Fix a Late Change Across a Whole Client Deck

    Two facts changed the day before a client review. Tell Gemini once, check the slides it touched, fix the line it left behind, and know the one-slide route if the rollout has not reached you. An 8-step practice.

Prerequisites

Time to complete

About 1 hour of hands-on practice across 9 modules (157 steps in all). Modules take 4 to 15 minutes each, so you can do one in a sitting and come back for the next.

Take it with you

Google Sheets job tracker cheat sheet: the settings and words from this course on one printable page. Read it online · Download the PDF

Glossary

SUMIF Data validation Google Sheets Gemini NotebookLM

Questions about this course

Is Google Workspace for Work: Sheets, Gmail and Gemini free?

Yes. All 9 modules of Google Workspace for Work: Sheets, Gmail and Gemini are free, and you can start module 1 without signing up.

How long does Google Workspace for Work: Sheets, Gmail and Gemini take?

About 1 hour of hands-on practice across 9 modules, beginner to intermediate. Each module takes 4 to 15 minutes, so you can do one at a time.

Which tools will I practice in?

Google Sheets, Gmail, Gemini, Gemini Notebook and Google Slides. You practice in a copy of each tool's real screens that checks every step, so nothing touches your real accounts, and no coding is needed.

Who is Google Workspace for Work: Sheets, Gmail and Gemini for?

Office staff, owners and team leads at small businesses that run on Gmail, Google Sheets and Drive. A free Google account is enough to start.

Where do I start?

Start with module 1, Google Sheets: Build a Job Tracker That Totals Itself. The modules are in order, so each one builds on the last.

Do I need a paid Google Workspace plan for this course?

No. The Google Sheets and Gmail filter modules work with a free Google account. Gemini features in Gmail and Gemini Notebook depend on your account and plan; each module says what it needs.

Will the practice change my Google account?

No. Each practice is a click-through copy that checks your work and never touches your account. Every module ends with a checklist to do it for real.

What do I need before I start Google Workspace for Work: Sheets, Gmail and Gemini?

Only a web browser for the practice: it runs in a copy of each tool's screens, so you need no account and no sign-up to start module 1. To repeat a module in your own tools afterwards, the modules list a free Google account. It helps to take Gemini Jump Start: Gmail, Sheets, Slides, Deep Research and NotebookLM first.

Want help doing this for real? Book a 1:1 session with Robert ($85/hour) →

← All courses