Peter Yang• Mar 18, 2026• 18:35Interview

Master Gemini in Google Docs, Sheets & Slides in 18 Min (5 Real Use Cases)

From Peter Yang

Executive Summary

The recently updated Gemini integration in Google Workspace is a significant improvement over its previous version, offering powerful new capabilities but suffering from an inconsistent user experience across different applications.
Gemini in Sheets is a standout feature, with the '=AI()' formula enabling users to pull live, sourced web data into cells, a function described as "magical" for research and data compilation.
Key weaknesses persist, including slow generation times (3-4 minutes for a sheet), clunky workflows for image insertion in Docs and Slides, and a lack of feature parity with competitors, especially in full presentation generation.
Google's core advantage lies in its ability to leverage vast personal context from user data across Drive, Docs, and Gmail, but it faces urgent pressure from rapidly advancing competitors like ChatGPT and Claude.

12 quotes

Concerns Raised

Slow generation speeds in Google Sheets, taking several minutes per task.
Clunky user experience for image generation, which places images in a chat window instead of directly in the document or slide.
Inability of Google Slides to generate a full presentation, a feature available in competing products.
Lack of automatic source citation for web data, requiring specific prompting and raising concerns about data trustworthiness.
Initial data generated by AI can be unrealistic or inaccurate, requiring significant manual correction (e.g., Bay Area housing costs).

Opportunities Identified

The '=AI()' formula in Google Sheets is a powerful tool for pulling and manipulating live web data.
Gemini in Google Drive is highly effective for finding and synthesizing information across a large number of files.
Leveraging Google's vast ecosystem of user data provides a unique advantage for creating a deeply personalized AI assistant.
The ability to use personal documents as reference material and style guides allows for highly customized and relevant content generation.

Key Themes

The Inconsistent User Experience of Integrated AI

The quality and polish of the Gemini integration vary significantly across Google's product suite. While Sheets offers a powerful and seamless experience for data retrieval, Slides is rudimentary, and Docs has awkward workflows for inserting generated images. This inconsistency highlights the challenge of uniformly deploying advanced AI across a mature and diverse set of applications.

This matters because a disjointed user experience can create friction and hinder adoption, even if individual features are powerful. It shows that the 'last mile' of integration is critical for the success of AI-powered productivity tools.

The Power and Peril of Contextual AI

The review demonstrates Gemini's unique ability to leverage a user's personal data across Google Drive and Docs for highly contextual tasks, like planning a vacation based on past travel notes. However, it also reveals the need for user control, as the speaker explicitly tells Gemini not to use private financial data. This showcases the dual nature of deep integration: powerful personalization balanced against user privacy and control.

As AI becomes more integrated into personal and professional workflows, the ability to manage data context and privacy will be a key differentiator and a critical factor for user trust.

AI as a Co-pilot for Knowledge Work

The episode provides a practical tutorial on using AI for real-world tasks like creating a family budget, researching summer camps, and drafting a professional presentation. It positions Gemini not as a replacement for human effort but as a co-pilot that can accelerate research, formatting, and content generation. The emphasis on providing style guides and reference materials reinforces the idea of a human-AI partnership.

This theme reflects the shift in how knowledge work is performed, where proficiency with AI tools to augment and speed up tasks is becoming a critical professional skill.

The Competitive Landscape for AI Assistants

The speaker explicitly frames Google's progress within a competitive context, noting that rivals like ChatGPT and Claude are advancing rapidly. Specific feature gaps, such as the inability of Google Slides to generate a full deck while competitors can, are highlighted as significant weaknesses. Google's massive data advantage is presented as a 'golden opportunity' that it must capitalize on quickly to avoid being outmaneuvered.

This underscores the high-stakes nature of the AI race, where even tech giants with significant assets are not guaranteed to win. The pace of innovation from competitors is forcing incumbents to accelerate development and refine their product offerings.

Get started free

Topics

Google Workspace Gemini AI AI Productivity Google Sheets Google Docs Google Slides Google Drive Generative AI AI Assistants Product Review User Experience (UX)AI Integration Data Analysis Content Creation Competitive Landscape

Processed Apr 9, 2026 yt-dlp + mlx-whisper + Gemini