As part of our recent Automations feature release, a new set of triggers for Google users can be set up. These three automation triggers include:
- New row trigger for Google Sheets
- New response trigger for Google Forms
- New event trigger for Google Calendar
Basic setup instructions for Automations can be found in our Creating an automation support article.
NOTEAutomations is in active development and more functionality is on the way. Automations is currently available on Pro and Enterprise plans. If you have any feedback to offer, feel free to share that with us here.
As a prerequisite, you will need to already have a Google account. This account will need to be connected to the Airtable base that you are working in. After choosing which trigger you would like to set up, you will have the options to "Manage connected accounts" or "Connect new account". This authorization process is scoped to each individual Google service, so you will need to perform this process multiple times, at least once for each Google Workspace trigger, and also reauthorizations in the future as needed.
Choose a trigger
To start, select the “When event created” trigger from the list of available triggers. Then follow these setup steps to connect to the right Google Calendar.
- Connect your Google account (or select an already connected account)
- Select a calendar
- Run a test to make sure the connection is configured correctly (at least one event will need to be present in the calendar you selected)
Add an action
After you’ve configured and tested the trigger, it’s time to add an action. In the example below, we’ll use the “create record” action to create a new record in Airtable. Once you select the table where you want to create the records, you can configure which fields in that table you want to add in data from the Google Calendar event.
Once your action is configured and tested, make sure to turn the automation on. When a new event is added to the Google Calendar you selected, the automation action will run. In this example, a new record will be created in your base.
TIPFor more guidance on creating automations (including actions), see Creating an automation.