Articles in this section
See more
Articles in this section ▾
When a form is submitted trigger
Incoming webhooks trigger
At a scheduled time automation trigger
Outlook automation triggers
When a record matches conditions trigger
When record is created trigger
When record enters a view trigger
When record is updated trigger
New row trigger for Google Sheets
New response trigger for Google Forms
See more

New row trigger for Google Sheets

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:

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 

google_sheets_when_row_created_trigger_config_spotlight_choose_spreadsheet

 

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.

create_record_action_config_with_google_sheets_info

You can insert data that exists in the Google Sheet row, or manually insert other data (like the Status field shown below). 

create_record_action_config_with_full_google_sheets_info

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. 

TIP

For more guidance on creating automations (including actions), see Creating an automation.
Was this article helpful?

Related articles