I can connect to google drive, see a list of sheets, and select the one I want.
When why I run the query I get "Cannot convert undefined or null to object" and can't find anymore information to go on. I have tried creating a new very simple sheet with just a few numbers in a few cells and get the same error.
Hi @guyf, could you share a screenshot of how you're setting this query or resource up? Having some additional information can help us better understand how to help 
.