I want to use Google Spread Sheets as data source in Redash, I followed the instructions available on Redash Website to create service account and JSON file, I’m able to make successful connection.
But now, when I’m trying to write query, it gives an error " spread sheet not found, see below screen shot.
This is my Google Sheet link:
and I’m using UID: 1w4ZYa5KBWPzZ-Zy5dxIRv-6QQTra7rEKT1WnUcJu5SE as what format is mentioned on Redash help center.
Can you please let me know what wrong I’m doing here?