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.

I exported data from other system as CSV then imported to Zapier table. A few hundreds rows.

I'd like to do some action for each row. But while creating a Zap, I have to choose event like when a row is added/updated. I cannot create a loop to iterate all rows.

My current workaround is to create a new column in Button type. Then create a zap when the button is clicked, do something based on the value of other columns. But I have to click the button a hundred of times 😑!!

Is there a better way to automate this?

Also Zapier table filter is a bit too simply, only AND condition, no NOT or OR. The zap also only works with Table not View.

Call for ideas how to automate this (take actions for each rows, without editing them or reimporting data)

Hi @jove 

Try using these Zap steps:

  • Action: Zapier Tables - Find Records
    • MAX of 1k
    • Make sure all the Zapier Table records have a common lookup value to search by
  • Action: Looping - Create Loop from Line Items
    • MAX of 500 iterations

 

Thanks, Troy. Two more questions:

  • How to trigger this? I guess one workaround is to set a monthly trigger. But I prefer a one time thing. Do I have to click a new table with a button.
  • If there are there are more than 500 rows in the table, how to iterate?

@jove 

Zap trigger options:

 

I recommend doing a test on a small subset before trying to do more. (e.g. 3-5)

For the lookup field being used, make sure the records have the same value.

Change the lookup field value to make sure there are batches smaller than 500.


 

Thanks for the tips. I will try next time. I already clicked the Action Button in my Table a hundred time today..

Thanks for providing a solution @Troy Tessalone. 
 

My zap uses Excel. Is this also doable with Excel? I can see a ‘find row’ action but not one that outputs as line items like Zapier Tables above. 

Hi @Ed M 

GSheets, Airtable, Zapier Tables have better options for finding multiple rows than Excel.

Terms & Conditions