Blog › AI for sales, tool by tool

How to use Gemini in Gmail, Docs and Sheets

By Corey Leon, founder of Coda · · 5 min read

Use Gemini inside Gmail, Docs and Sheets to draft replies, sum up long threads and write documents. Plain steps and prompts.

Short answer

How do I use Gemini in Gmail, Docs and Sheets at work?

If your company uses Google Workspace, Gemini can work right inside Gmail, Docs and Sheets on some plans. Look for the Gemini icon or "Help me write" in each app.

In Gmail it can sum up a long thread and draft a reply. In Docs it can write a first draft or rewrite what you have. In Sheets it can help you build tables and formulas. If you can't find it, ask your IT person whether your plan includes it.

Steps

  1. Check that you have it. Open Gmail on your work account and look for a Gemini or spark style icon near the top right, or a "Help me write" option when you start an email. If it is not there, your plan or your admin may not have it turned on. You can still use the Gemini app at gemini.google.com and paste things in.
  2. Sum up a long email thread. Open the thread and open the Gemini side panel. Ask "Summarize this thread and tell me what they are waiting on from me." Read the summary, then skim the thread to make sure nothing important got dropped.
  3. Draft a reply in Gmail. Start a reply, use "Help me write" and type what you want in plain words. Like this: tell him pricing is attached, we can deliver in two weeks, ask if Thursday works for a call. Then use the options to make it shorter or more formal if you need to. Edit before you hit send.
  4. Write a first draft in Docs. Open a blank Doc and use "Help me write". Ask for something specific, like a one page process for handling returns. You get a draft to fix instead of a blank page.
  5. Rewrite in Docs. Select a paragraph and ask Gemini to make it shorter, clearer or friendlier. Great for cleaning up a proposal or a policy someone wrote five years ago.
  6. Use Gemini in Sheets. Open the Gemini side panel in a sheet and ask in plain words. Ask it to make a table to track open quotes with columns for customer, amount, date sent and status. Or ask for a formula that adds up column D when column E says Won. Always test a formula on a few rows you can check by hand.
  7. Check facts before you share. Gemini can misread a thread or mix up numbers. You own anything you send.

Prompts you can copy

Gmail: what do they need from me

Prompt. Paste it into Claude or any AI chat.
Summarize this email thread in 5 bullets. Then tell me:
1. What the other person is waiting on from me.
2. Any dates or deadlines mentioned.
3. A short reply that answers their open questions, under 80 words, friendly and plain.

Docs: turn notes into a simple process

Prompt. Paste it into Claude or any AI chat.
Turn these notes into a one page process document for [task, like handling a customer return].
Notes: [paste notes].
Format: a title, who this is for, then numbered steps of one or two sentences each. Use plain words a new hire can follow. End with a short "Who to ask" line.

Sheets: build a tracker

Prompt. Paste it into Claude or any AI chat.
Create a table to track [what you track, like open quotes].
Columns: [list columns, like Customer, Contact, Quote amount, Date sent, Follow up date, Status].
Add 3 example rows with made-up data so I can see how it works. Status should be one of: Sent, Talking, Won, Lost.

Docs: make it shorter

Prompt. Paste it into Claude or any AI chat.
Rewrite this so it is half as long and easy to read on a phone. Keep every number and date exactly the same. Use short sentences.
[paste text]

What does a made-up example look like?

This is a made-up example. A 14 email thread about a late shipment of fittings. You ask Gemini for what the customer needs from you. A good answer: They want a new ship date in writing. They want a credit for the expedite fee they paid on the 12th. And they want to know the next order will not be split. A reply could say: Hi Tom, new ship date is Friday the 24th. I've asked accounting to credit the expedite fee and will send the credit memo when it's done. The next order will ship complete. Want me to call you Friday morning to confirm it's on the truck?

Before sending, check the ship date and the credit in your own system. Gemini only knows what is in the thread.

What tips help?

  • In Gmail, short instructions work. "Say yes, ask for their PO number" is enough.
  • In Docs, ask for an outline first, then fill each part. You stay in control of the order.
  • In Sheets, describe your columns by their real names so formulas point to the right place.

What should you not do?

  • Don't assume every coworker has Gemini. Plans differ, so a teammate may not see the same buttons.
  • Don't paste a formula into a big sheet without testing it on a few rows first.
  • Don't send a summary to your boss without reading the thread yourself.

FAQ

Is Gemini free in Gmail?

The Gemini app has a free version for personal accounts. Gemini inside work Gmail, Docs and Sheets depends on your Google Workspace plan, so ask your admin what you have.

Can Gemini read all my email?

In Gmail it works with what you ask about, like the thread you have open. Your company's admin controls what is turned on, so check with them if you have privacy questions.

Does Gemini work on my phone?

There is a Gemini app for phones, and some Gemini features show up in the Gmail app on some plans. The side panel features are easiest on a computer.

What if my company uses Outlook?

Then look at Microsoft Copilot instead. Our guide on Copilot in Outlook and Excel walks through it.

geminigmailgoogle docsgoogle sheets

First posted . Last updated .

Read next

Want us to run this for you?

Book a call. We'll look at who you sell to and your offer, and tell you straight where to start.

Book a discovery call