

This will open the Automations side panel. Open the base that you prepared following the Setup section above, then click the Automations button in the top right of your base. Step 1: choose your base and create a new automation A linked record field, linked to a separate table of candidates, and maybe a lookup field or two to pull in relevant information on candidates.A collaborator field, to indicate which of your colleagues will be conducting each interview, and to invite as an attendee of your meeting.

A 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.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. A single select field, which will contain select options designating the status of each interview.Call these fields “Start Time” and “End Time,” or something similar. Two date fields, one of which will contain the start date and time of the event, and the other one of 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) which lists the specific interviews that you’re trying to schedule. Click the “Copy base” button in the embedded base above to add this example automation to one of your workspaces.
