Skip to main content
Best answer

Aligning data across columns from e-mail attachment


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

@abgstv 

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.

 

View original
Did this topic help you find an answer to your question?

6 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@abgstv 

Issue may be related to how the original file is formatted.

Is it an XLS or a CSV?

  • It needs to be a flat file with headers/rows.
  • No grouped rows/columns
  • No gap rows/columns

 

Otherwise, more advanced approaches have to be used to first prep the file data.


  • Author
  • New
  • 3 replies
  • March 13, 2025
Troy Tessalone wrote:

Hi ​@abgstv 

Issue may be related to how the original file is formatted.

Is it an XLS or a CSV?

  • It needs to be a flat file with headers/rows.
  • No grouped rows/columns
  • No gap rows/columns

 

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. 


Troy Tessalone
Forum|alt.badge.img+14

@abgstv 

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.

 


  • Author
  • New
  • 3 replies
  • March 13, 2025
Troy Tessalone wrote:

@abgstv 

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. 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31142 replies
  • Answer
  • March 13, 2025

@abgstv 

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.

 


  • Author
  • New
  • 3 replies
  • March 14, 2025

Looks like I need to look into other options. 

Thanks for the support 


Reply