Like the title says, I’ve got a CSV that comes to Zapier with two top rows. Looks like this:
BTW – this file lives in an SFTP directory. No Google Sheets or Excel. Just a CSV.
Is there a way to indicate that the actual header row starts with row 2? Any other ideas for a solution? Much appreciated Zapier friends.
+14Hi
How are you trying to use the CSV in a Zap?
Perhaps post screenshots with how your Zap steps are configured.
I’ll be looping over each row below row 2 (the real header). So something like this:
Get CSV
Loop over rows (each column needs to be output separately)
Send an email using (address from column 1, name from column 2)
Here’s a screenshot of my Utilities output where I’ve imported the CSV. I’m thinking the fact that row 1 isn’t a header (there’s only text in the first column) and that the actual header is in row 2 is causing the issue.
+14Likely a Code step needs to be used to remove the first row: https://zapier.com/apps/code/help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
