About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I use Looping to trigger every entry, emailing each contact with custom information?
Question

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

  • 23 September 2022
  • 9 replies
  • 60 views
A
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

Troy Tessalone
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:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
MohSwellam
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? 

Founder of GeekyAir.com
A
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

MohSwellam
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 :) 

Founder of GeekyAir.com
A
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?

MohSwellam
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 ? 

Founder of GeekyAir.com
A
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.

Troy Tessalone
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.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Danvers
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!

Terms & Conditions