Querying G Sheets: **unknown error occurred.**


#1

Hey guys, I set up my G Sheet connection with this tutorial.

https://redash.io/help/data-sources/querying/google-spreadsheet

Everything worked fine, including creating a google service account, sharing the shees with it and testing the connection (it showed success). If I, however try to Query the G-Sheet with its ID the interface gives me:

Error running query: unknown error occurred. Please try again later.

Has anyone setup G Sheets as a data source before and seen this problem?

Thanks in advance,
Marius


#2

Have you confirmed that you have shared the sheet with your Google Service account email address?


#3

Yes I did, thanks for the hint though :slight_smile:


#4

Thanks, topic is done. Redash itself wasnt setup correctly :slight_smile:


#5

Good to hear it. Would you mind sharing what was incorrectly setup so other’s can reference it later? I’m curious to hear myself :slight_smile: