How to connect to Google APIs

Queries and Resources
1

A quick-and-dirty how-to, since this can be tricky!

  1. Generate Oauth2 credentials. You can follow this blog post until you get a hold of you client_id and client_secret
  2. Decide the scopes you want to use. I recommend including https://www.googleapis.com/auth/userinfo.email, and then whatever else you want to use. For example, if you to use a Gmail API, you'll want to include the https://mail.google.com/ scope. see the full list here
  3. Make a REST API resource in retool, and fill out the form like this:

    1672Ă—1612 151 KB


    For your copy-paste convenience:
  • Authorization URL: https://accounts.google.com/o/oauth2/v2/auth
  • Access Token URL: https://www.googleapis.com/oauth2/v4/token
  • Login Test URL: https://www.googleapis.com/oauth2/v1/userinfo
    You can leave the rest of the fields blank (e.g. Base URL, Audience, etc.)
  1. That's it! Now the resource is ready to use. For any app that uses this new google resource, when a user isn't authenticated in presentation mode, they'll see the following auth modal prompting them to authenticate:

    1702Ă—886 39.2 KB

Additional References

1 Like
2

hey ! I’ve created a more up to date guide for generating oauth credentials. https://flowshare.io/flow/how-to-create-oauth2-credentials-for-google

1 Like
5

hey i am not getting this to work, i am getting an error like this {"success":false,"message":"Authentication failure. Missing xsrf token"}

6

@dr-b did you figure out how to fix this?

7

@sindhu Did you include Bearer OAUTH2_TOKEN as a header with the key Authorization?

8

I did but I still see the same XSRF token missing message.

9

Where do you get the error? Are you able to run through the workflow in the “Test Authentication” button at the bottom of the resource setup page?

10

I don't see a Test Authentication button in the resource setup page.

Screenshot 2020-04-09 at 1.47.47 PM
Screenshot 2020-04-09 at 1.47.47 PM1453Ă—317 52.9 KB

I got the Google OAuth client ID used by our IT team as well. Yet I see the above error message.

11

@sindhu Would you mind messaging in on intercom with permission for us to look at your account?

12

Were you able to solve this?
I get the same issue.
It works in the resource screen when I want to authenticate against the google OAuth but when I create an auth button then I also get

{"success":false,"message":"Authentication failure. Missing xsrf token"}

13

Hey @Philipp_Keller1!

Would you mind sharing a screenshot of your resource setup page with any sensitive information redacted? If you rather share it privately you can also feel free to reach out to support@retool.com or send it in a DM.

Curious to know too if this error shows up immediately after refreshing your app and if you've seen any other errors during the testing process :thinking:

14
15

Hi @Kabirdas
Thanks for replying.
I figured it out in the meantime.

My mistake was that I was setting up OAuth for prod in the resource window and it all worked.
Then I was switching to staging, even though OAuth for staging was not configured (IMO that's a bug on retools side, the UI should not have let me switch to staging).
Then when I was on staging and clicked the oauth button I got the message above.

Once I configured the OAuth resource for staging also, then everything worked