Gemini can now use your Drive and emails to build spreadsheets, slides and more

How to Create Spreadsheets, Docs, and Presentations Using Your Gmail and Drive with Gemini

TL;DR

• Prompt Gemini in Google Sheets, Docs, or Slides to generate entire files by referencing your personal Gmail, Drive, and other documents.
• Explicitly tell Gemini which sources to use; it will cite what it pulled from your emails or files.
• Available now to Google AI Ultra, AI Pro, and Workspace subscribers—start with a clear prompt like “Create a moving checklist using my recent emails.”

Prerequisites

• A Google account with Google AI Ultra or Google AI Pro subscription (or a qualifying Google Workspace plan).
• Access to Google Drive, Gmail, Docs, Sheets, and Slides.
• Basic familiarity with the Gemini side panel in Workspace apps.
• Clear idea of the project you want to build (Gemini performs best with specific prompts).

Step 1: Access Gemini in Google Workspace Apps

1. Open docs.google.com, sheets.google.com, or slides.google.com.
2. Create a new blank file or open an existing one.
3. Click the Gemini icon (sparkle/star) in the top-right corner or side panel.
4. If prompted, sign in with the account that has the AI Pro/Ultra plan.

Note: The new “create from scratch” capabilities are rolling out gradually. If you don’t see the full options yet, check back in the next few days.

Step 2: Build an Entire Spreadsheet in Sheets Using Your Emails and Drive

Sheets now lets you generate complete, formatted spreadsheets from a single prompt.

Example prompt:

Help me organize my upcoming move. Create a checklist for packing each room, a contact list for utilities in my new city, and a spreadsheet to track moving company quotes from my email inbox.

How to do it:

1. Open a new Google Sheet.
2. Open the Gemini side panel.
3. Paste or type your prompt.
4. Gemini will scan your recent Gmail messages and relevant Drive files (only if you mention them).
5. Review the generated spreadsheet. You will see small citations showing which email or file was used.
6. Use “Fill with Gemini” on any empty column: highlight the column, open Gemini, and ask it to “categorize this data” or “add due dates and tuition from public college websites.”

Practical use cases right now:

• College application tracker (pulls deadlines from emails)
• Budget tracker using receipts in Drive
• Project expense log referencing vendor emails

Step 3: Draft Personalized Documents in Docs

Gemini can now create full drafts using context from your emails and previous files.

Example prompt:

Put together a neighborhood newsletter based on the last HOA meeting notes in my email.

Instructions:

1. Open a new Google Doc.
2. Open Gemini.
3. Enter your prompt, explicitly naming the source (e.g., “use the HOA meeting notes from last week’s email”).
4. After generation, click any citation to jump to the original email or file.
5. Use the new “Match writing style” feature:
   • Highlight existing text.
   • Ask Gemini: “Rewrite this section to match the professional tone of my Q1 report.”

This is especially useful for recurring documents such as monthly reports, meeting summaries, or client proposals.

Step 4: Create or Edit Slides Presentations

The ability to generate an entire presentation from scratch is labeled “coming soon,” but you can already create new slides and redesign existing ones using your personal data.

Current capabilities:

1. Open Google Slides.
2. Open Gemini.
3. Ask for a new slide:

   Create a new slide about Q3 marketing results using data from my Drive folder "2026 Reports" and the summary email from last Friday.
   

4. Use editing prompts such as:
   • “Make this slide match the colors of every other slide”
   • “Make this slide less flashy and more corporate”
   • “Add relevant diagrams from my brand assets in Drive”

Step 5: Get Instant Answers from Your Drive Files

Drive now functions as an active knowledge base.

1. Go to drive.google.com.
2. Look for the AI Overview box at the top of your Drive.
3. Ask complex questions such as:

   What specific things should my tax advisor know before I file this year’s tax returns?
   

4. Gemini will pull information from multiple files and emails and provide a summarized answer with citations.

Tips and Best Practices

• Be specific about sources. Instead of “use my files,” say “use the email from Sarah on March 5 and the budget spreadsheet in my 2026 Projects folder.”
• Review citations. Always click the small reference numbers to verify accuracy.
• Iterate. Treat the first output as a starting point. Follow up with “Add a dashboard chart” or “Make the tone friendlier.”
• Privacy. Gemini only accesses content when you explicitly request it in the prompt.
• Combine tools. Create a spreadsheet in Sheets, then ask Gemini in Docs to “write a summary report using the data from my new moving spreadsheet.”
• Use “Match writing style” to keep all company or personal documents consistent.

Common Issues

### Why am I getting “I can’t access that file” or no results?
You must explicitly mention the source in your prompt. Gemini will not search your entire Drive or inbox unless instructed.

### The generated spreadsheet is missing key data.
Follow up in the same chat: “Add the quotes from the three moving company emails I received last week.” Gemini maintains context within the session.

### Citations are not clickable.
This can happen during rollout. Refresh the page or wait a few minutes. Citations improve with each update.

### Feature not visible yet.
These capabilities are rolling out first to AI Ultra and Pro users. Confirm your subscription at one.google.com and try again later.

### Output is too generic.
Add more context: names, dates, folder names, or email subjects. The more precise the prompt, the better the result.

Next Steps

• Experiment with chaining features: generate a spreadsheet → summarize it in Docs → turn the summary into Slides.
• Explore “Fill with Gemini” for data enrichment from Google Search.
• Try the new AI Overview in Drive for research-heavy tasks like tax prep or project audits.
• Once full presentation generation lands, test creating an entire pitch deck from your Drive assets in one prompt.

These updates turn Gemini from a simple writing assistant into a true personal knowledge worker that understands your existing content.

Sources

• ZDNet - Gemini can now use your Drive and emails to build spreadsheets, slides and more
• Google Blog - New ways to create faster with Gemini in Docs, Sheets, Slides and Drive
• 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
• 9to5Google - Google Drive adding AI Overviews as Gemini upgraded in Slides, Sheets