How to Use Gemini in Google Docs and Sheets (Free Guide)

Google has been quietly rolling Gemini AI into its Workspace apps — and a lot of people haven't noticed yet. If you use Google Docs and Sheets regularly, there's a genuine AI assistant sitting inside your existing tools, ready to help with writing, summarising, and data analysis.

This guide walks you through exactly what Gemini can do in Google Docs and Sheets, what's free, and how to use it to actually save time.

What Is Gemini in Google Workspace?

Gemini is Google's AI model, integrated directly into Google Docs, Sheets, Gmail, Slides, and Drive. Think of it as an AI co-pilot baked into the tools you already use — no browser tab switching required.

What's Free vs Paid

Google's AI feature access depends on your account type:

Free (personal Google account):

• Gemini in Docs and Sheets is available with a Google One AI Premium trial or via Workspace Labs
• Some features have rolled out to free accounts in limited capacity
• The standalone Gemini app (gemini.google.com) is free and works alongside your Workspace files

Google Workspace Individual / Business plans:

• Gemini features are included in paid tiers (Business Standard and above)

The practical workaround for free users: Use the Gemini app to process content from your Docs and Sheets by pasting text, while using built-in features as they expand to free tiers. This guide covers both approaches.

Using Gemini in Google Docs

How to Access It

In Google Docs, look for the "Help me write" button (a pen icon) when you start a new document, or the Gemini icon in the top-right corner of the sidebar. If you don't see it, your account may need Workspace Labs enabled (go to labs.google.com with your Google account).

Use Case 1: Draft Documents from a Brief

Click "Help me write" and type a prompt:

"Write a project brief for a social media campaign launching a new mobile app targeting Gen Z users in the UK. Include sections for objectives, target audience, content themes, timeline, and budget considerations."

Gemini generates a full structured draft inside your document. You edit from there — which is always faster than writing from scratch.

Use Case 2: Summarise Long Documents

For long documents, highlight all text, then use the Gemini sidebar (or "Help me write" > "Summarise"):

"Summarise this document in 5 bullet points. Focus on the key decisions and action items."

This is particularly useful when you've been shared a long report and need to get up to speed quickly.

Use Case 3: Rewrite and Tone Adjustment

Highlight any section and prompt Gemini:

"Rewrite this paragraph to be more concise and formal. The audience is senior stakeholders."

Or conversely: "Rewrite this in a more conversational tone for a blog post."

Gemini rewrites in-place, and you can accept or reject the suggestion.

Use Case 4: Brainstorm Inside Your Document

"I'm writing an article about sustainable packaging for small businesses. Suggest 8 subheadings I could cover, with a one-sentence description of each."

Use this to unstick yourself when you know roughly what you want to write but can't structure it yet.

Using Gemini in Google Sheets

This is where things get genuinely powerful. Gemini in Sheets can help with formulas, data analysis, and generating content inside spreadsheets.

How to Access It

In Google Sheets, look for the Gemini icon in the sidebar or the "Help me organise" button. Alternatively, use the Gemini in Sheets sidebar, which appears when Workspace AI features are enabled.

Use Case 1: Formula Help (No More Stack Overflow)

Describe what you want in plain English:

"Write a formula that looks up a value in column A, finds it in sheet 2 column B, and returns the corresponding value from column C."

Gemini generates the correct VLOOKUP, INDEX/MATCH, or XLOOKUP formula with an explanation. For beginners, this is transformative — you describe what you want and learn the formula in context.

Use Case 2: Data Analysis

Select a range of data and ask:

"Analyse this sales data. What are the top 3 performing products by revenue? What's the month with the lowest sales?"

Gemini reads your actual sheet data and provides a natural language summary. Much faster than building pivot tables for quick questions.

Use Case 3: Generate Structured Data

"Create a content calendar for April 2026. Include columns for: Date, Platform, Content Type, Topic, and Status. Fill in 20 rows with realistic example entries for a B2B software company."

Gemini populates the sheet directly. Great for generating template data, test datasets, or starter content.

Use Case 4: Clean and Transform Data

"I have a column of customer names in mixed case (e.g. 'john SMITH', 'MARY jones'). Write a formula to convert each to proper case."

Gemini gives you =PROPER(A1) with an explanation — but also handles more complex transformations that would normally require research.

Practical Workflow: Weekly Report in 10 Minutes

Here's a real workflow combining Docs and Sheets Gemini features:

1. In Sheets: Paste your week's raw data (sales, traffic, tasks completed). Ask Gemini: "Summarise the key metrics from this data in 4 bullet points."

2. Copy the summary into Google Docs.

3. In Docs: Ask Gemini: "Expand these bullet points into a professional weekly report for my manager. Include an executive summary and a section for next week's priorities."

4. Review and edit. Send.

What used to take 45 minutes now takes 10.

Tips for Getting the Best Results

Be specific about your role and audience. "I'm a marketing manager writing for our CEO" gets very different output than no context at all.

Use the sidebar for iterative work. The Gemini sidebar in Docs stays open while you work, letting you ask follow-up questions without losing your place.

Don't skip the review step. Gemini is good but not perfect. Always read what it produces before using it. Numbers especially need verification.

Combine with your existing Workspace skills. Gemini is a multiplier on things you already know how to do — not a replacement for understanding your tools.

Go Deeper with Our Free Course

Want a structured walkthrough of Gemini's full capabilities across Google Workspace? Our free Google Gemini Mastery course covers everything from basic setup to advanced workflows.

It's free, practical, and designed for people who actually use Google Workspace every day.

Final Thoughts

Gemini in Google Docs and Sheets isn't a gimmick. For anyone who spends significant time in Google Workspace, it's a genuine time-saver — especially for drafting, summarising, and formula work.

The best part: it's already in your tools. You don't need to learn a new platform. Just start asking.