Trying to setup a Google Spreadsheet data source. First used an existing client_secret.json that has a service account that already has access to the sheet and is functioning with highcharts. Kept getting spreadsheet not found error. Confirmed the sheet was shared with the service account email address.
I then setup a new service account following the instructions provided, shared the spreadsheet with that service account. Still get the “not found” error. The spreadsheet is in a Team Drive so I went to the root of the team drive and gave the service account view access there.
When “testing” the connection with the json file, both work.
The query I’m running is as stated in the doc, sheet ID [PIPE] sheet #
I’m clueless as to what the problem could be… please help!
- Redash Version: 5.0.2+b5486
- Browser/OS: Chrome 73.0.3683.86
- How did you install Redash: Install today using AMI linked from Redash site.