Ignore first row in CSV Import

Hello,

I am trying to set up a scenario to monitor an email address for new emails with CSV attachments. I was able to extract the CSV and save it to a Google Drive. Unfortunately, the CSV file is not formatted correctly. I need to do the following:

  1. ignore/remove the first line of the file.
  2. import rows 2-14. Row 2 is the header row.
  3. create new columns
  4. insert data into new columns that is extracted from email.

I have attached a screenshot for reference. Any help would be appreciated.


s

What have you tried in make already?

I am really new to all of this so I have not tried anything. I don’t know where to begin. I am not a developer but rather rely on no code solutions.

:+1: that’s good to know. If you want someone to spend time to build your scenario for you, you may be waiting a long time. The experts here can help but many of them make a living building scenarios for others.

My name is Alex Sirota and I am the founder of NewPath Consulting. We are a 4-year old Make.com partner. We offer a one hour video call where we explain and show how Make can help your organization.

We even build some scenarios and share them with you so get more value than a usual exploratory discussion. Book some time with me at Make.com Hero - NewPath Consulting

I look forward to talking to you and your team should they join us.