403: PERMISSION_DENIED - The caller does not have permission

Getting Started
1

What are you trying to achieve?

Hello guys, i have the same Problem:

It worked for 2 months without any problems. I added the Google Drive module, signed in to my Google Account and it works.
Suddenly, after 2 months I get this error message. Why did it work before and now it doesn’t?
Why is this procedure via the Google Cloud Console necessary now?
Many thanks for the support.

Steps taken so far

I have already reverified the current connection once, but the error still persists.
I have over 100 modules that are connected to this account and do various actions in Google Sheets.
I am afraid that everything will be lost and will have to be redone if I delete this connection and have to set it up again.

Need your help please.

2

If you are using a personal Google account, the following is now mandatory due to changes by Google.

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

1a. Enable the relevant API

Find the relevant API here: Google Cloud console
Go to API page, end click “Enable”

1b. Add the relevant scopes

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

1476×1156 182 KB

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

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

Here are some 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.

488×581 35.4 KB

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 APIs for your custom app.

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. Set up connection (HTTP OAuth, or respective Google App)

A. HTTP OAuth2

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

B. Google App

Insert the GCP app client ID and secret here BEFORE clicking “Sign in”
Gmail example:

525×643 65.1 KB

4

Thank you very much man.
It is really crazy to set up all those things just to be able to Update a Row in Google Sheets.

Just to clarify. I do not have a HTTP Request. I use the Google Sheet Module:
Add a Row

Now, i have Client-ID and Secret-ID. All the Scopes are enabled.
About the redirect URLs i am not sure, if did it right.

Redirect
Redirect830×743 61.5 KB

I have tried to create a new Connection, i type the Client-ID and the Secret-ID and after that i have clicked to Sign in with Google. But i got the error message:
Error 400: redirect_uri_mismatch

And what i have to do to update the current connection?
Without having to change all scenarios and modules again. That is very important.

Connection_Google
Connection_Google824×264 18.4 KB

Maybe verify or Reauthorize again?

or do I have to open all modules and select the new connection?
Will I lose everything I have set up if I change the connection?

Thank you very much for your support

5

Your URLs look correct, so it might be from some other place.

You can manually change the modules to use the new connection, or make a scenario to update all the scenarios to use the new connection.

samliew – request private consultation

Join the Make Fans Discord server to chat with other makers!