By skillGoogle 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.
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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
- For the practice: a web browser. Each module runs in a copy of the real tool’s screens, so you need no account and no sign-up to start module 1.
- Helpful first: Gemini Jump Start: Gmail, Sheets, Slides, Deep Research and NotebookLM.
- To do it for real: a free Google account. Each module says which one it uses.
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
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) →