...
If query mode is disabled for the spreadsheet, you cannot use write SQL statements to query the spreadsheet. Instead, you need to specify the query data details by filling in the excel sheet. Note that in non-query mode, you can only get data from the sheet and you cannot insert, update or modify any datadata extraction parameters. This also means that, when query mode is disabled, you cannot use the data service to insert, update, or modify data in the spreadsheet. This data service can only be used to get data that is already stored in the spreadsheet.
Follow the steps given below.
...