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.

Best answer

Remove first 6 rows of CSV for import

Z

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 TessaloneBest answer by Troy Tessalone

@zormstorm 

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

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @zormstorm 

Good question.

What are the steps in your current Zap?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Z
  • zormstormBeginner
  • Author
  • Beginner
  • 2 replies
  • June 21, 2022

@Troy Tessalone thanks and see below:

  1. New email coming to zapier
  2. convert file with convertAPI to isolate the csv from the zipped file
  3. delay to let that process correctly for a minute
  4. formatter to get the csv url
  5. formatter to get the csv line items
  6. google sheets spreadsheet import
  7. delay
  8. google sheets lookup
  9. slack channel message

The issues is that I need a step 4.5 to remove the first 6 lines of the CSV file 

 

Troy Tessalone
Forum|alt.badge.img+14
  • Troy TessaloneZapier Expert
  • Zapier Expert
  • 30959 replies
  • Answer
  • June 21, 2022

@zormstorm 

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jesse
Forum|alt.badge.img+9
  • jesseArchitect
  • Architect
  • 1348 replies
  • June 27, 2022

Hey @zormstorm! It sounds like the main issue you’re looking to resolve here is removing those first 6 rows. I am wondering: do you have a way of converting this to a Google Sheet? If so, you may be able to add a few steps to delete spreadsheet rows for rows 1-6. If not, you may need to first convert the csv to a Google Sheet using a workaround like this: 

Let me know what you think of those suggestions and what questions you have!

Troy Tessalone
Forum|alt.badge.img+14

@zormstorm 

cc: @jesse 

Keep in mind that the Zap action for GSheet Delete Row only deletes the contents of the row.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
jesse
Forum|alt.badge.img+9
  • jesseArchitect
  • Architect
  • 1348 replies
  • June 28, 2022

@Troy Tessalone Ahh, thanks for calling that out! It sounds like your suggestion may be the best way to go here then. @zormstorm Let us know if you give Troy’s suggestions a try and if you’re able to get things working the way you’re wanting to here!

Z
  • zormstormBeginner
  • Author
  • Beginner
  • 2 replies
  • June 29, 2022

Hey @jesse and @Troy Tessalone - thank you both for trying to help. I am using the Formatter > Utilities > Import CSV File but again the issue is I’m unable to remove the extra rows in Zapier it seems without writing code. Hopefully I can edit the original file that gets sent soon to fix this.

christina.d
Forum|alt.badge.img+9
  • christina.dZapier Staff
  • Zapier Staff
  • 2653 replies
  • July 1, 2022

Ahh, gotcha @zormstorm. Thanks for sharing this with us! Sorry there wasn’t a simpler solution here but we definitely appreciate you bringing this to the Community!

Terms & Conditions