Build an AI Agent to Automate Workflows with Google Workspace Studio

Stephen Cheng

Intro

As a Google Workspace user, we likely spend too much time on repetitive tasks like organizing email attachments, logging files, or summarizing incoming data requests. In December 2025, Google Workspace Studio changed that by allowing us to build intelligent AI agents that handle these chores automatically. It brings agentic AI to Google Workspace, helping us focus on analysis and insights instead of admin work. In this tutorial, we’ll learn how Google Workspace Studio lets us create AI agents to automate workflows in Gmail, Drive, and Sheets.

Google Workspace Studio

Google Workspace Studio is a no-code platform for designing, managing, and sharing AI-powered agents in Google Workspace. These agents, powered by Gemini, automate complex workflows across apps like Gmail, Drive, Sheets, and Chat. Unlike a generic AI chat, an agent built in Workspace Studio is grounded in your specific business data. It can read your policy documents, analyze your spreadsheets, and interact with your emails, all while adhering to your organization’s security protocols. Workspace Studio allows non-developers to build meaningful, reliable automation without juggling APIs, Apps Script, and third-party tools. It brings structure and real usability to AI agents inside everyday workflows.

Building Agents with Natural Language

Previously, building meaningful automation required scripting with Apps Script, setting up external automation tools, or relying on IT teams. Now, teams can create agents in minutes using natural language, templates, or custom steps. Agents work directly in a range of Google tools, including Gmail, Drive, Sheets, Chat, and more, pulling context to perform actions like labeling emails or notifying teams. We just need to describe our automation in plain English, like “Save data file attachments from emails to a Drive Folder and log details in a Sheet,” and Gemini will build the agent for us.

Workspace Studio isn’t limited to the Google ecosystem. It includes built-in connectors for external tools. This means we can create agents that handle complex cross-platform tasks, such as automatically creating a Jira ticket when a client reports a bug via email, or logging a new sales lead directly into Salesforce.

Getting Started with Google Workspace Studio

We’ll build a practical agent that automatically detects emails with data submission in the subject, saves any attachments to a dedicated Google Drive folder, and logs metadata (sender, subject, date, and file name) in a Google Sheet.

Access to Google Workspace Studio is simple with an eligible Google Workspace plan. Here’s what we need to do:

• Confirm our edition supports it (most Business, Enterprise, and Education plans do, but check with your admin).
• Visit studio.workspace.google.com and sign in.
• Explore the Discover page for templates or start creating.

Key concepts before diving in:

• Starter: The trigger that starts the agent (e.g., a new email arriving or a scheduled time).
• Steps: Sequential actions or decisions the agent performs, such as saving files, updating sheets, or using Gemini for reasoning.
• Variables: Dynamic placeholders (like ) that pass data between the starter and steps.

Step 1: Create a new agente

• Go to studio.workspace.google.com and click Create new.
• Use Describe a task for Gemini (or start blank for full manual control; we’ll cover refinements manually anyway).
• In the prompt field, enter:

When a new email arrives with data submission in the subject and attachments, save each attachment to a Google Drive folder called Incoming Data Files, then add a row to a Google Sheet called Data Submission Log with the sender’s email, subject, date received, and attachment file names.

Gemini generates a complete flow in seconds. This gives us a strong starting point without building every piece manually.

Step 2: Configure the starter

Open the generated flow. The first block is the starter: here, New email.

• Click the starter block to edit.
• Under conditions, ensure: The subject contains data submission; Has attachments (check the box).
• Optionally, add more filters (e.g., from specific senders).

Step 3: Refine the action steps

Gemini has added steps for handling attachments and logging. Let’s review and edit them manually.

1) Save attachments step:

• Click the block (Step2: Add email Attachments to Drive).
• Set the destination folder: Search for or create Incoming Data Files in Drive.
• Map the file by clicking on Variables and selecting Email Attachments.

2) Log to Sheets step:

• Click the block (Step3: Add a row)
• Select or create your Data Submission Log Sheet.
• Add columns if needed: Sender, Subject, Date, File Names.
• On adding your spreadsheet, Workspace Studio automatically identifies the columns in your sheets and allows you to map variables to them.
• Map variables: Sender, Subject, Date, File Names. (Variables dynamically insert real data from the email/attachment, making the agent adaptable to every incoming message.)

3) Optional enhancement: Add a Gemini step after saving files.

• Insert a new step by clicking + Add Step.
• Under AI skills, select the Summarise option.

• For What to summarize, choose Content from the previous steps and then specify the links to the Files from Step 2.
• Set the Prompt to: Summarize the key insights from the data file.
• Then add another step that appends the summary to the Sheet row.

Step 4: Test the Agent

• Click Test run in the editor.
• Send yourself a test email matching the criteria (subject: “data submission test”, attach a sample CSV).
• Watch the test run in real-time.

• Verify: Files appear in Drive, row added to Sheet.

Debug any issues directly in the flow editor, logs show exactly where problems occur.

Step 5: Activate and monitor

Once satisfied, click Turn on. The agent now runs automatically on new matching emails. We can monitor activity from the Studio dashboard, Flows section, or side panels in Gmail.

Conclusion

Google Workspace Studio makes it possible to move beyond AI-assisted writing into AI-driven action inside Google Workspace. In this article, we explored what Google Workspace Studio is, and how to build a practical agent that automates real workflows across Gmail, Drive, and Sheets. If an agent behaves unexpectedly, refine the goal or narrow its scope rather than adding complexity.

Some advices and troubleshooting hints below:

• Start simple: Use templates and test thoroughly, actions like sending emails or editing files happen for real during tests.
• Leverage variables: They make agents dynamic and reusable.
• Add AI steps: For smarter automation, include Gemini steps to summarize attachments or extract insights.
• Troubleshooting: If features are missing, check admin controls or Gemini enablement. For errors, review logs in the editor. Age restrictions apply for AI features on education accounts.

AI, AI Agent, Gemini, Google — May 16, 2026