OAuth2.0 with Google Sheets

App Building
, , ,
1

Hi,

I am attempting to set up the Google Rest API for Google Sheets and am having some errors.

I created the credentials in the Console, but each time I try to authenticate I get this error:

Screen Shot 2022-08-09 at 12.20.50 PM
Screen Shot 2022-08-09 at 12.20.50 PM932×1368 88.6 KB

Here's the entry in Console
Screen Shot 2022-08-09 at 12.22.40 PM
Screen Shot 2022-08-09 at 12.22.40 PM1068×1224 72.3 KB

Here is the resource:
Screen Shot 2022-08-09 at 12.23.31 PM
Screen Shot 2022-08-09 at 12.23.31 PM1964×1352 198 KB

Screen Shot 2022-08-09 at 12.23.39 PM
Screen Shot 2022-08-09 at 12.23.39 PM1960×1236 183 KB

I followed the guides but am unsure of what I am doing wrong.

2

Hey @Matthew,

Your redirect URIs shouldn't be the sheets.googleapis.com callback, it should be the retool one you can see when setting up an REST API resource in Retool. So you should be using this:
https://oauth.retool.com/oauth/user/oauthcallback

Your Authorized JavaScript origins should be your: https://{org_name_here}.retool.com