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 TessaloneBest 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.
+6Hi
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
Hi
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
We're looking forward to your response.
It did provide me with enough insight to understand that given the limitations of the platforms I have to work with that I likely won’t be able to accomplish what I’d hoped for.
But that’s not an issue with your product, just limitations of the format the data I want to work with comes in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
