I’m trying to grab some data out of a csv that’s in an e-mail attachment and put it in an excel spreadsheet.
So far I’ve been able to get the information into different columns and rows in excel.
The issue I’m running into so far is that the rows don’t align across the columns.
In this image the numbers under “impressions” should align with the advertiser name.
I’m using the line item option.
I’m super new to this type of work so please bare with me if I didn’t provide enough information.
Best answer by Troy Tessalone
It can be done via automation steps.
Compared to GSheets, Excel does not have as many available Zap actions to use.
Zap action: GSheets - Delete Rows
Email attachment needs to be first uploaded and converted to a GSheet to use.
+14Hi
Issue may be related to how the original file is formatted.
Is it an XLS or a CSV?
Otherwise, more advanced approaches have to be used to first prep the file data.
Hi
Issue may be related to how the original file is formatted.
Is it an XLS or a CSV?
Otherwise, more advanced approaches have to be used to first prep the file data.
Example attached.
It’s a CSV
I think the issue is that the first colum has a row in it’s that’s blank in the other colums.
Is there a way to account for that?
I can’t change the formmating of the report I receive unfortuently.
+14
For this to work in a simple way, row 1 would need to be the headers.
Since the CSV is not formatted as a true flat file, that means the file would need to be manipulated before it can be processed as expected in the Zap steps.
That would mean deleting the first 6 rows.
For this to work in a simple way, row 1 would need to be the headers.
Since the CSV is not formatted as a true flat file, that means the file would need to be manipulated before it can be processed as expected in the Zap steps.
That would mean deleting the first 6 rows.
Appreciate you letting me know.
And there isn’t an easy way to remove those rows with Zapier?
I don’t have control of how the report is generated.
+14
It can be done via automation steps.
Compared to GSheets, Excel does not have as many available Zap actions to use.
Zap action: GSheets - Delete Rows
Email attachment needs to be first uploaded and converted to a GSheet to use.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
