Zapier airtable google calendar how to#

For example, you could include:Ī text-based primary field (like a single line text field or a text-based formula field) to determine the name of the event as it will appear in Google Calendar.Ī linked record field, linked to a separate table of candidates, and maybe a lookup field or two to pull in relevant information on candidates. You can mix and match different values from these fields to customize the title, description, and other optional attributes of the Google Calendar events that get created. If you’d like, your table can also include other optional fields with information about the interviews. “Scheduled” (To mark events that are ready to be synced to Google Calendar, when you’re ready) “Tentative” or “Not yet scheduled” (To designate interviews that aren’t yet ready to be pushed to Google Calendar) This status field should include at least these two options: Call this field “Status,” or something similar. Call these fields “Start Time” and “End Time,” or something similar.Ī single select field that will contain select options designating the status of each interview. Two date fields, one of which will contain the start date and time of the event, and the other one which will contain the end date and time of the event. In this table, you’ll need the following: In your Airtable base, you should have a table (called “Interviews,” or something similar) that lists the specific interviews that you’re trying to schedule. In this example, we’ll use a simple applicant tracking system (shown below) that a recruiting team is using to schedule interview sessions.Ĭlick the Copy base button in the embedded base below to add this example automation to one of your workspaces. You’ll also need to have an Airtable base in which you’re organizing the events that you’d like to schedule. First, you’ll need an Airtable account and a Google Calendar account. To build this automation, you’ll need a couple of ingredients. Preparing a base to automatically schedule calendar events Owners/Creators - Create, delete, duplicate, configure, or rename an automation and edit an automation's description.Įditors - View an automation's configuration or copy an automation's URL.

You can use similar techniques to add a Google Calendar automation in other bases, and you can also make a copy of the base below, which already has the automation built into it for you.

Zapier airtable google calendar how to#

In this article, we’ll show you step-by-step instructions for how to add this automation to an existing Airtable base for an applicant tracking system. Learn how to create an automation that will automatically schedule Google Calendar events.