Google Spreadsheet: Invalid Grant Error message

Hi, I successfully created a redash instance for development, with these instructions: https://redash.io/help-onpremise/dev/docker.html

I followed these instructions: https://redash.io/help/queries/query-google-spreadsheets.html for creating a Google Spreadsheet data source. However, I get an “invalid grant” error message when trying to test the connection.

I created a service account and used that JSON file in the connection. I have already shared the spreadsheet with the service account email address (from the JSON file) as mentioned in topic 571.

Thoughts?

I had the same problem. I changed the Google end - there is a use limit unless the user role is set to ‘Service Account User’ you could be oversubscribed on the use.