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 “Event deleted” trigger from the list of available triggers. Then follow these setup steps to connect to the right Google Calendar.
Next, connect to your Google Forms account, and select the spreadsheet and worksheet where your form responses are populating.
Then, run a test to make sure the connection is configured correctly (at least one form response will need to be already submitted to test the connection).
NOTEYou need to use the “Select response destination” setting in your Google Form and designate a spreadsheet to use to collect response information. For help on this, please visit this support article from Google for more details.
NOTEThe trigger will only detect rows that are added to the bottom of the spreadsheet. If 3 rows were deleted from the spreadsheet and 3 more were added to replace them, we wouldn't detect the 3 new rows, but we would detect an additional 4th row.
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 for each new form response. Once you select the table where you want to create records, you can configure the fields in your table that you want to populate with details entered in the form.
TIPFor more guidance on creating automations (including actions), see Creating an automation.