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:
- ignore/remove the first line of the file.
- import rows 2-14. Row 2 is the header row.
- create new columns
- insert data into new columns that is extracted from email.
I have attached a screenshot for reference. Any help would be appreciated.
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.
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.