Hello! Recently Zoho updated it’s csv reports and broke a zap I had with a weekly report. I need to now remove the first 6 rows of the CSV to import the new header at row 7 and everything below. Any free service or way I can do this?
Best answer by Troy Tessalone
View original
+14
Hi
Good question.
What are the steps in your current Zap?
The issues is that I need a step 4.5 to remove the first 6 lines of the CSV file
+14
If you are using Gmail as the Zap trigger, then you may be able to use this Zap trigger event if the CSV is not in a Zip file, which would eliminate the need for using ConvertAPI.
You may want to consider using Formatter > Utilities > Import CSV File instead of the other Formatter steps.
NOTE: Depending on how many records are in the CSV file, you can use Looping followed by a Filter step to exclude those rows and then a GSheet Create Row step to populate a GSheet template each time, instead of using GSheets Create Row(s).
Otherwise, it’s likely a Code step would have to be used to remove the first 6 lines before adding to the GSheet: https://zapier.com/apps/code/help
+9
Hey
Let me know what you think of those suggestions and what questions you have!
+14
cc:
Keep in mind that the Zap action for GSheet Delete Row only deletes the contents of the row.
+9
Hey
+9
Ahh, gotcha
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
