Skip to main content
Question

How to send separate emails for each row in Zapier using the loop function


In order to automate sending separate emails to a contact list on the excel specified dates, I have used the looping action by Zapier.

It is advised to use the ‘values to loop’ field to split the looping results. However, when i use the ‘values to loop’ field while entering values in the Gmail step, it is using only one row’s data as produced in the loop results, that is loop_iteration_1. On different days, there can be ‘n’ number of results (rows with name, email, etc.) to send mails to, but the Gmail step is sending mails to only one result even though Zapier agrees that there are 2 iterations in all.

I have attached the loop values I entered and the gmail values I entered along with the results produced by the gmail step.

How do I make Zapier send emails to all the loop results everyday?

Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+3

If the loop only processes one row, verify that the "Values to Loop" field contains all the rows you want to iterate over. Use a Formatter step to concatenate or split data if necessary.

Ensure the loop uses "Loop_Values" instead of "Preview_Loop_Values". Preview data is for testing and may not reflect the actual loop iterations.

​​​​​​​Add a column in Google Sheets (e.g., "Email Sent") to track which rows have been processed. Update this column after sending an email to avoid duplicate notifications.


  • Author
  • Beginner
  • 5 replies
  • January 27, 2025

 Hi,

Thanks for your reply.

I’ve ensured to use ‘Loop_Values” instead of ‘Preview_Loop_Values’. My loop results are also showing separated and are correct and I am currently using the professional account version of Zapier. ‘Values to loop’ field also has all the data required...

But when I test my gmail step using this data, it only sends a mail to the first iteration. I published the Zap as well to check whether it will send the mail at the given time but it did not send the mail to the other two iterations still

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7289 replies
  • February 10, 2025

Hi there, ​@soumya 👋

Just reaching out here to check how you’re getting on with this—were you able to get the Zap working correctly?

But when I test my gmail step using this data, it only sends a mail to the first iteration. I published the Zap as well to check whether it will send the mail at the given time but it did not send the mail to the other two iterations still

It’s expected that when testing in the Zap editor it will only use the first loop’s data for the test. When the Zap is published and runs live it would run through the other looped data, but each loop will appear as a separate Zap Run. If you check the other runs of the Zap in the Zap history can you see the other emails for the other two loop iterations?

Looking forward to hearing from you! 


  • Author
  • Beginner
  • 5 replies
  • February 12, 2025

Hi ​@SamB,

Thanks for reaching out : )
I sent a help mail to Zapier Support and Roniel helped me with the issues I was facing. You guys are doing a great job, my Zap is running perfectly now!


SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 7289 replies
  • February 12, 2025

That’s awesome to hear, ​@soumya! 🎉 I’m so glad Roniel was able to help and that your Zap is running perfectly now. And thanks for the kind words—they mean a lot! 😊

If you need anything else, just let us know. In the meantime, happy Zapping! ⚡