Google account Service In Bubble

[jpma]

Hello,

I would like to allow my users to access my Google sheets (in embed) and Google drive (also in embed) from my bubble application.
My users don’t necessarily have a google account and shouldn’t be able to access them outside.

I think the solution is to use a service account but I can’t manage this setting. Do you think the solution is possible?

thanks

[Jici]

Yes it’s possible using the JWT auth. What did you set?

[jpma]

yes i have tried several methods i think i am doing it wrong. i wonder if my setting on the google console is right.
Can you give me a tutorial or explain it to me?
Thanks a lot

[Jici]

Did you read this?

How to Guide: Create a JWT for Google Service Account

I spent over a week trying to create a JWT for a Google Service Account. I already documented the answer on Stack Overflow, but I wanted to post it here as well for anyone who has similar issues. I’m working on a free plugin to handle this and I’ll update when it’s completed. In the mean time, the instructions are here:

[jpma]

Yes, thanks, but the inidiate link doesn’t work.

https://stackoverflow.com/questions/65114992/authenticate-a-google-service-account-in-javascript/65115010#65115010

[Jici]

I have commented with a screenshot here:

Bubble JWT (JSON Web Token) authentication is wrong

Because there’s too many difference on how JWT is used in API. In some case, you will not use the Bubble native JWT process. Two example: Zoom have JWT token. You don’t need to use that in JWT auth in Bubble because the JWT token is provided as a bearer api key. So you call endpoint directly with the JWT. In Google, the JWT provided need to be used in Bubble JWT Auth. It will look like this: [screenshot-bubble.io-2021.04.15-09_38_48] The best thing you can do is to share the API doc url an…

Maybe it can help you

[nicholasrbarrow]

Try this: Google Service Account Plugin - Bubble Plugins