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.

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