Gemini, Microsoft Copilot, Perplexity & the AI Tool LandscapeGoogle Gemini · Lesson 3 of 19
Gemini in Google Workspace
Video lecture
Gemini in Google Workspace
The narrated lecture is in production
Every chapter is scripted and ready. Browse the chapters and read the full transcript now — the video will appear here when it’s published.
Chapters
Transcript of the narration, chapter by chapter.
0:00 Gemini in Google Workspace
If your team lives in Gmail, Docs and Sheets, Gemini can work inside those tools with context you would otherwise copy and paste all day. In this lecture you will learn the difference between the Gemini app and Gemini in Workspace, five workflows that save real time, and the verification and data habits that keep you safe.
0:25 Why embedded AI matters
Why does AI inside Workspace matter so much? Because for most office work, the bottleneck is context. The information you need is scattered across emails, documents and spreadsheets, and copying it into a separate AI tool is slow and error prone. When Gemini sits inside those apps, it can see what you can see, so the question what did the client ask for last week becomes answerable in seconds. Think of it like having an assistant who already has access to your filing cabinet, and who respects the same locks you do.
1:05 Two ways to use Gemini
There are two ways to use Gemini at work. The Gemini app is a general assistant with Deep Research, Canvas, Gems, and image and video generation. Gemini in Workspace is built into Gmail, Docs, Sheets, Slides, Drive, Meet and Chat, usually through a side panel, and it can use content you already have access to. Many Workspace business editions include Gemini, while individuals can use Google AI plans for higher limits. Availability depends on your edition, admin settings, language and region.
1:40 Gmail: inbox catch-up
Workflow one, inbox catch up. Ask Gemini to summarise unread emails from the last three days that need your reply, with the sender, what they need, any deadline and a one line suggested response, marking anything uncertain. Then draft replies in the side panel, with T B C markers for missing facts, and send them yourself.
2:04 Docs: brief from Drive files
Workflow two, a brief from Drive files. In Docs, mention the specific files, for example the Q three campaign results and the client brief, and ask for a one page recap with objectives, results against targets, learnings and recommendations. Ask Gemini to name the file each point came from and to use T B C for anything not in the files. Now every line is checkable.
2:33 Sheets and Slides
Workflow three, Sheets. Ask Gemini to explain a formula, create one, such as flag rows where margin is under fifteen percent, or summarise trends, then spot check a few cells. Workflow four, Slides. Generate an outline from a Doc, create concept images, and rewrite speaker notes. But for anything customer facing that shows your product, use real photography.
2:58 Meet: notes and actions
Workflow five, Meet. Where enabled, Gemini can take meeting notes and summarise actions. Tell participants, follow your policy and local law on recording and transcription, and check owners and dates before you distribute the notes. Summaries can mishear names and overstate agreement.
3:16 Grounding habits
Four grounding habits. Reference files explicitly. Ask which file each point came from. Check numbers against the sheet and quotes against the email. And remember Gemini respects your existing Drive permissions, so it can surface anything you can open, including files that were overshared. If you see something you should not, report it.
3:39 Admin and data
For Workspace business editions, Google states that your data is not used to train its models outside your domain without permission and is covered by Workspace's enterprise data protections, and admins control Gemini features per organisational unit. Personal Google accounts have different settings. Confirm the current terms with your admin before using client data.
4:02 Simple example
A simple example. You come back from holiday to a twenty three message email thread about a product launch. Open it in Gmail, open the Gemini side panel and ask for a summary with three headings, decisions made, open questions, and anything waiting on you. In seconds you know the launch date moved, the packaging is still undecided, and the designer is waiting for your approval on the banner. You reply to the one thing that needs you, and you are caught up.
4:38 Worked example: Monday in Riyadh
An account manager at a Riyadh agency starts Monday with the inbox catch up, fourteen threads need replies. She drafts them with T B C markers for two missing delivery dates, creates a client recap from two Drive files with file references, and asks Sheets to flag campaigns above their cost per acquisition target. She checks the three flagged campaigns by hand and sends everything herself before ten. Over the following weeks she saved her best side panel prompts in a shared team document, one for inbox catch up, one for client recaps, one for Sheets checks. Two colleagues started using them. Their team's Monday stand up now begins with everyone already caught up, and the conversation moves straight to decisions instead of status updates.
5:32 Try this now
Try this now. Choose one Workspace task you do every week, inbox catch up, a status report built from Drive files, or a sheet analysis. Run it with Gemini using the matching prompt from the lesson, asking for sources and T B C markers. Time it, and compare with how long it normally takes. Then count how many corrections you had to make. If the time saved is real and the corrections are small, make it your new routine and share the prompt with your team.
6:09 Common mistakes
Four common mistakes with Gemini in Workspace. Sending AI drafts without reading them. Trusting meeting summaries that may have misheard a name or overstated agreement. Using a personal Google account for work data, where different terms apply. And forgetting that anything overshared in Drive can now surface in an AI answer. Each one is avoidable with a few seconds of attention.
6:36 Watch me do it, part 1
Let me run the Riyadh account manager's Monday. In Gmail I open the Gemini side panel and type the catch up prompt. Summarise unread emails from the last three days that need a reply from me, with sender, what they need, deadline and a suggested one line response, and mark anything uncertain. Fourteen threads come back. I open the first, a client asking for the delivery schedule, and ask Gemini to draft a reply. Two dates are unknown, so they appear as T B C, exactly as I wanted. I fill one date from my notes, leave the other as to be confirmed by Thursday, and send it myself.
7:23 Watch me do it, part 2
Next, in Docs, I type the recap prompt and reference two files with the at sign, the Q three results sheet and the client brief. The recap appears with the source file named after each point, so I can check any line quickly. Then Sheets. I ask Gemini to flag campaigns where cost per acquisition is above the target in column F. Three rows light up. I check them by hand, and one is a false alarm, because the target cell for that campaign was blank. I fix the blank and rerun. Everything is reviewed and sent before ten.
8:06 Recap and next step
Recap. Use the Gemini app for general work and Gemini in Workspace for context from your mail, files and meetings. Reference files explicitly, ask for sources and T B C markers, verify numbers, and send everything yourself. Your next step: pick one recurring Workspace task, run it with the relevant prompt, and record the time saved and what you had to correct.
Two ways to use Gemini at work
- The Gemini app (gemini.google.com and mobile apps): a general assistant with Deep Research, Canvas, Gems, image and video generation, and connections to Google apps. With a work account, it runs under your organisation's Workspace terms.
- Gemini in Google Workspace: AI built into Gmail, Docs, Sheets, Slides, Drive, Meet and Chat, usually via a Gemini side panel and in-app features such as "Help me write". It can use content you already have access to (emails, files, meetings) without copy-paste.
Google includes Gemini features in many Workspace business and enterprise editions; for individuals, Google AI plans (for example Google AI Plus, Pro and Ultra) raise limits and add features. Availability varies by edition, admin settings, language and region, so check your admin console or Google's plan pages.
High-value Workspace workflows
Gmail: inbox catch-up
Summarise unread emails from the last 3 days that need a reply from me.
For each: sender, what they need, deadline if stated, and a one-line
suggested response. Mark anything you're unsure about.Then draft replies with the side panel, marking missing facts as [TBC], and send them yourself.
Docs: brief from Drive files
Using @[Q3 campaign results] and @[Client brief - Al Noor], draft a
one-page campaign recap: objectives, results vs targets, three learnings,
next-quarter recommendations. After each point, name the file it came
from. Use [TBC] for anything not in the files.Sheets: analysis and formulas
Ask Gemini to explain a formula, create one ("flag rows where margin is under 15%"), summarise trends, or build a pivot-style summary. Verify results by spot-checking a few cells.
Slides: first drafts and visuals
Generate a slide outline from a Doc, create images for concept slides, and rewrite speaker notes. Replace AI images with real product photography for anything customer-facing that shows your product.
Meet: notes and follow-ups
Where enabled, Gemini can take meeting notes and summarise actions. Inform participants, follow your policy and local law on recording and transcription, and check owners and dates before distributing.
Grounding and verification
- Reference files explicitly (the @ mention of files) and ask which file each point came from.
- Ask for [TBC] markers rather than letting Gemini fill gaps.
- Check numbers against the sheet; check quotes against the email.
- Remember Gemini respects your existing Drive permissions, so it can surface anything you can open, including overshared files. Report anything you should not see.
Admin and data
In Workspace business editions, Google states that your data is not used to train its models outside your domain without permission and is covered by Workspace's enterprise data protections; admins control which Gemini features are on, per organisational unit. Confirm current terms with your admin. Personal Google accounts have different settings (see the privacy discussion in Module 7).
Worked example: account manager's Monday in Riyadh
An account manager at a Riyadh agency runs the inbox catch-up prompt (14 threads need replies), drafts replies with [TBC] markers for two missing delivery dates, creates a client recap Doc from two Drive files with file references, and asks Sheets to flag campaigns under their CPA target. She verifies the three flagged campaigns manually and sends everything herself before 10am.
Hands-on
Pick one recurring Workspace task (inbox catch-up, status report, sheet analysis). Run it with Gemini using the relevant prompt, then record time saved and what you corrected.
Prompt patterns for each app
| App | Pattern | Example |
|---|---|---|
| Gmail | Triage → draft → you send | "Which of these need a reply today? Draft replies with [TBC] for missing facts." |
| Docs | Reference files → cite sources | "Using @file1 and @file2, draft... name the file for each point." |
| Sheets | Explain → create → verify | "Explain this formula; then write one that flags margins under 15%." |
| Slides | Outline from Doc → real visuals | "Create a 6-slide outline from @brief; suggest where a chart belongs." |
| Meet | Notes → check owners → share | "List decisions and actions with owners; mark anything uncertain." |
Save these as a shared team document so everyone uses the same proven patterns.
Pitfalls
- Letting drafts go out unchecked.
- Assuming meeting summaries capture decisions accurately.
- Using a personal account for work data.
- Forgetting that oversharing in Drive becomes visible through AI search.
How to measure success
Routine Workspace tasks take noticeably less time, every sent message was reviewed, and file-referenced drafts need fewer corrections.
Key takeaways
- Gemini is available as a standalone app and inside Google Workspace apps; features vary by account, plan, admin settings and region.
- Workspace integration provides context without copy-paste, within your existing permissions.
- Ask Gemini which file or email each point comes from, and use [TBC] markers for missing details.
- Use Gems for recurring tasks and follow admin and data policies for work accounts.
Check your understanding
Quick questions to lock in the lesson. They don’t count towards your certificate.
Put it into practice
Pick one recurring Workspace task (an inbox catch-up, a status report or a sheet analysis). Run it with Gemini using the relevant workflow and note the time saved and what you had to correct.
Enrol for free to save your progress
Reading is always free. Enrol to keep your place, take the final assessment and earn a verifiable certificate.