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 have a Zap that runs a loop to pull an employee # from a csv file, call an API to get a value from the employee’s profile, and then I need to do a find/replace in the csv file to replace the employee old value with the new value. I can’t seem to be able to find a working solution that will pull in the csv file, then continue to update it until all records are updated. I keep getting stuck with the loop going back to replace the original csv file. In general, this is what my zap looks like where I’ve tried using Tables and Files. Any ideas?

 

Hi ​@melissa.hunchuck 

Your screenshot shows a Zap app action that do not exist:

  • Files by Zapier - Get File
  • Files by Zapier - Update File

These are the available File by Zapier triggers/actions: https://zapier.com/apps/files-by-zapier/integrations#triggers-and-actions

 

For the general Zap logic, you likely have to upload the CSV file to GDrive via the GDrive Zap app, then you can use the GSheets Zap app to do the updating of rows in the GSheet.

 

https://zapier.com/apps/google-drive/integrations#triggers-and-actions

https://zapier.com/apps/google-sheets/integrations#triggers-and-actions

 

 

​@melissa.hunchuck 

If you are looking to hire help, there is a directory of Zapier Partners: https://zapier.com/partnerdirectory

Hey ​@melissa.hunchuck,

It’s a bit hard to tell the exact issue you are running into from the screenshot and what you described. But some of troubleshooting you can try-

  • Do not edit CSV directly but just rather use Zapier Tables/ Sheets and in the end create a CSV.
  • If you have any problems with editing the Same CSV, try creating multiple CSVs for different versions to see if it solves your problem. 
  • Also you can’t use a loop inside a Sub Zap if you see the limitations here- https://help.zapier.com/hc/en-us/articles/8496106701453-Loop-your-Zap-actions

I think try these to see if it fixes your issue. Hope it helps!

PS: If you need more active help, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn

Terms & ConditionsAccessibility statement