OMG - 4 hrs and i cannot connect to googlesheets

Getting Started
, , ,
1

OMG i am beyond frustrated i cannot even get this to hook up to google sheets - i got google drive to work but for some reason it doesn t work for google sheets AASHDLIFJLSDJFLKSDJFL:JSEOIFJO{SDJFVOISJDOFI
I have been at this for 4 hours please anyone help omg
I followed this 3x times
https://www.make.com/en/help/app/google-sheets

here is the error

image
image1271×571 20.3 KB

3

Webhooks are taking forever to accept data structures. Maybe Make is experiencing technical issues?

4

Welcome to the Make community!

1. Enable the API

Direct Link: Google Cloud console

2. Insert all the known Google Redirect URIs for your app

Direct Link: https://console.cloud.google.com/apis/credentials

How to create an OAuth app in GCP: https://www.make.com/en/help/tutorials/calling-google-apis-via-the--http-make-a-oauth-2-0-request--module ← FOLLOW THIS

505×537 31 KB

Here are all the known redirect URIs you need for your Google Cloud Console OAuth app. If you set these up, you can reuse the same GCP app for other Google apps and modules on Make.

https://www.make.com/oauth/cb/oauth2
https://www.make.com/oauth/cb/google-custom
https://www.make.com/oauth/cb/google-restricted
https://www.make.com/oauth/cb/google-cloud-speech
https://www.make.com/oauth/cb/google-analytics-4
https://www.integromat.com/oauth/cb/oauth2
https://www.integromat.com/oauth/cb/google-custom
https://www.integromat.com/oauth/cb/google-restricted
https://www.integromat.com/oauth/cb/google-cloud-speech
https://www.integromat.com/oauth/cb/google-analytics-4

Once you’ve set these up, you can use/reuse the same Make connection for all the supported Google apps & modules on Make - you’ll only have to enable the respective APIs for your custom app in Google Cloud.

3. Publish your GCP OAuth2 app

Direct Link: https://console.cloud.google.com/apis/credentials/consent

You might need to set your OAuth application to “Production”, otherwise the credentials expire very frequently.

1. To do this, go to menu item “OAuth consent screen”

or click here https://console.cloud.google.com/apis/credentials/consent

575×505 33.6 KB

2. Then click the button below if the Publishing status is not “In production”

1002×683 45.6 KB

4. Configure the HTTP OAuth2 module

You need a “Authorize parameters” key of redirect_uri with the above Make OAuth2 callback URL.

597×904 61.2 KB

You can find the Client ID and Client Secret in the OAuth2 app you created in GCP, on the right-hand side of where you inserted the 8 callback URLs in step 2:

708×401 44.2 KB

2 Likes
5

Thank you SOOO much - I finally got it to work. Had to try 7 times (and now i have 7 connections to choose from) It was that for some reason the scope was different on discord bot side vs the maker side (or something IDK wow)

I am building this example as what we can do for the organization reserve.org - I have even made a video showing the automation at work (when it is done Ill post it into ‘Showcase’)

1 Like
6

You can delete the extra connections on the connections page so you don’t get confused in future.

2 Likes