ConditionalVisibility

new-products-promo

Automation inspiration

Zapier app logo hero

Google Sheets

Trello

Google Calendar

It’s embarrassing when something slips through the cracks, or if you commit to something and forget to mark it on your calendar. This is a problem that Zapier solves.

Automatically create calendar events, track emails, and add tasks to your to-do list

How to make Zapier your personal assistant

An inbox is just a queue—it's not a calendar. Visualize your important emails over time with this Gmail-Google Calendar integration. After it's set up, any new email you get on Gmail (or only within a certain label) will tell Zapier to create a new Google Calendar event for you, set by default to start at the time the email is received and end 5 minutes later.

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.

Gmail

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

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

Custom Actions (Beta)

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

API Request (Beta)

Create Google Calendar events from new Gmail emails 

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: 

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)

Save new Gmail emails matching certain traits to a Google Spreadsheet

Trying to bulk create Trello cards? Or perhaps you have a Google Form that should create Trello cards.

Trello is a team collaboration tool that lets you organize anything and everything to keep your projects on task.

New Board

New Card

Triggers when a Card is archived in Trello.

New Card Archived

Triggers when a Comment is added to a Card in Trello.

New Comment in Card

Triggers when there is activity in Trello.

New Activity

Triggers when a Card is moved to a List in Trello, [inside the same Board](https://zapier.com/apps/trello/help#common-problems-trello#not-triggering-on-card-moved-to-list-when-a-card-is-moved-from-another-board).

Card Moved to List

Triggers at a specified time before a card is due.

Card Due

Triggers when a Card is updated in Trello.

Card Updated

Triggers when a new checklist is created in Trello.

New Checklist

Triggers when a new label is created in Trello.

Triggers when a label is added in a Trello card.

New Label Added to Card

Triggers when a new list on a board is added.

New List

Triggers when a new member joins a board.

New Member on Board

Triggers when you get a new notification in Trello.

New Notification

Finds a label on a particular board by name.

Find Label on Board

Finds a list on a particular board by name.

Find List on a Board

Finds a checklist on a particular board or card by name.

Find Checklist

Finds a checklist item on a particular checklist by name.

Find Checklist Item

Finds a board in your Trello organization by name.

Find Board

Finds a card in your Trello organization by name, given a specified board and list. Does not search archived cards.

How to make Zapier your personal assistant

Automatically create calendar events, track emails, and add tasks to your to-do list

Related articles

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