Question

How do I use Looping to trigger every entry, emailing each contact with custom information?

  • 23 September 2022
  • 9 replies
  • 68 views

Userlevel 1
Badge

Hi

I have a very simple table. 

I would like to run a zap over every entry, emailing each contact with custom information. 

 

How do I use loops to do this?

 

Thank you in advance!

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Userlevel 7
Badge +14

Hi @ABABAB 

Good question.

Here’s a help article about how to create a looping Zap with GSheets and Webhooks:

 

OR

 

You can try using these GSheet Zap actions followed by the Looping app:

 

Userlevel 7
Badge +8

Hi @ABABAB 

 

As @Troy Tessalone said, this is how to use Loops. HOWEVER, from what I see in this, you dont actually need it? Is the trigger not this table? 

Userlevel 1
Badge

Thank you both for the reply. It looks as though Loops is not necessary, but I will instead use a Zap that triggers itself at the end of its run. 

Thanks

Userlevel 7
Badge +8

Hey @ABABAB , 

 

To be clear, instead of Loops, you can use Google Sheets > New Spreadsheet Row (Please see below screenshot)

 

After doing that, you can use the data from each row separately to do the action you need. 

 

Hopefully that helps :) 

Userlevel 1
Badge

Thanks very much, 

 

But where I am getting stuck is instructing the Zap to move on to the next row once it has actioned a particular row. 

 

What is the instruction to tell the Zap to move on?

Userlevel 7
Badge +8

There is no such thing as that, it triggers whenever a new row is created and/or updated (if you chose the updated row option) 

 

So basically it is going to trigger for all of them but not in sequence IF they are updated / created. 

 

Can you maybe share screenshots of what you are trying to do or explain it in terms of When This Happens, Do This ? 

Userlevel 1
Badge

I have a list of contacts and the amount they owe. 

 

I’d like to send each one a form email reminding them their payment is due. 

 

Thanks

 

This post has been edited by a moderator to remove personal identifiable information.

Userlevel 7
Badge +14

@ABABAB 

Add another column that you can use to trigger the Zap.

“New or Updated Spreadsheet Row” trigger behavior

If you’re using the New or Updated Spreadsheet Row trigger and choose Any column to monitor, any change to a row will trigger your Zap.
If you select a specific column, then the Zap will only trigger when there are changes on that column.

Note

Zaps using New or Updated Spreadsheet Row will also trigger for any new rows in the spreadsheet, even if the specified column is blank.
To avoid triggering in those cases, add a Filter step to your Zap.

Userlevel 7
Badge +12

Hi @ABABAB!

Were you able to get a Zap set up the way that you need it?

To sum up what @Troy Tessalone and @MohSwellam have said, Zaps generally work with new events/information for example when you add a new row to the sheet, then take the information in that row and use it to send an email. 

As you’re using a Google Sheet, you can do what Troy suggested, which is to:

  1. Add a column to the sheet
  2. Set up a Zap with the new or updated spreadsheet row trigger and have it trigger from the new column
  3. When your Zap is published and turned on, add an x (or anything) into the new column for each row
  4. When all of the emails have been sent by the Zap, turn it off or change the trigger to New Spreadsheet row, so it doesn’t continue to trigger if any information in the sheet is updated. 

 

Another option for you would be to use Transfer by Zapier. Transfer allows you to work with existing data and from what you’ve described, it would work well for you in this case. If all the information you need in the email is in the Google Sheet, then you can set it up so that it goes through all of the rows in the sheet and sends them an email. You can learn more about Transfer and get started on this page

 

Let us know if either of those solutions works for you or if you need some more help!