Looping and "Is Last Iteration" head aches - Still no solution?

Question

I went down the rabbit hole (again) to try and figure out how to correctly update rows on a google sheet in the correct sequence …. this post exactly describes my issue:

Here’s my specific problem...

My users upload a spreadsheets (50-250 rows) to a Google Form.
I convert the CSV file to a Google Sheet
I use Zapier looping to update each spreadsheet row
I have a filter near the bottom of the loop that checks to see “if last interation = true”
When it’s true, I want to perform further actions, but I can’t guarantee that it will fire last unless I put some big delay action after the filter and “hope” all the other steps are complete.

Am I missing something? Is there a solution to this yet?

Troy Tessalone · Accepted Answer

Hi ​@Dubs24Currently, Looping iterations run in parallel unless configured otherwise.You can add a Delay (For) step and set the Delay For value to be the loop iteration.e.g. Loop iteration delay for 1 minute, loop iteration 2 delay for 2 minutes, and so on.Otherwise, you’d have to explore more advanced approaches using logging (e.g. in a Zapier Table with the loop iteration # and isLast = true/false), then another Zap that is triggered to one by one find the next record to process.

Dubs24 · Answer

​@Troy Tessalone- you are correct. One of the biggest breakthroughs I’ve had was the “Continue if last iteration” value is practically worthless in most scenarios. Instead, I used Storage by Zapier to capture how many interations I expected before the loop started, then added to that value after each iteration, so now I can be certain when the last loop actually occurs.

Looping and "Is Last Iteration" head aches - Still no solution?

2 replies

Useful links

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded