I am getting this error and my query just does not work, the id is my spreadsheet ID and I would like to know as to how do you query your data after adding through google sheets.

You need two data sources and two queries:

Data Sources

  1. A Google sheets data source
  2. A query results data source (QRDS)

Queries

  1. Use the google sheets data source to fetch a sheet of data into Redash
  2. Use the QRDS to query the data from query_1