Gemini, Microsoft Copilot, Perplexity & the AI Tool LandscapeGoogle Gemini · Lesson 3 of 19

Gemini in Google Workspace

Article · 16 min · 8 min lecture

Video lecture

Gemini in Google Workspace

16 chapters · about 8 min · full transcript

Coming soon

Chapter 1 of 16

Gemini in Google Workspace

  • Gmail
  • Docs
  • Sheets
  • Slides
  • Meet

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

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

AppPatternExample
GmailTriage → draft → you send"Which of these need a reply today? Draft replies with [TBC] for missing facts."
DocsReference files → cite sources"Using @file1 and @file2, draft... name the file for each point."
SheetsExplain → create → verify"Explain this formula; then write one that flags margins under 15%."
SlidesOutline from Doc → real visuals"Create a 6-slide outline from @brief; suggest where a chart belongs."
MeetNotes → 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.

  1. What is the main advantage of using Gemini inside Google Workspace?
  2. Why ask Gemini which file each point in a brief comes from?
  3. Who controls which Gemini features are available in a company Workspace account?

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.