ConditionalVisibility

new-products-promo

Google Sheets automation tutorials

Gmail automation tutorials

Google Calendar automation tutorials

Google Drive automation tutorials

Google Forms automation tutorials

Google Docs automation tutorials

Google Contacts automation tutorials

Google Business Profile automation tutorials

Automation inspiration

automation-inspiration-00-google-workspace-docs-sheets-drive

Gmail

Google Calendar

Google Contacts

Google Docs

Google Forms

Google Sheets

Google Tasks

Google Drive

Google Ads

Google Business Profile

Google AI Studio

Google makes some of the most popular—and powerful—software on the web. But automation can make Google Workspace even more versatile. Zapier connects to most of Google's best known apps.

How to automate your Google apps

Google Workspace automation

Keeping an updated record of key information means you never have to wonder if there are missing or forgotten items. Set up this integration, and Zapier can catch a webhook POST from any source you want, automatically adding the information to a new row on Google Sheets once you've chosen which items go into different columns during setup. From then on, you can be sure we'll catch everything while you're free to work on other tasks.

Webhooks simply POST data (or JSON) to a specific URL every time we see something new. Webhooks can also accept data (or JSON) to kick off a workflow in Zapier.

Webhooks by Zapier

Retrieve Poll

Wait for a new POST, PUT, or GET to a Zapier URL.

Catch Hook

Wait for a new POST, PUT, or GET to a Zapier URL. Gives the request body unparsed (max 2 MB) and also includes headers.

Catch Raw Hook

Fire off a custom request by providing raw details. Very flexible but unforgiving.

Custom Request

Fire off a single GET request with optional querystrings.

Fire off a single POST request as a form or JSON.

POST

Fire off a single PUT request as a form or JSON.

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Triggers when a new row is added to the bottom of a Google Team Drive spreadsheet.

New Spreadsheet Row (Team Drive)

Triggers when a new row is added to the bottom of a spreadsheet.

New Spreadsheet Row

Triggers when a new spreadsheet is created.

New Spreadsheet

Triggers when a new row is added or modified in a spreadsheet - works best with Team Drives.

New or Updated Spreadsheet Row (Team Drive)

Triggers when a new row is added or modified in a spreadsheet.

New or Updated Spreadsheet Row

Triggers when a worksheet is created in a spreadsheet.

New Worksheet

Find up to 500 rows based on a column and value as line items.

Lookup Spreadsheet Rows (Advanced)

Find Worksheet

Return up to 500 rows as a single JSON value or as line items.

Get Many Spreadsheet Rows (Advanced)

Find a specific spreadsheet row based on a column and value. If found, it returns the entire row. Optionally, create a new row if no match is found.

Lookup Spreadsheet Row

Finds or creates a specific find worksheet.

Find or Create Worksheet

Find or Create Row

Create a new column in a specific spreadsheet.

Create Spreadsheet Column

Create a new row in a specific spreadsheet.

Create Spreadsheet Row

Create one or more new rows in a specific spreadsheet (with line item support).

Create Multiple Spreadsheet Rows

Creates a new worksheet by copying an existing worksheet.

Copy Worksheet

Creates a new spreadsheet. Choose from a blank spreadsheet, a copy of an existing one, or one with headers.

Create Spreadsheet

Creates a new worksheet in a Google Sheet.

Create Worksheet

Clears the contents of the selected row(s) while keeping the row(s) intact in the spreadsheet.

Clear Spreadsheet Row(s)

Deletes the selected row(s) from the spreadsheet. This action removes the row(s) and all associated data.

Delete Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row

Update one or more rows in a specific spreadsheet (with line item support).

Update Spreadsheet Row(s)

Custom Actions (Beta)

This is an advanced action which makes a raw HTTP request that includes this integration's authentication.

API Request (Beta)

Add info to a Google Sheet from new Webhook POST requests

Spreadsheets make it easy to filter and sort through new prospects, but take time to build. Use this Facebook Lead Ads-Google Sheets integration to link your records directly to your ads so you can keep your mind on marketing. After being set up, every new ad lead on Facebook will trigger this Zap, automatically creating a new row on Google Sheets with all those valuable details for you. Learn more in our 

Facebook lead ads make signing up for business information easy for people and more valuable for businesses. The Facebook lead ad app is useful for marketers who want to automate actions on their leads.

Facebook Lead Ads

New Lead

Add new Facebook Lead Ads leads to rows on Google Sheets

Often it's helpful to store, backup and organize emails matching certain characteristics to a Google Spreadsheet. This Gmail Google Sheets integration makes it a breeze to setup a simple rule (i.e. emails from: 

One of the most popular email services, Gmail keeps track of all your emails with threaded conversations, tags, and Google-powered search to find any message you need.

Triggers when you receive a new attachment.

New Attachment

New Label

Triggers when you receive a new email and label it within two days.

New Labeled Email

Triggers when a new email appears in the specified mailbox.

New Email

Triggers when you receive a new email that matches a search string you provide.

New Email Matching Search

Triggers when you receive a new email and star it within two days.

New Starred Email

New Thread

Find Email

Find or Send Email

Add Label to Email

Delete Email

Create Draft

Create a draft reply to an existing email.

Create Draft Reply

Create Label

Send Email

Remove Label From Email

Reply to Email

Save new Gmail emails matching certain traits to a Google Spreadsheet

This integration makes it easy to trigger an email via Gmail for updates in a Google Spreadsheet. You can trigger an email based on any update or specific updates to a certain column. Get step-by-step directions in our 

Send emails via Gmail when Google Sheets rows are updated

You've had a good week of meetings, time to report back to your team about it! You could go back and try to remember them all, or you could let Zapier do all of that work for you. Once an event is scheduled with Calendly, a new row in a Google Sheets spreadsheet will be created automatically to easily store those details.

Calendly is an elegant and simple scheduling tool for businesses that eliminates email back and forth. It helps save time so that businesses can provide great service and increase sales.

Calendly

Triggers when an invitee cancels a scheduled event.

Invitee Canceled

Triggers when an invitee schedules an event

Invitee Created

Triggers when an invitee is marked as a no-show.

Invitee No Show Created

Find User

Creates a new one-off meeting in Calendly.

Create One-Off Meeting

Create Google Sheets rows from new scheduled Calendly events

A personal welcome email is a great way to kick-start a relationship with a new customer.This Zap can help with that, triggering whenever a new lead follows your call to action on Facebook Lead Ads. This integration automatically inserts their details into your email template and sends them your personal message from Gmail. You also have the option of sending their details to a teammate so they can follow up instead.

Send emails in Gmail for new leads in Facebook Lead Ads

After someone fills out a form on your site, you often want to receive an email notification or send a follow-up email to the individual who completed the form. This Zapier automation handles both gracefully, sending an email (customizable)—either to you or the form respondent—when a new form entry is submitted.

Typeform helps you ask awesomely online! If you ever need to run a survey, questionnaire, form, contest etc. Typeform will help you achieve it beautifully across all devices, every time, using its next generation platform.

Typeform

New Entry

Retrieves ALL file(s) of a given form that are uploaded as part of form submission.

Retrieve ALL Files

Lookup Responses

Create an Empty Form

Duplicates an Existing Form

Update Dropdown, Multiple Choice or Ranking Question Options

Get email notifications or send follow-ups to new Typeform respondents

Prep your follow-up workflows and stay organized effortlessly when you activate this Zap. Once it’s in place, this integration automatically adds an item to a specified database in Notion as soon as a new event is created in your Google Calendar.

Google Calendar lets you organize your schedule and share events with co-workers and friends. With Google's free online calendar, it's easy to keep track of your daily schedule.

New Calendar

Triggers when an event is cancelled or deleted.

Event Cancelled

Event Ended

Triggers when a specified amount of time before an event starts.

Event Start

Triggers when an event is created or updated (except when it's cancelled).

New or Updated Event

New Event

Triggers when an event is created that matches a search.

New Event Matching Search

Find Event

Finds a specific event by its ID in your calendar.

Retrieve Event by ID

Finds multiple events in your calendar as line items.

Find Multiple Events

Find or Create Event

Invites one or more person to an existing event.

Add Attendee(s) to Event

Create Calendar

Delete Event

Create Detailed Event

Create an event from a piece of text. Google parses the text for date, time, and description info.

Quick Add Event

Updates an event. Only filled fields are updated.

Update Event

A new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.

Notion

Triggers when a new item is created in a database.

New Database Item

Triggers when a new (non-database item) page is created your workspace or selected subpage.

New Page

Triggers when an item in a selected database is updated.

Updated Database Item

Updated Page

Triggers when a page or database item is updated. Optionally select a parent page or database to monitor.

Updated Page or Database Item

Retrieves the children of a block, with any text content rendered as Markdown.

Retrieve Block Children

Retrieves a list of un-resolved comments from a Page as line-items.

Get Page Comments

Searches for an item in a database by property.

Find Database Item

Find Page (By Title)

Retrieves the comments for the provided page, or creates one if no comments are found.

Find or Create Comment

Searches for a Database Item matching the provided query, or creates one if it does not exist.

Google Workspace automation

How to automate your Google apps

Related articles

Improve your productivity automatically. Use Zapier to get your apps working together.