Overview
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.
NOTE
Automations 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.Account authorization
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 row created” trigger from the list of available triggers. Then follow these setup steps to connect to the right Google Sheet.
- Connect your Google account (or select an already connected account)
- Select a spreadsheet Select a worksheet (the worksheet must have column headers)
- Run a test to make sure the connection is configured correctly
NOTE
The 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. 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 Sheet row.
You can insert data that exists in the Google Sheet row, or manually insert other data (like the Status field shown below).
Once your action is configured and tested, make sure to turn the automation on. When a new row is added to the Google Sheet you selected, the automation action will run. In this example, a new record will be created in your base.