Uploading CSV (Formatter) to Zapier Table (Find or Create) doesn't process individual lines, instead I get one line with all the values comma separated:
In this case I’m trying to find or create by Employee Number - but as you can see it just gives one long string with each of the values for that column in the file.
What am I doing wrong with this Zap?
Hi
Try adding Looping (Create Loop from Line Items) to iterate each CSV row: https://zapier.com/apps/looping/help
Thank you. I just started playing around with Create Loop from line items, but not sure what I should put in the two values to loop fields…
When selecting from the second drop down it still gives me Output Line Items Employee Name, with all the employee names, etc. (like the first screenshot).
Check the field description for guidance.
Select the field that has the comma delimited list of values that you can the Zap step to loop thru. (e.g. Employee)
Help article about Looping: https://help.zapier.com/hc/en-us/articles/8496106701453-Loop-your-Zap-actions
When in doubt test it out.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.