Google Workspace Automation in 2026: 5 Ways, Free to Paid

You can automate Google Workspace five ways: built-in rules (Gmail filters, Forms notifications), recorded macros in Google Sheets, Google Workspace Studio flows on eligible Workspace plans, Google Apps Script for free custom code, and connectors like Zapier or Make when the work leaves Google. Start with the simplest one that covers the job.

The trouble with "automate my Google apps" is that it sounds like one project and turns out to be a dozen small chores: sorting mail, copying form answers into a sheet, filing attachments, sending the same reminder every Monday. Each chore has a right-sized tool. This guide walks through all five, with steps, real limits and prices, a short script you can paste, and the usual reasons an automation goes quiet.

The five ways to automate Google Workspace, compared

The right tool depends on two things: whether the work stays inside Google, and whether you want to write any code. Here is how the options line up.

Sources for the costs and editions are linked in each section below. If you only read one line: a filter or a linked sheet solves more than people expect, and code is the last resort, not the first.

Start with the automation already built into Gmail and Forms

Gmail filters and Google Forms response settings automate the most common chores with no setup beyond a few clicks. A Gmail filter can apply a label, archive, delete, star or forward incoming mail, according to Google's filter help page.

How to create a Gmail filter

1. In Gmail in a desktop browser, open the search options icon inside the search bar.
2. Enter the criteria, such as a sender's domain in From or a phrase in Subject.
3. Click Create filter.
4. Tick the actions you want, such as applying a label and archiving.
5. Click Create filter again to save it.

One detail worth knowing: a forwarding filter only applies to new messages, not mail already in your inbox. When a supplier started sending invoices from more than one address, I stopped matching individual addresses and filtered on the domain instead, with a label and archive. The invoices now wait under one label, and nothing slips past because someone new in their accounts team hit Send.

For more Gmail-only ideas, such as templates and auto-replies, see six Gmail automation ideas.

How to automate Google Forms responses

Google Forms can email you on every new response and write every answer into a Google Sheet, both from the Responses tab, per Google's Forms help page.

1. Open the form and click the Responses tab.
2. Click the More icon (three dots) and choose Get email notifications for new responses.
3. To log answers in a spreadsheet, click Link to Sheets on the same tab.

The linked sheet matters more than it looks. Once answers land in Google Sheets, every other tool in this guide (Workspace Studio, Apps Script, Zapier) can pick them up from there. Note that anyone you share the form with may also get access to the linked spreadsheet.

How to record a macro in Google Sheets

A Google Sheets macro records a set of clicks and edits once and replays them on demand, which suits a weekly cleanup you do the same way every time. Google's macro help page gives these steps:

1. Open the spreadsheet and click Extensions > Macros > Record macro.
2. At the bottom, choose absolute or relative references.
3. Do the task: format the header row, sort, delete empty columns, whatever the routine is.
4. Click Save, name the macro, add an optional keyboard shortcut and click Save again.

Absolute references replay on the exact cells you recorded. Relative references replay from whichever cell you select, so a macro recorded on A1 and B1 can later run on C1 and D1. Behind the scenes every macro is saved as an Apps Script function, which is a gentle way into the next two sections: you can open the script and see exactly what you recorded.

Macros only run when you trigger them. If you need the cleanup to happen at 7 a.m. without you, that is a job for Apps Script or Workspace Studio.

How to automate Google Workspace with Workspace Studio

Google Workspace Studio is Google's no-code builder for flows: a starter (an event or a schedule) followed by steps that act in Gmail, Drive, Sheets, Docs, Chat, Calendar and Tasks, plus Gemini AI steps that summarize, extract or decide. You build flows in a browser on a computer, and once on, they run without you.

Who can use Workspace Studio

Workspace Studio needs an eligible edition: Business Starter, Standard or Plus; Enterprise Standard or Plus; Education Fundamentals, Standard or Plus; or the Teaching and Learning add-on or Google AI Pro for Education, according to Google's access page. Your admin also has to turn on Gemini. Personal Gmail accounts need to join Google Workspace Experiments. Templates only appear for apps you have, so a Gmail template won't show if Gmail is off for you.

What a flow can start from and do

Starters include On a schedule, When I get an email, When a sheet changes, When an item is added to a folder, When a file is edited, When a form response comes in and Based on a meeting, per Google's guide to starters and steps. Steps include Add email attachments to Drive, Move files or folders, Add a row in Sheets, Create a doc, Draft an email, Send an email, Post in a space, Block time and Create a task, plus Gemini steps such as Summarize, Extract and Decide, and logic steps like Check if and Repeat for each.

There are also beta integrations for Asana, Confluence, Jira, Mailchimp and Slack on work and school accounts. One limit to plan around: the When I get an email starter only offers Gmail's default labels, not your custom ones.

How to build a Workspace Studio flow

1. Go to studio.workspace.google.com on a computer.
2. Describe the flow to Gemini, pick a template from Discover, or start a new flow from scratch.
3. Click Choose a Starter and pick the event or schedule.
4. Add one or more steps below it.
5. Click Test run, then Start, and wait for Run Completed.
6. Click Turn on.

Before I turn on any flow that emails other people, the Send an email step goes to my own address for the first test run. I read what arrived as if I were the recipient, fix the wording, and only then swap in the real list. Gemini drafts are usually close, and close is not the same as ready to send to a client.

For flows built around Gemini itself, our guide to Gemini automation options goes deeper on Studio versus Zapier.

How to automate Gmail, Sheets and Drive with Apps Script

Google Apps Script is free JavaScript that runs on Google's servers and can read and change Gmail, Sheets, Docs, Drive, Forms and Calendar. Use it when the job is custom, when you don't have a Studio-eligible plan, or when you want a schedule down to the minute.

Open the script editor

In Google Docs, Sheets or Slides, click Extensions > Apps Script. In Google Forms, click the More icon (three dots) and choose Apps Script, per Google's guide to bound scripts. A script opened this way belongs to that file.

A starter script: archive old newsletters

This script archives anything under a Gmail label called Newsletters that is more than 30 days old. It uses the documented GmailApp methods search and moveThreadsToArchive, and handles up to 100 threads per run to stay well inside the time limit. Change the label name and the age to suit you.

function archiveOldNewsletters() {
  // Up to 100 threads per run; a daily trigger catches the rest.
  var threads = GmailApp.search('label:newsletters older_than:30d in:inbox', 0, 100);
  if (threads.length > 0) {
    GmailApp.moveThreadsToArchive(threads);
  }
}

Click Run once. Google asks you to authorize access to your Gmail; read the scopes before you allow them, since the script acts as you.

Run it on a schedule with a trigger

An installable trigger makes the script run without you. Google's trigger guide lists the steps:

1. In the Apps Script editor, click Triggers (the alarm clock icon) in the left sidebar.
2. Click Add Trigger at the bottom right.
3. Choose the function, then Time-driven as the event source, and a daily timer.
4. Click Save.

Besides time-driven triggers, Apps Script can run on a sheet edit, a structural change to a sheet, a form submission, a file being opened, or a Google Calendar event being created, edited or deleted. Time-driven triggers can fire as often as every minute or as rarely as once a month, though Google may start a daily trigger anywhere within the hour you pick.

Apps Script limits that matter

These come from Google's Apps Script quotas page. The 6-minute ceiling is why the script above works in batches: a job that tries to touch every thread in a big mailbox at once will time out partway.

When Zapier or Make is the better choice

Zapier and Make are the better choice when a Google app has to talk to something outside Google, like a CRM, an invoicing tool or a project board that Workspace Studio's beta integrations don't cover. Both have free tiers, and both get expensive in proportion to how often your automations run.

• Zapier Free covers 100 tasks monthly, limited to two-step Zaps (one trigger, one action) that check for new data every 15 minutes. Professional includes 750 tasks: $29.99 if you pay monthly, or $19.99 a month when you commit for a year, per Zapier's pricing page.
• Make Free includes 1,000 credits a month, per Make's pricing page. Make's visual builder handles branching scenarios well, at the cost of a steeper first hour.

My test for reaching for a connector: does the data have to leave Google to be useful? If a form answer only needs to reach a sheet and a Chat space, Workspace Studio or a linked sheet does it free. If it has to become a deal in a CRM, a connector earns its fee. A Zap that fires on every incoming email can use up 100 free tasks quickly, so filter at the trigger, not later in the chain.

Google Workspace automation ideas by app

Here is where each tool fits for the chores people automate most, app by app.

• Gmail: label and archive by sender with a filter; a daily recap of unread mail with Workspace Studio's Recap unread emails step; batch cleanup of old mail with Apps Script. Saving attachments has its own guide: save Gmail attachments to Google Drive.
• Google Sheets: format and sort with a macro; append rows from a form with Link to Sheets; email a summary when a sheet changes with Studio's When a sheet changes starter.
• Google Drive: sort new uploads with Studio's When an item is added to a folder starter and Move files or folders step, or rename files on a schedule with Apps Script.
• Google Forms: response emails and a linked sheet natively; a Chat post or a follow-up email with When a form response comes in in Studio.
• Google Docs: generate a doc from form answers with Studio's Create a doc step, or fill a template with Apps Script.
• Google Calendar: block focus time with Studio's Block time step; default alerts and event creation are covered in how to automate Google Calendar.

I keep the sign-ups for a recurring team lunch in a Google Form linked to a sheet, which is the whole automation. Nobody needs to email me, I don't retype anything, and when the headcount matters I open one tab. It's a reminder that the boring native option is often the finished product.

Why a Google Workspace automation stops working

Most broken automations fail for one of a handful of reasons, and Google's own documentation explains each of them.

• The owner left or lost access. Apps Script triggers always run under the account that created them, and other accounts can't see them, per Google's trigger guide. When that person leaves, their scripts can stall with no one else able to spot why.
• The run timed out. A single Apps Script run stops at 6 minutes. Process in batches, as the script above does.
• The daily quota ran out. Personal accounts get 90 minutes of trigger runtime a day and 100 email recipients, per the quotas page. Heavy jobs belong on a Workspace account.
• The file was opened view-only. Open and edit triggers don't fire for someone in view or comment mode.
• The Studio flow never saw the email. The When I get an email starter only offers Gmail's default labels, so a flow can't be limited to a custom label your filters apply.
• Workspace Studio isn't there. Check the edition list and ask your admin whether Gemini is turned on for your account.

Before I go on leave, I list every automation that runs under my account and hand each one over or pause it. Triggers tied to one person are the classic thing that breaks the week someone is away, and nobody else can even see them to fix them.

Where to start this week

1. Write down the three chores you repeat most in Gmail, Sheets, Drive or Forms.
2. Check whether a filter, a linked sheet or a form notification already covers one of them.
3. For work that stays inside Google and needs several steps, try a Workspace Studio template if your plan includes it.
4. For custom jobs or a free schedule, paste a small Apps Script function and add a time-driven trigger.
5. Only for work that must reach another app, set up a Zapier or Make automation, with a filter at the trigger.
6. Keep a short note of what runs, under whose account, so the next person can find it.