You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "hawkz (via GitHub)" <gi...@apache.org> on 2025/09/23 10:09:16 UTC
Re: [I] [Gsheets/shillelagh] Unable to add privately shared sheets [superset]
hawkz commented on issue #21152:
URL: https://github.com/apache/superset/issues/21152#issuecomment-3323293870
I believe I've solved this for my connection attempt.. wanted to share the steps that worked for me.
1. Go to databases → + Database
2. Give the display name you want and the SQL URI: `gsheets://`
3. Setup a service account in cloud console, making sure you've got drive and sheets APIs enabled.
4. Invite the service account email to have view access to your sheet.
5. Upload the service credentials into the database advanced tab BUT edit them first to add `{"service_account_info": `before the Google downloaded JSON and `}` after.
6. Make SURE that the sheet is free of formulas or content that'll confuse it. (I had a `=now()` that threw me for a while)
7. Go to SQL lab, and query for your sheet in the `SELECT * FROM "https://docs.google.com/spreadsheets/d/1IZgjkXXX6YI/edit?gid=0#gid=0"` format (the gids are copied from the URL as I view the right tab/sheet in the google sheet workbook.
Should then let you query and start doing fun stuff.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org