In order to set this up, click the blue + button under where it says “Start Date and Time”-this allows you to insert variables from the trigger step. In this case, we want the timestamps to come from the “Start Time” and “End Time” fields, respectively. You’ll then also need to specify the start date and time as well as the end date and time of each event. The Calendar dropdown will automatically list the calendars associated with the selected Google Calendar account. Once you’ve connected a Google Calendar account, you’ll need to specify the calendar to which you’d like to add the events. If you haven’t connected a Google Calendar account before, you’ll need to authorize Airtable Automations to connect your account. Next, you’ll need to select a Google Calendar account from which you’d like to post. Select the Google Calendar: Create event option. A menu will appear with a wide variety of potential actions. In our case, the action we want to perform is to schedule an event in Google Calendar using the date parameters from the record that was just marked as “Scheduled.”Ĭlick the + Add advanced logic or action button.
A collaborator field, to indicate which of your colleagues will be conducting each interview, and to invite them as an attendee of your meeting.Īctions are the tasks that get performed after a trigger fires. 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. 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.