Skip to Content
View all events

Gemini for Google Workspace Fundamentals

Published by O'Reilly Media, Inc.

Beginner content levelBeginner

Enhancing productivity with GenAI

What you’ll learn and how you can apply it

  • Structure your requests to get the most accurate and useful results from Gemini
  • Use Gemini for different phases of document creation in Google Docs, from initial brainstorming to final proofreading
  • Transform messy data into clear insights and visualizations
  • Convert ideas and data from docs and sheets into compelling presentations in Google Slides
  • Use Gemini to summarize, search, and draft correspondence in Gmail
  • Deploy AI-powered automation to accomplish rote tasks in your workflow

Course description

With Gemini, generative AI has been fully integrated into the Google Workspace tools you use every day—it can automate workflows in Gmail, surfaces insights in Sheets, and create dynamic content in Docs and Slides. Gemini is an essential tool for boosting productivity and unlocking new creative potential, but getting the most out of it means moving beyond simple requests to true collaboration.

Through presentations and hands-on exercises, Google Developer Expert Aryan Irani gives you a comprehensive foundation in Gemini for Google Workspace, squarely focused on real-world applications that you can immediately apply on the job. You’ll start by mastering the core skill of effective prompt-writing before diving deep into the applications. You'll learn how to use Gemini for document creation in Google Docs and how to transform messy data into clear insights and visualizations in Google Sheets. You’ll also discover how to convert ideas and data into compelling presentations in Google Slides, how to improve communication efficiency in Gmail by using AI to summarize, search, and draft correspondence, and how to deploy AI-powered automation to handle certain tasks in your workflow.

This live event is for you because...

  • You’re an enterprise user, knowledge worker, or administrative professional who relies on Google Workspace for daily tasks.
  • You’re a business analyst who wants to leverage natural language to quickly clean, analyze, and visualize data in Google Sheets without writing complex formulas.
  • You want to stop spending hours on tedious manual work and learn how to use AI as a productive partner in your daily tasks.
  • You’re curious about generative AI but need a structured, practical guide to apply it effectively and responsibly within the Google Workspace ecosystem.

Prerequisites

  • A Google account with Gemini features active in Docs, Sheets, and Slides
  • For personal Google accounts (@gmail.com), the Google One AI Premium subscription is required
  • For business accounts, confirmation from your IT department that a Gemini for Google Workspace license is assigned to your account
  • A computer with the Google Chrome browser and a stable internet connection
  • Familiarity with the basic operations of Google Docs, Sheets, and Slides

Recommended follow-up:

Schedule

The time frames are only estimates and may vary according to how the class is progressing.

The foundation (25 minutes)

  • Presentation: Introduction to Gemini and why it matters for productivity
  • Hands-on exercise: Apply the “CRISP” method (context, role, instruction, specifics, persona) to turn a vague request into a powerful, specific prompt
  • Q&A

Mastering text with Google docs (45 minutes)

  • Presentation and demo: Brainstorming project ideas; drafting content from an outline; summarizing long documents; changing the tone of your writing
  • Hands-on exercise: Review a poorly written document and proofread it for errors, rephrase it in a professional tone, and generate a three-bullet summary using Gemini
  • Q&A
  • Break

Mastering data with Google sheets (55 minutes)

  • Presentation and demo: Using plain English to organize data, generate complex formulas, build summary tables, and create charts without using the menu
  • Hands-on exercise: Take a messy, unformatted spreadsheet and use Gemini to clean the data, create a summary table by category, and visualize the results with a chart
  • Q&A
  • Break

Mastering visuals with Google slides (50 minutes)

  • Presentation and demo: Generating a full presentation from a document and creating unique, AI-generated images from simple text descriptions
  • Hands-on exercise: Build a three-slide “About Me” or “Project Idea” presentation using Gemini to generate the text and custom images for each slide
  • Q&A
  • Break

Mastering communication with Gmail (30 minutes)

  • Presentation and demo: Efficiently managing your inbox by summarizing long email threads and finding key information using conversational search
  • Hands-on exercise: Use Gemini to draft a professional outreach email for a specific scenario (e.g., a project kickoff message to your team or a networking request)
  • Q&A

AI-powered automation (35 minutes)

  • Demonstration: Using Gemini to write a simple Google Apps Script to show the potential of true automation
  • Presentation: Recap of integrated best practices and how to build a productive AI-powered workflow across all the apps
  • Q&A

Your Instructor

  • Aryan Irani

    Aryan Irani is an independent contractor, technical trainer and writer. Google Developer Expert @GoogleWorkspace.

    linkedinXlinksearch

Skill covered

Gemini