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. 

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 

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.