Skip to main content
Best answer

Looping by Zapier only sends the first iteration a mail not the rest of the results


I want zapier to send mails looking through the excel sheet data of rows (with email address, name etc.) with dates which match the current date and send mails according to that row’s data.

 

  1. For this, I created a ‘Schedule by Zapier’ and set it to ‘everyday’.
  2. After this I added the ‘Formatter’ step and set the time for the action to be run. 
  3. Next, I created an Excel step and set the ‘lookup_value’ to OUTPUT from the FORMATTER step
  4. After this, a Loop from line items Step that splits the results generated by excel into separate values.
  5. Post this was a Gmail step where I filled the to, body and from fields with the results from the loop field where I made sure I use the ‘values to loop’ and not ‘preview loop values’

I ran the loop and even tested it but, Zapier only sends the first iteration a mail and not the rest of the loop results. I asked this question in ‘How to’ yesterday but the doubt remains..

Could someone please help me figure this out?

Best answer by Troy Tessalone

@soumya 

The variables mapped from the Looping step to the To field in Zap step 5 create an INVALID email address. (remove the “Date”)

To troubleshoot, check your Zap Runs history details to see the DATA IN/OUT for each step.

There will be 1 Zap Run per loop iteration.

 

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

7 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@soumya 

Try turning your Zap ON and testing live.

 

Help links for using Looping in Zaps: https://zapier.com/apps/looping/integrations#help

  • When you test this action, the Zap will only create the first loop.
    • It will not create any other loops during the test.

 


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

Hi sir,

I tried switching on the Zap and running it live. It is still only sending the first person the mail…

 

 

 

And the mail after publishing and turning the Zap on was still getting sent to only the first iteration...


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • Answer
  • January 28, 2025

@soumya 

The variables mapped from the Looping step to the To field in Zap step 5 create an INVALID email address. (remove the “Date”)

To troubleshoot, check your Zap Runs history details to see the DATA IN/OUT for each step.

There will be 1 Zap Run per loop iteration.

 


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

Hi sir, 
Thanks for you r reply. I made the changes suggested. 

1. When I test the loop, Zapier is sending the first Iteration the mail required, correctly 
2. But when I schedule the mail according to the time, PUBLISH the zap and turn it on, it is not sending any emails and is not getting triggered. 
When I re-scheduled the mail to 12 pm, it did not update the time after resaving and republishing

I checked the Zap history on the Microsoft Excel step but it says-
"This Microsoft Excel step hit an error
Halted Exception: You do not have permissions to open this file in the browser."

How to schedule correctly and avoid this Excel access error?

 


Troy Tessalone
Forum|alt.badge.img+14

@soumya 

Help links for using Excel in Zaps: https://zapier.com/apps/excel/integrations#help


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

Thanks Troy, for the help!

The error was actually in the difference of time zone settings in my profile and that of the zap which is why the zap was not getting scheduled.

Thanks once again.


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2203 replies
  • January 31, 2025

Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.