Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Google Sheets Tools Input Tool skipping blank rows

8 - Asteroid

I am using the Google Sheets Tool from:!app/Google-Sheets-Tools/5952d212a18e9e0e48a0cafe


However it is skipping the blank rows in the Spreadsheet.


Here is what the spreadsheet looks like:

Screen Shot 2018-07-19 at 4.53.05 PM.png


And here is what Alteryx reads in:

Screen Shot 2018-07-19 at 4.52.51 PM.png


Please advise.

7 - Meteor

Hi Saqib, 


I tested this on my own google sheets, and i think because everything in this line is Null that it just takes it out.  (A bit annoying) 


Although I couldn't find a way to configure the workbook to fix it.

If you put a space in column 1 on your google sheet  It will keep rows as there is a value in the line now.  


Sorry this is only a hack and not an out and out fix. 


I attached a workflow for fixing up that data after the change in the data source.