Metabase Google Auth Login

mhahndesign commented 2 years ago

This is a great script! How would we setup the script to login to our Metabase account if we use Google authorization for login?

pedromfarantes commented 2 years ago

I have the same problem...

giorgossaman commented 1 year ago

I have the same problem. I would like to use this script with Google SSO. Any ideas?

neozenith commented 1 year ago

I have tweaked a version of this code to get Google SSO working in our organisation and it is a bit of a hack for now.

https://github.com/neozenith/metabase-google-sheets-add-on/commit/eb9908094e60345d7d52928c41445f9a7c90e192

Log into Metabase in another tab using your Google SSO
Open up the browser Developer Tools and look for Cookies
If using Chrome Developer Tools, this is in Application > Storage > Cookies
Under the domain for your Metebase instance look for the key metabase.SESSION and copy that value
Using the code linked above, there is a new menu item Set Session to explicitly set this value
Your requests for Import Question and Import All Questions should now work until that session ID expires which according to the JWT I interecepted seems like it was 3 hours.

It looked like Google Identity sends the JWT back to auth/sso/google/session on your metebase API which creates a valid Session ID. So the JWT is never stored locally in the browser.

bplmp / metabase-google-sheets-add-on

Metabase Google Auth Login #5