Gemini in Google Workspace for Beginners: Sheets, Gmail, Docs
Updated · By Robert Breen
The problem
Sam is the office manager at a 20-person HVAC company. Monday means reading a weekend of customer emails, turning the service log into a summary for the owner and writing the same "your appointment is confirmed" note a dozen times.
What you’ll be able to do
You will know what Gemini can do in Sheets, Gmail and Docs, whether your account has it, how to ask for exactly what you need, and the checks that keep an AI mistake out of a customer’s inbox.
What Gemini in Workspace is
Gemini is Google’s AI assistant. Inside Workspace it appears in two ways: an Ask Gemini button at the top right of Gmail, Docs, Sheets, Slides and Drive that opens a side panel, and inline helpers such as "Help me write" in Gmail and Docs. It works with the file or email you have open. The AI glossary page on Gemini covers the assistant in general; this lesson is about using it inside the apps.
What it does in each app
| App | Good first requests | Watch out for |
|---|---|---|
| Gmail | Summarize a long thread; draft a reply; make a draft shorter or more formal | Dates, prices or promises it adds that are not in the thread |
| Sheets | Build a starter table from a description; explain or write a formula; summarize what a sheet shows | Works best on tidy data with one header row in a native Google Sheets file |
| Docs | Draft from an outline; summarize a long document; rewrite a section in plain language | Facts and figures it was not given |
Which accounts include it
Gemini in the Workspace apps depends on your plan. Business plans include it unless the admin turns it off, and Google sells AI plans for personal accounts. Some features also reach free Gmail accounts in some countries. Google changes this often, so check Using Google Workspace with Gemini and, for Gmail, Learn about Gemini features in Gmail to see what your account has.
Sam’s Monday, with Gemini
- In Gmail, open the longest customer thread and select Summarize this email at the top (or open Ask Gemini and ask for a summary). Read the summary, then open the messages it says need a reply.
- Still in Gmail, start a reply and use Help me write: "Confirm the appointment for Thursday 8 to 10am, remind them to clear access to the furnace, friendly and short." Edit the draft before sending.
- In Sheets, open the service log, select Ask Gemini and ask: "Which technician closed the most jobs last week, and which jobs are still open more than 3 days?" Check the answer against the sheet before you use it.
- In Docs, open a blank document, use Help me write and ask for "a five-bullet weekly update for the owner from these notes," then paste in the answers from Gmail and Sheets.
Word your request like a brief
Gemini responds better to the same details you would give a new colleague: the goal, the source, the audience and the format. "Summarize this" works; "Summarize this thread for the owner in three bullets and list anything the customer is still waiting on" works better. The AI glossary’s Role, Context, Task, Format page shows the pattern.
Two checks before you use it
Check every number, date and name against the source. AI can state wrong things confidently, which the AI glossary calls a hallucination. If Gemini says Tech B closed 14 jobs, filter the sheet and count.
Insert or copy what you want to keep. Google notes that the side-panel conversation can be lost when you reload the page, so put useful output into the file before you move on.
Check your understanding
Where do you usually find Gemini in Gmail, Docs and Sheets?
Show the answer
The Ask Gemini button at the top right, plus inline tools like Help me write. Workspace puts Gemini in a side panel opened from the top right, with inline helpers in Gmail and Docs.
Gemini’s draft reply offers the customer a 15% discount nobody agreed to. What went wrong?
Show the answer
The draft added a commitment that is not in the source; edit it out. Always check drafts for promises, prices and dates that you did not give it.
Why insert Gemini’s output into the sheet or doc?
Show the answer
The side-panel conversation can be lost on reload. Google’s help notes that side-panel history can be lost when the page reloads.
Sources
Written from these official help pages. Menus change, so if a button has moved, the help page has the current wording.
- Google Workspace Learning Center: Using Google Workspace with Gemini
- Gmail Help: Learn about Gemini features in Gmail
- Google Docs Editors Help: Collaborate with Gemini in Google Sheets
- Google Docs Editors Help: Collaborate with Gemini in Google Docs
- Google Workspace Learning Center: Summarize content and organize data
Terms in this lesson
Related in the AI glossary
Do this with AI
Want to practice in Gmail? The free Stepthrough lesson on Gemini in Gmail walks through summarizing threads and drafting replies step by step.
Open the free AI lesson