I've got a solution from a colleague:
So you can load data from a Google Spreadsheet provided that the sharing settings of that spreadsheet are set to Anyone With the Link Can View, which means the data is semi-public, if you like.
However, Google Sheets will only allow you to load 100 rows max. Same if you do an Excel web query on the Google Sheet.
To get around this you need to either:
1. Publish the Google Sheet and use the new link to load the data in with (but you might not want to publish your spreadsheet)
2. Amend the link to the spreadsheet to include a tqx=out:html parameter e.g.
This is the normal link for the spreadsheet (in this case just some test data with more than 100 rows that I created)
Amend it to
So you need to take the bit from the first link that is highlighted in bold and add 2 bits before and after it to make a new link that QlikView can cope with. I'm not sure how or why this works (a genius colleague of mine came up with the solution) but it does!
If you need your data to be completely private then there is a 3rd party plug in that you can buy - see other posts on this forum.