I’m receiving a spreadsheet that I’m pulling from a Google Email. When I try to run the original xlsx file it only populates 50 of the 300+ rows in the spreadsheet as output. I can manually open the spreadsheet and make 1 change to one item in the spreadsheet and save and send from myself and it sees all rows in the spreadsheet.
Is there something I can add to make the flow read all rows of the spreadsheet without doing all of the manual side stuff? I’m unfortunately unable to share the spreadsheet as well as it contains sensitive information.
That is very strange I can’t think of a reason as to why changing one bit of data and sending it again would change how the node reads it. What is the format of the spreadsheet?
I currently receive it as xlsx. I know there is some commenting on columns in the spreadsheet, there may be more formatting in the spreadsheet as well. All the data is there, I can go the gmail node output and download the file and its the entire 300+ records. (Screenshot says attachment_0 my example above has attachment_7 thats just me receiving from vendor vs downloading and sending myself)
It seems like any change I make and save it just starts working right. Another thing I noticed on the spreadsheet is there are columns hidden A-C. I’m going to attempt to have our vendor send in a less formatted sheet and revisit if that doesn’t resolve.
@Jon So I spoke to my vendor they are unable to change the format. I think they have something that automatically exports the spreadsheet. I think they are using something like Microsoft Dynamics. Is there a way in n8n to pull the spreadsheet raw that ignores hidden columns and any of the other special formatting that could possibly causing this issue?
I also found this stack overflow that details what I suspect could be causing issue with the n8n node. The export that in this persons screen shot has the same first three columns as the type of output I’m trying to work with. MS Dynamics CRM 365 - import data from Excel files - Stack Overflow
