I have a Google sheet for testing on which I want to run a query via a http: request using JQuery $.ajax. Works fine until I paste some additional rows. Still works then but when I remove any of the rows above the pasted ones the query returns  for labels instead of the first row of the sheet. This means SQL is not recognising the first row as a header row which means sort by includes the first row. I have other sheets where everything works fine. It just seems pasting fouls things up.The reason for testing like that is that if I do a straightforward paste of say a list into an empty sheet and do the query, labels are always returned as . Any data entered manually gives the expected result of labels=first row.Any ideas?
Google Sheets Labels are returned as empty strings by SQL. Why?
google spreadsheets