Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Hi all, 

Once a week I need to go through our company spreadsheet (Google) and look at various data entry. 

I then need to send emails - reminders - commandes…. based on the data that were updated during the week 

I have created a Zap that would do automatize certain task. 

 

What I would like to do is:

Having the same zap running  for each Row of the Spreadsheet

 

Example: 

Row 1: No change nothing to do => SKIP to next row 

Row 2: Commande ready => Send email to client Continue to Row 3 

Row 3 Document needed => Send reminder to get documents Continue to Row 4 

Row 4…. 

LAST Row: Change of address => Reminder to change addres => END 

END 

 

What wold be the solution to keep repeating the zap until the end of the rows? 

 

Thank you all for your help

You can configure Zaps that trigger with GSheets New/Updated Row and specify the column that will trigger the update, and maybe use a Filter step to ensure only the desired criteria is met to continue with the other Zap actions.

 

Hi Thank you for your answer,

Unfortunately, since there are more than 20 multiple variations I would have to create more than 50 zaps to be able to make this happen 

 

What I was thinking was more of a checking zap but for each row one after the other

Look up row => If something has change => Action then next row lookup 

and all the way to the end of the spreadsheet then the zap is done when they arrive at the end of the spreadsheet.

You’d have to create a looping Zap that iterates over each row in the GSheet incrementally.

But in that case, I think the bigger question is how will the Zap know that data has been updated?

Thank you Yes that is exactly what I am looking to do  LOOPING ZAP. 

How would I do that?

 

The zap will do a Lookup for the row then with filter and Path will do the right course of action. 

 

But its the gong to the next row that is my issue. 

[advanced] Looping Zaps require a more advanced setup using Code, Filter, Webhook apps.

For those looking for a similar solution here is the answer. 

Looping Zap 

https://www.luhhu.com/blog/video-creating-a-looping-zapier-automation-using-webhooks

Terms & Conditions