Google’s Gemini AI is getting a bigger role across Docs, Sheets, and Slides

How to Use Gemini AI in Google Docs, Sheets, Slides, and Drive

TL;DR

• Open any Google Doc and use the new bottom Gemini chat window to describe a document and get a fully formatted draft using your files, Gmail, Chat, and the web.
• In Sheets, ask Gemini to generate entire spreadsheets or populate columns with real data from the web or your existing files.
• In Drive, use natural-language search and “Ask Gemini” to get AI Overviews and answers with citations from your Workspace data.

Google is rolling out deeper Gemini integration across Workspace. Here’s exactly how to start using the new capabilities today.

Prerequisites

• A Google AI Pro, AI Ultra, or eligible Google Workspace plan with Gemini enabled (Gemini Alpha for some Workspace customers)
• Documents, Sheets, or Drive files in English (current rollout language)
• Access to Google Docs, Sheets, Slides, or Drive on the web (desktop browser recommended)
• Workspace administrator must have enabled Gemini features if you’re on a business account

Step 1: Access the Gemini Chat Window in Google Docs

1. Open docs.google.com and create or open any document.
2. Look at the bottom of the screen for the new Gemini chat window (it appears as a persistent panel).
3. Click into the prompt box and describe the document you want. Example prompts:
   • “Write a 2-page customer brief for our new project management tool targeted at marketing teams”
   • “Create a Q1 marketing report using data from my Drive folder ‘2025 Reports’ and match the style of last quarter’s report”

Gemini will generate a fully formatted document using information from the web, your Drive files, Gmail, and Chat.

Pro tip: To match an existing document’s format, add “match the format and style of [document name]” in your prompt. This saves significant time on headings, bullet styles, and layout.

Step 2: Use Gemini for Collaborative Editing and Style Matching

1. Open a shared document.
2. Highlight text written by a colleague.
3. In the Gemini chat or floating menu, select “Match writing style.”
4. Gemini analyzes the overall tone of the document and rewrites the highlighted section to match.

You can also give broader instructions such as:

• “Make the entire document more concise while keeping a professional tone”
• “Rewrite all headings to be benefit-focused”

Changes appear as inline suggestions (similar to track changes) that remain private until you accept or reject them. This is especially useful in team documents.

Step 3: Generate and Populate Entire Spreadsheets in Google Sheets

1. Go to sheets.google.com and create a new blank spreadsheet.
2. Open the Gemini side panel (look for the Gemini icon or use the Help menu > Gemini).
3. Describe the spreadsheet you need:
   • “Create a full spreadsheet tracking 20 SaaS companies with columns for Company Name, HQ Location, 2024 Revenue, Market Cap, and Growth Rate. Pull real data where possible.”
   • “Build a weekly employee schedule optimizer that maximizes profit while respecting staff availability and required skills.”

Gemini can now generate complete spreadsheets (not just tables) and fill columns using data from the web or your existing files. You can also reference another spreadsheet in your Drive:
“Fill these columns using data from my ‘Competitor Analysis 2025’ sheet.”

Step 4: Generate and Edit Slides with Gemini

1. Open or create a presentation in slides.google.com.
2. Open the Gemini side panel.
3. Prompt Gemini to create a new slide:
   • “Add a slide about our pricing tiers that matches the design of slide 3.”
   • “Create a slide summarizing last month’s campaign results with a chart.”

Gemini inserts copy and automatically formats the slide to match your deck’s theme, fonts, and layout. You can then ask it to edit specific slides: “Make the text larger and move the image to the right side.”

Note: Full presentation generation from a single prompt is coming “soon” — the current version works best slide-by-slide.

Step 5: Search and Ask Questions Across Your Workspace in Drive

1. Go to drive.google.com.
2. Use the search bar with natural language:
   • “What were our Q4 sales numbers by region?”
   • “Find all project briefs related to the Acme Corp deal”

You will now see an AI Overview that summarizes relevant files with citations.

3. Click the new “Ask Gemini in Drive” button in the side panel.
4. Ask questions like:
   • “Summarize the key points from all files in the ‘Client Onboarding’ folder”
   • “What does my email from last week say about the deadline for the marketing campaign?”

You can control which sources are included and narrow the search to specific folders.

Tips and Best Practices

• Be specific in prompts. Include names of existing files or folders to improve accuracy and relevance.
• Iterate quickly. Treat Gemini like a junior colleague — generate a first draft, then refine with follow-up prompts such as “Make it shorter” or “Add a section about risks.”
• Review citations. Always check AI-generated data and claims, especially when pulling numbers from the web or your files.
• Use style matching early when working with teams to maintain consistent voice across documents.
• Keep prompts under 500 characters for fastest responses.
• Start new documents in a blank Doc/Sheet first — Gemini performs best when it has a clean canvas.

Common Issues

Why isn’t the Gemini chat window appearing at the bottom of Docs?
Make sure you’re signed in with an eligible Google AI Pro/Ultra or Workspace account that has Gemini enabled. Try refreshing the page or checking your Workspace admin settings.

Why is Gemini not pulling data from my Drive files?
Ensure the files are in your Drive (not shared externally with restricted access) and that you’ve granted Gemini permission to access Workspace data. Try including the exact folder or file name in your prompt.

The generated spreadsheet data looks inaccurate.
Gemini combines web data with your files. Always verify numerical data. For higher accuracy, upload source spreadsheets first and reference them explicitly in your prompt.

Gemini suggestions are too wordy or don’t match our brand voice.
Use style-matching prompts or provide an example document: “Rewrite this section to match the tone of our brand guidelines doc in Drive.”

Next Steps

After mastering these core features, experiment with combining tools: generate a report in Docs, pull live data into a linked Sheet, then create a presentation from both. Watch for the upcoming full-presentation generation feature. Explore creating custom “Gems” (custom AI assistants) once they become available in your Workspace plan.

These updates put Gemini directly inside the tools you already use daily, reducing the need to switch between apps.

Sources

• The Verge — Google’s Gemini AI is getting a bigger role across Docs, Sheets, and Slides
• Google Workspace Blog — The future of AI-powered work for every business
• Google Workspace Blog — Announcing the latest AI capabilities in Google Workspace with Gemini
• Google Support — Gemini AI features now included in Google Workspace subscriptions