Google brings Gemini-powered content creation tools to Docs, Sheets, Slides and Drive

How to Generate Content with Gemini in Google Docs, Sheets, Slides, and Drive

TL;DR

• Gemini now creates formatted first drafts in Docs, builds entire spreadsheets in Sheets, generates themed slides in Slides, and answers questions about your files in Drive.
• These features are available right now in beta for Google AI Ultra/Pro subscribers and Gemini for Google Workspace business customers (English only).
• Start by opening any supported Workspace app, clicking the Gemini icon, and using natural language prompts that pull context from your Gmail, Drive, Chat, and the web.

Prerequisites

Before you begin, ensure you have:

• A Google AI Ultra or Google AI Pro subscription (consumer) or Gemini Alpha / Gemini for Google Workspace business plan.
• Access to Google Docs, Sheets, Slides, or Drive (web version recommended for full feature availability).
• English language set as your primary Workspace language.
• Relevant source files already stored in Drive, Gmail, or Google Chat so Gemini can reference them.
• Note: Drive AI features are currently rolling out first to US customers only.

Step 1: Access Gemini in Google Docs and Create a First Draft

1. Open docs.google.com and create a new blank document or open an existing one.
2. Click the sparkle icon (Gemini) in the top-right corner or press Ctrl + Alt + . (Windows/ChromeOS) / Cmd + Option + . (Mac).
3. In the Gemini side panel, type a prompt such as:
   "Help me create a Q2 marketing campaign brief using last quarter’s performance data from my Drive folder ‘2025 Campaigns’ and my summary email from last week."
4. Click Create. Gemini will generate a fully formatted draft, pulling context from your Drive files, Gmail, Chat, and the web.
5. To match an existing document’s style:
   • Upload or link a reference document in your prompt, e.g., "Use the same formatting and tone as the file ‘Brand Guidelines v3’."
6. Review the output, then use the Refine button to iterate: "Make this more concise and add bullet points for action items."

Pro tip: Because over one-third of new Docs are created from copies of existing files, using the reference-document feature saves significant manual reformatting time.

Step 2: Build Spreadsheets Automatically in Google Sheets

1. Go to sheets.google.com and open a new or existing spreadsheet.
2. Click the Gemini sparkle icon in the top right.
3. Use a comprehensive prompt like:
   "Build a full employee scheduling spreadsheet for a 12-person marketing team covering March–June. Pull availability from emails in my ‘Team Scheduling’ label and use the project calendar from Drive."
4. Gemini will generate column headers, sample data, formulas, and formatting in one go.
5. For existing tables, highlight a range of cells and select Fill with Gemini from the right-click menu or side panel.
6. Enter a prompt such as: "Fill these cells with projected Q3 revenue based on last year’s growth rate from the ‘Financials 2024’ sheet."

Google reports that “Fill with Gemini” is approximately nine times faster than manual entry (based on an internal 95-person study). Additionally, new optimization tools powered by Google DeepMind and Google Research let you solve complex problems with prompts like:
"Optimize this shift schedule to minimize overtime while ensuring every project has coverage."

Step 3: Generate Slides and Match Your Deck Theme

1. Open slides.google.com.
2. Click the Gemini icon.
3. To generate a single slide:
   "Create a title slide and agenda slide for a product launch presentation using the theme from my ‘2025 Brand Deck’ file."
4. Gemini will insert new slides that automatically match fonts, colors, and layout of your chosen reference deck.
5. For broader use, start with a high-level prompt:
   "Generate an 8-slide investor pitch deck about our new AI writing assistant, pulling key metrics from the ‘Q1 Results’ spreadsheet in Drive."

Note: Full presentation generation from a single prompt is listed as “coming later.” Right now you generate individual slides or small groups that stay on-brand.

Step 4: Query Your Files with Ask Gemini in Google Drive

1. Navigate to drive.google.com.
2. In the search bar, you will now see AI Overviews for relevant results (US users first).
3. Click the Ask Gemini button that appears in the side panel or search interface.
4. Ask questions that span multiple sources:
   "What were the three biggest risks mentioned in last month’s project reports and how do they compare to the notes in my Gmail label ‘Risk Review’?"
5. Gemini will synthesize answers from your Drive files, Gmail, and Calendar, providing direct links to source documents.

This feature makes Drive function as a personal knowledge base, dramatically reducing time spent hunting through folders.

Tips and Best Practices

• Be specific: Include names of folders, email labels, file titles, or dates in prompts for better accuracy.
• Iterate quickly: Use the “Refine” or “Regenerate” options rather than starting from scratch.
• Review for accuracy: Always fact-check AI-generated numbers, dates, and citations against original source files.
• Combine tools: Generate a draft in Docs, pull data into Sheets, then create Slides—all within the same Workspace session.
• Style matching: Upload a short “style guide” document once and reference it repeatedly across Docs and Slides.
• Privacy note: Gemini only uses files you explicitly reference or that are in your Workspace; it does not train on your data for other users.
• Start small: Test with simple prompts before giving complex multi-file requests.

Common Issues

Why am I getting “Feature not available” or “Upgrade required”?
You need an active Google AI Ultra/Pro plan or eligible Gemini for Workspace business subscription. Check your plan at one.google.com.

Why is Gemini ignoring my Drive files?
Make sure the files are in a folder you own or have edit access to, and reference them explicitly in the prompt (e.g., “use data from folder X”). Features are English-only for now.

The generated spreadsheet has incorrect formulas.
Use the “Refine” prompt: “Fix the VLOOKUP formulas and make sure they reference the correct sheet names.” Always verify critical calculations manually.

Slides don’t match my theme perfectly.
Select a recently used deck as the style reference and be explicit: “Use the exact color palette #1A73E8 and font ‘Google Sans’ from my ‘Master Template’.”

Drive Ask Gemini is not showing for me.
This feature is rolling out first to US customers. Check your account region settings or wait for broader availability.

Next Steps

After mastering basic generation:

• Experiment with multi-step workflows (Docs → Sheets → Slides).
• Explore the new DeepMind-powered optimization prompts in Sheets for operations research tasks.
• Integrate Gemini outputs into Google Chat for team review.
• Monitor the Workspace Blog for the upcoming “full presentation from one prompt” feature.
• Consider creating a personal prompt library in a dedicated Doc for repeated tasks.

These Gemini updates represent a significant leap in making Google Workspace feel like a true AI collaborator rather than a set of static tools.

Sources

• Engadget – Google brings Gemini-powered content creation tools to Docs, Sheets, Slides and Drive
• Google Workspace Blog – Gemini update reimagines content creation for business users
• TechCrunch – Google rolls out new Gemini capabilities to Docs, Sheets, Slides, and Drive
• The Verge – Google’s Gemini AI is getting a bigger role across Docs, Sheets, and Slides
• WIRED – I Used Google’s New Gemini-Powered ‘Help Me Create’ Tool in Docs