Unlock Google Workspace AI: Boost Productivity with Gemini

Google Workspace is evolving, and its latest AI features, powered by Gemini, promise to revolutionize how you create, edit, and manage documents, spreadsheets, and presentations. No longer just a distant concept, genuinely useful AI integrations are here to streamline your workflow, reduce repetitive tasks, and help you work smarter across Docs, Sheets, Slides, and Drive.

This guide will walk you through the practical applications of Gemini's new capabilities, helping you leverage AI to generate content, import information seamlessly, and refine your work in Google Workspace. Get ready to transform your daily tasks and enhance your productivity.

What You'll Accomplish

By following this guide, you will learn to:

• Generate entire documents and spreadsheets from simple prompts.
• Craft text that matches a specific writing style, even your own.
• Pull in relevant information from your Google Drive, Gmail, Google Chat, and the web directly into your documents.
• Refine existing text with AI assistance.
• Organize and analyze data in Google Sheets with natural language commands.
• Understand how Gemini can help you create and tweak presentations.
• Utilize AI Overviews for your Google Drive content.

Prerequisites and Requirements

Before you dive in, ensure you meet the following requirements:

• Subscription: You must be a Google AI Pro or Google AI Ultra subscriber.
• Language Setting: Your default language in Google Workspace needs to be set to English.
• Availability: Note that some features, like the Google Drive interface upgrades, are currently only available in the U.S.

Getting Started with Gemini in Google Docs

Gemini's new features are most noticeable in Google Docs, offering powerful tools for creation and refinement.

Step 1: Accessing the Gemini Bar

When you open a new Google Doc, you'll immediately see a new Gemini bar at the bottom of the screen. This is your primary interaction point for the AI features. If it's not visible, you can bring it up at any time by clicking the Gemini star icon located at the bottom of your document.

Step 2: Generating New Text

Type any prompt directly into the Gemini bar. Whether you need a creative piece like a short story or a practical draft such as a stern email, Gemini can assist. For example, simply ask it to "write a short story about fish" or "draft an email about on-street parking to the neighbors."

Step 3: Importing Data from Your Workspace

This is where Gemini truly shines for productivity. Click the + (plus) button in the lower-left corner of the Gemini bar. Here, you can choose to import data from:

• Google Drive: Reference past documents or files.
• Google Chat: Pull information from conversations.
• Gmail: Access details from your email correspondence.
• The web: Integrate publicly available information.

Practical Application Example: To draft an email to your boss, you can instruct Gemini to pull details from your previous correspondence with them. Similarly, you could plan a travel itinerary by having Gemini refer to recommendations shared in Google Chat. The AI can also flawlessly generate tables of information, such as a list of Oscar winners, by searching the web.

Step 4: Refining Existing Text

Beyond generating new content, Gemini can also help you improve what you've already written. Simply highlight a section of your document, then use a prompt to describe the desired changes. For instance, you could highlight an introduction and ask Gemini to make it "more upbeat and jokey."

Step 5: Matching Writing Style

To ensure consistency, Gemini can adapt its generated text to match a specific style. In a blank document, click the sliders icon on the Gemini bar. Select "Match writing style" and choose an existing Google Doc. All subsequent AI-generated text will then attempt to align with the style of your selected document. While the output might still feel somewhat artificial, it can significantly differ from generic AI text.

Supercharging Google Sheets with Gemini

The updates in Google Sheets provide a much more prominent Gemini prompt box and similar data import capabilities to Docs.

Step 1: Generating Entire Spreadsheets

Input a prompt to create a complete spreadsheet from scratch. For example, you could ask Gemini to "create a spreadsheet showing how often each player on our five-a-side team has shown up." The AI can produce neatly formatted, accurate results, saving you significant time.

Step 2: Importing Data and Filling Information

Like in Docs, you can import data from your other files, chats, and emails into Sheets. Gemini can also perform web or Google Drive searches to populate data. Imagine creating a column for "Oscar Best Picture Winner" and another for "Year"; Gemini can then automatically fill in the corresponding information across rows.

Step 3: Editing with Prompts

You no longer need to manually edit cells. After generating a spreadsheet, you can apply further edits using natural language prompts. Gemini will sometimes ask for approval on specific actions, but generally, the process is smooth and straightforward.

Practical Application Example: Google suggests using Gemini to build a spreadsheet for organizing a house move, pulling in relevant emails and documents as needed.

Enhancing Google Slides with Gemini

While the ability to generate entire slide decks is "coming soon," Gemini in Slides still offers useful features.

Step 1: Importing Data and Matching Styles

Similar to Docs and Sheets, you can pull in data from other sources and the web directly into your presentations. You can also match the style of your current slideshow to an existing deck, ensuring a consistent look and feel.

Step 2: Tweaking Presentation Aspects

Use prompts to modify various elements of your presentation, from text adjustments to layout changes. Be aware that the results might be a bit "hit or miss" with occasional odd formatting or text choices, so review carefully.

Navigating Google Drive with Gemini (U.S. Only)

The Gemini upgrades for the Google Drive interface are currently exclusive to the U.S. Think of these as AI Overviews specifically for your cloud storage.

Step 1: Asking Natural Language Questions

You can ask Gemini natural language questions about the content stored in your Google Drive. For instance, you could ask, "how many times have I written about Gemini in 2026?" or select a group of tax documents and ask, "what questions should I ask my tax advisor about these documents?" This helps you quickly find and understand information across your files.

Best Practices and Tips

• Prioritize Data Import: While text generation is impressive, the ability to pull in information from your existing Google Workspace apps (Drive, Gmail, Chat) and the web is arguably the most genuinely useful feature for saving time.
• Refine Incrementally: Don't expect perfection on the first prompt. Use Gemini to generate a draft, then use further prompts to refine and customize it to your exact needs.
• Review AI Output: Always review the AI-generated content for accuracy, tone, and formatting, especially if it's for critical communications or data analysis.
• Experiment: Try different prompts and explore how Gemini responds. The more you experiment, the better you'll become at leveraging its capabilities.

Troubleshooting Tips

• Unexpected Text Style: If Gemini's style matching isn't perfect, try providing a clearer example document or manually adjusting the generated text.
• Slides Formatting: If you encounter odd formatting in Slides, treat the AI output as a starting point and manually tweak it to your preference.
• AI Asking for Approval: Don't be surprised if Gemini occasionally prompts you to approve an action, especially when making significant changes in Sheets. This is a built-in safeguard.
• Feature Not Showing: Double-check your Google AI Pro/Ultra subscription status and ensure your language is set to English.

FAQ

Q: What Google subscriptions are required to use these new Gemini features? A: You need to be a Google AI Pro or Google AI Ultra subscriber to access these enhanced Gemini capabilities in Google Workspace.

Q: Can Gemini generate entire presentations in Google Slides right now? A: No, the ability to generate entire slide decks is currently listed as "coming soon" by Google. However, you can already import data, match styles, and tweak aspects of your existing presentations using prompts.

Q: Is Gemini's enhanced functionality in Google Drive available globally? A: Not yet. The AI Overviews for the Google Drive interface are presently only available in the U.S.

Next Steps

As you become more comfortable with Gemini's features, consider exploring how you can integrate them into complex workflows. Think about repetitive tasks that involve pulling information from multiple sources – Gemini is designed to simplify these. Keep an eye out for future updates, especially for Google Slides, as Google continues to enhance its AI offerings across Workspace.

By embracing these new AI tools, you can significantly reduce the time spent on simple and repetitive tasks, making the creation of files and the integration of information across your Google apps much more straightforward and efficient.