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. 

​@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.

​@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. 

​@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.

Looks like I need to look into other options. 

Thanks for the support 

Hi ​@abgstv,
 
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. 

Hi ​@abgstv,

I appreciate your understanding and am glad the insights helped clarify the situation! While the current data format may present challenges, depending on your use case, creative workarounds might still be possible.

Feel free to ask if you're having trouble setting this up or have further questions, or contact our Zapier support team for additional assistance.

I’m open to ideas. 
The main issue seems to be getting the report into a format that can be injested corrected. 
I can’t change the format of how the report is delivered and I, for the most part, only have access to Office 365 Suite so no google suite options will work. This is for work so everything has to work with what I’ve got.