Best answer

Running the same Zap for each row of a spreadhsheet

  • 15 October 2020
  • 6 replies
  • 773 views

Userlevel 1

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

icon

Best answer by Troy Tessalone 16 October 2020, 02:08

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Userlevel 7
Badge +14

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.

 

Userlevel 1

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.

Userlevel 7
Badge +14

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?

Userlevel 1

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. 

Userlevel 7
Badge +14

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

Userlevel 1

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