Gemini Across Workspace

40 min intermediate Lesson 5

Learning Outcomes

  • Navigate the standalone Gemini app and its subscription tiers
  • Operate the Gemini side panel inside Docs, Sheets, and Gmail
  • Generate and refine documents using Help me write and Help me create
  • Exploit Gemini's multimodal strengths with images, screenshots, and video
  • Decide when Gemini's integration beats Claude or ChatGPT for a task

Lesson Plan

Segment Duration Topic
Intro 3 min Why Gemini is different — it lives where you work
Tour 6 min The standalone Gemini app and the tiers
Demo 8 min Gemini in Docs and Sheets
Demo 6 min Gemini in Gmail
Demo 6 min Multimodal: images, screenshots, video
Compare 6 min Where Gemini wins, where it doesn't
Wrap-up 5 min Key takeaways, preview next lesson

Before You Begin

Pre-work:

Shopping List:

  • A signed-in Google account (free tier is fine to start)
  • A modern browser
  • Optional: a paid Google AI subscription for higher limits and the most capable model
  • A few sample files: a screenshot, a photo, and a short video clip
1 The Standalone Gemini App and the Tiers

Open gemini.google.com or the app. The layout is familiar after Claude and ChatGPT: a conversation pane, a sidebar of chat history, and a prompt box with a plus menu and a tools menu. There is a free tier for any Google account, plus paid tiers that raise your usage limits and give greater access to Google's most capable model.

Tier What you get Best for
Free Everyday Gemini plus limited Deep Research, Canvas, Gemini Live, image generation Light use
Google AI Plus Higher usage limits than free Regular personal use
Google AI Pro Much higher limits, more model access, video generation, larger uploads Power users
Google AI Ultra The highest limits and fullest access Heavy daily use

You can follow most of this lesson on the free tier.

NOTE
Naming Note
Google reshuffles these plan names often, and older menus may call the top experience Gemini Advanced. Whatever the label, paid tiers buy higher limits and the strongest model.
TIP
Pick Your Account Carefully
Gemini ties to the account you sign in with. With both a personal and a work account, choose deliberately — only the work account reaches your work Docs, Sheets, and Gmail.
2 Gemini Inside Google Docs

This is where Gemini pulls ahead: it lives inside the documents you already use. In a throwaway Doc, find the Gemini control — a side panel from the top-right Ask Gemini button, and a pill-shaped bottom bar for prompts. Two headline features live here: Help me write edits across the document (select a paragraph first to focus it), and Help me create generates a formatted first draft that pulls from your files, emails, and the web.

Try a from-scratch draft in the bottom bar:

> Help me create a one-page kickoff brief for a website redesign. Include sections for goals, scope, timeline, and risks. Keep it under 400 words with clear headings.

Then select a paragraph and refine it:

> Rewrite the selected paragraph to sound more confident and remove hedging words like "maybe" and "we think".

Gemini's suggested edits stay visible only to you until you approve them — the same review checkpoint as Claude's permission model.

TIP
Match the House Style
Docs includes a Match writing style tool that keeps tone consistent across contributors. Run it after a Help me write pass to smooth the seams.
WARNING
Read Before You Accept
Help me create synthesises from your files and the web, so it occasionally invents plausible-but-wrong detail. Treat the draft as a starting point — verify names, numbers, and dates.
3 Gemini Inside Google Sheets

Sheets is where Gemini does something hard to replicate: it populates cells with structured, real-world data on demand. Open your Sheet, open the Gemini side panel, then use Fill with Gemini to enrich a column:

> For each company name in column A, fill column B with its headquarters city and column C with the industry it operates in.

Gemini searches for current information and writes the results straight into the cells, far faster than copying values by hand. It can also build a table from scratch, summarise trends, or write a formula — always name the target cell or range.

NOTE
Why This Matters
Claude and ChatGPT analyse a spreadsheet you upload; Gemini edits your live Sheet in place. That ask-fill-verify loop is its standout advantage.
WARNING
Auto-Filled Data Needs Auditing
When Gemini pulls web facts into cells, it does not flag uncertainty. Spot-check a few rows against a trusted source before acting on the numbers.
4 Gemini Inside Gmail

Open the Gemini side panel from the Ask Gemini button in Gmail's top right. It can summarise long threads, draft replies, and answer questions spanning several emails.

Open a long thread to summarise it, or reach across your whole mailbox at once:

> Find every email about the Q3 budget from the last two weeks and tell me the current agreed figure.

A standalone chatbot cannot do this — it has no access to your inbox, which is exactly why account choice matters.

WARNING
Privacy and Tone
Gemini drafts read as competent but generic. For anything sensitive — a complaint, a negotiation, bad news — draft for speed, then rewrite in your own voice. And since it reads across your mailbox, be deliberate about which account you connect.
5 Multimodal Strengths — Images, Screenshots, and Video

Gemini was built multimodal from the ground up. In the standalone app, use the plus menu to attach a screenshot, a chart, or a photo of a receipt or whiteboard, and have it explain or extract the contents:

> This is a screenshot of an error dialog. Explain in plain English what went wrong and give me three things to try, easiest first.

On the higher tiers, Gemini can also generate short video clips from a description and reason about video you provide — summarising a clip or finding a specific moment.

TIP
Crop First, Ask Second
A tightly cropped image of the one error line reads far more accurately than a full-desktop screenshot — the model spends its attention where it counts.
NOTE
Where Gemini Earns Its Place
If your work involves screenshots, photos of printed material, or quick image and video tasks, Gemini's native multimodal handling makes it the natural reach-for tool — even when you prefer others for writing.
6 Where Gemini Wins — and Where It Doesn't

You now have three serious tools; the skill is matching each to the job:

Task Reach for Why
Editing a live Doc, Sheet, or email Gemini Works in place, inside the file
Reading screenshots and photos Gemini Native multimodal, fast and accurate
Long, nuanced writing and reasoning Claude or ChatGPT Often stronger on tone and depth
Data analysis with charts ChatGPT Code Interpreter Runs real code on your data

Send one identical prompt to all three and compare on tone, accuracy, and instruction-following:

> Write a 150-word announcement for our team about a new flexible-working policy starting next month. Warm but professional tone, end with one clear call to action.

That side-by-side habit is the focus of the next lesson.

TIP
Don't Marry One Tool
The power-user move is fluency across all three, not loyalty to one. Reach for Gemini on anything touching your Google data, and switch freely otherwise.
WARNING
Integration Cuts Both Ways
Gemini's Workspace access is its superpower and its risk. Before connecting a work account, confirm your organisation permits it, and never paste confidential material into any AI tool without authorisation.

Questions & Answers

Q: Do I have to pay to use Gemini in Docs and Gmail?
There is a free tier with core Gemini features, and the in-app Workspace integration spans paid Google Workspace plans. Availability depends on your account and region. Start free, then upgrade only if you hit usage limits or need the most capable model.
Q: Can Gemini read my whole Gmail inbox and my Drive without asking?
It operates within the account you are signed into, drawing on your Gmail, Drive, and Docs to answer in context. That is why account choice matters — keep sensitive work on accounts where your organisation has approved Gemini, and check your admin's policy on managed accounts.
Q: Gemini filled my spreadsheet with data — can I trust it?
Treat auto-filled cells as a fast first draft, not verified truth. Gemini pulls current web information but does not flag when it is unsure. Spot-check a few rows against an authoritative source before relying on the figures, especially anything financial or legal.
Q: The plan names and model versions in my account don't match this lesson. Did I do something wrong?
No — Google renames tiers and ships new models constantly, so labels drift. The durable principles hold regardless: a free tier exists, paid tiers raise limits and unlock the strongest model, and the side panel works the same way whatever it is called. Lesson 10 covers staying current with this churn.

Key Takeaways

  1. Gemini lives where you work — its advantage is editing your real Docs, Sheets, and Gmail in place, not in a chat window.
  2. Help me write and Help me create — draft and refine text in Docs, with edits held back until you approve.
  3. Sheets is the standout — it fills columns with current web data in your live spreadsheet, but every row needs auditing.
  4. Multimodal is a genuine strength — screenshots, photos, and video are where Gemini shines; crop tight for accuracy.
  5. Account choice is everything — Gemini works within the account you sign in with, so choose personal vs work carefully.
  6. Stay tool-agnostic — use Gemini for anything touching Google data, and switch to Claude or ChatGPT for deep writing or coding.

Next Steps: Lesson 6: Comparing Tools