Create & 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 events registrants to its associated workbook.

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 New Registration as the Trigger Event and click Continue

Choose your account and click Continue

On the find data step click Test Trigger

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

Click 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 click 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, click Continue
In the final step you can test that the Zap will work and a new row is added successfully. Click 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 Updated Registrant as the Trigger Event and click Continue

Choose your account and click Continue

On the find data step click Test and Continue

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

Click 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 click 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 as this is unique for each registrant in an event

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

With the Spreadsheet and row identified, click Continue
You can now test that the Zap will find the correct row. Click 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 correction registrations row.