Create and manage registrations in Google Sheets

This Article will cover adding, updating and removing Arlo registrations from a Google Sheet.

There are a lot of variations on how you can use this Zap to suit your specific needs, such as filtering results so only certain registration types are added to certain sheets. In this example we'll keep it very simple and go through adding a course registration to a workbook and updating a row when a change is made to a registration in Arlo.

Recommended requirements

To create and use these Zaps you will need to have a starter plan or above with Zapier to access multi-step Zaps.

You will need a Gmail account.

Create a new row in a Google Sheet for a new Arlo registration

In your Zapier Dashboard select Create Zap.

Search for and select Arlo from the app selector.

Choose the required registration trigger (New Basic, New Multi-Session, or New Elearning registration) as the Trigger Event and press Continue.

Choose your account and press Continue.

On the find data step, press Test Trigger.

If Zapier says it cannot find any registrations to display try creating a new registration in your platform, waiting a couple minutes, and clicking test again.

Press Continue after the test has completed.

Search for and select Google Sheets as the new Trigger.

For Choose Action Event select Create Spreadsheet Row and press Continue.

Select the Google account you'd like to connect to the Zap.

You will need to connect to your Google account if this is the first time you've used it for a Zap.

Specify where the Zapier can locate the Google Spreadsheet and Worksheet.

Zapier will then pull in the columns you have set up in the Worksheet.

Enter the registration information from Arlo you'd like to use.

This information will be unique to your worksheet and is where you can leverage the greatest value from Zapier, creating highly customised spreadsheets that are part of a larger workflow!

With the spreadsheet selected and the Arlo information inputted to the relevant columns, press Continue.

In the final step you can test that the Zap will work and a new row is added successfully. Press Test & Continue.

The new registration will be now be a row in the spreadsheet.

The Zap is now created and ready to go, all that's left is to give it a name and turn it on.

Update a row in a Google Sheet when an Arlo registration is updated

In your Zapier Dashboard select Create Zap.

Search for and select Arlo from the app selector.

Choose the required registration trigger (Updated Basic, Updated Multi-Session, or Updated Elearning registration) as the Trigger Event and press Continue.

Choose your account and press Continue.

On the find data step, press Test and Continue.

If Zapier says it cannot find any registrations to display try updating a registration in your platform, waiting a couple minutes, and clicking test again.

Press Continue after the test has completed.

The next step is for Zapier to find the correct row for the registrant.

Search for and select Google Sheets as the new Trigger.

For Choose Action Event select Lookup Spreadsheet Row and press Continue.

Select the Google account you'd like to connect to the Zap.

Specify where the Zapier can locate the Google Spreadsheet and Worksheet.

Specify which column you'll use to look up the existing registration.

We recommend you use ID for the look up as this is unique for each registrant in a course. Google lets you specify a secondary look up column but this isn't required in this instance.

With the spreadsheet and row identified, press Continue.

You can now test that the Zap will find the correct row. Press Test & Continue.

With the correct row identified the next step is to update the data with the updated registration information.

Select Google Sheets as the app again.

Choose Updated Spreadsheet Row as the action.

Select your Google Account.

Specify which sheet to use. This needs to be the same as the one you used in the search step.

When selecting the Row to update you need to select Custom > Look up spreadsheet Row in Google Sheets > ID. This uses the previous search step to make sure Zapier edits the correct registration's row.