How do I automate data completion in Google Sheets using Zapier for information from other systems?

Question

We have new organizations signing up with us, and we are trying to automate the process of setting their people up as users on our system.

I am starting with a google sheet that has a list of email addresses of the people who will be users. For each row in that sheet, I want to go to various other systems (e.g. Hubspot, Stripe) to get some information as some of them may already have registered with us, or be known to us for whatever reason.

The spreadsheet e.g. will have rows like this:

The first column will be the email address, and I just want to fill in the other columns with data from those other systems. The hubspot and stripe queries I can manage. What I don’t know how to do is:

Trigger the zap in the first place -
1. it isn’t a row by row trigger, I’ll have all the rows at once
2. It is a new spreadsheet each time
Loop through the rows and complete each in turn (where in each loop I would be doing the searches in Hubspot and Stripe, etc.)

thanks!

icon

Best answer by Troy Tessalone 7 March 2024, 00:08

View original

Troy Tessalone · Accepted Answer

Hi @RunForestRunWhy not add another column that you can use to trigger the Zap? (e.g. Status = TRUE/FALSE)Try this Zap trigger: GSheets - New/Updated RowAs Step 2, add a Filter to check conditions for UPDATED rows.TIP: I’d recommend using Airtable instead of GSheets.

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded