Question

Importing a CSV with a title row + header row

  • 14 June 2021
  • 1 reply
  • 56 views

I have a Zap where I’m grabbing a CSV file attachment from Gmail and using Utilities and Formatter to add the rows from the CSV to a Google Sheet. The problem is that the structure of the CSV is unconventional, it has a title row AND a header row, which leads to the output being invalid. When I manually remove the first title row from the CSV before importing it, it works fine. What kind of step / setting could I add to make the Zap essentially ignore the first row and acknowledge the second as the header row?

Here is what the first two rows of the CSV file look like:

NPS Survey Response Report :,,,,,,,,,,,,,,,,
MASSMAILID,Template Name,Opportunity Name,Sent By,Sent On,Sent To,First Opened,No. of Opens,No. of Clicks,Status,Record Name,Subject,Amount,Closing Date,Next Step,Pipeline,Stage
***data starts here***

 


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +12

Hi @jvlazny

You may have to use a custom Code step to remove the first CSV row: https://zapier.com/apps/code/help

 

Try using the shift() method which removes the first item of an array.

 

Article: https://www.w3schools.com/jsref/jsref_shift.asp