I am trying to connect a google sheet which has multiple sheets under that which are named as numbers 1,2,3,4,…,300.
I am using a this following query
but it is not working and returns Google API error 400.
Renaming sheets as sheet1, sheet2, and so on and query as sheet1! B1:P213 but didn’t work