Google Spreadsheets: when the spreadsheet not found show the service account email address

[arikfr]

When trying to query a Google Spreadsheet and it wasn't found, as part of the message to the user show the service account email address.

Reasoning: many times the user tries to share it with their own email address or just not sure what address to share it with.

The Google Spreadsheet query runner implemented in this module:
https://github.com/getredash/redash/blob/master/redash/query_runner/google_spreadsheets.py

Will need to alter this error message:

redash/redash/query_runner/google_spreadsheets.py

Line 215 in e87efc8

return None, "Spreadsheet ({}) not found. Make sure you used correct id.".format(key)

The service account email address is in the JSON key file.

[adityashrm21]

Can you tell a bit more about how to extract the service account email address through jsonkeyfile? I could not figure it out.

[arikfr]

Sure!

redash/redash/query_runner/google_spreadsheets.py

Line 182 in be377b5

key = json_loads(b64decode(self.configuration['jsonKeyFile']))

^ this is how the key file contents file are being loaded. Then there is a key which is the service account email (I think it's client_email).

[YashJipkate]

Hi @arikfr, Is this issue still up for grabs? I'd like to work on this.
Thanks!

[arikfr]

@YashJipkate thank you, but there are actually two open PRs for this issue. Both need some small changes, but probably there is no need for another implementation 😬

Would you like to work on something else?

[kurianbenoy]

Is this issue still not solved @arikfr ?

[Dyex719]

If this issue is still open, can I work on it?

[arikfr]

@Dyex719 yes, thanks! But check the old pull requests. At this point I don't remember what were the small changes needed, but you can probably get some ideas there.

[robokage]

Hi @arikfr if this issue is still open, I would like to work on it as part of hacktoberfest 2023. So please let me know

[guidopetri]

@robokage sure, feel free to open a PR and tag me on it :)

[robokage]

@robokage sure, feel free to open a PR and tag me on it :)

Great I'll start working on it

[mohammed-anwar404]

hey @arikfr This is my first time participating in Hacktoberfest. I have python as my primary skill and would definitely want to contribute.
Please let me know if this issue can be assigned to me.

[mohammed-anwar404]

Hey, I am new to hactoberfest looking to contribute to my first project. If this is a beginner-friendly issue I would like to contribute with some guidance from your side.