MAKE / GOOGLE DOCS & GOOGLE DRIVE : Error 400 : redirect_uri_mismatch

[CHARBIT]

What are you trying to achieve?

For more than a year my connection between MAKE and GOOGLE (Google Drive API and Google Docs API) was working perfectly.

Now, for a mysterious reason, nothing is working anymore. I spent the last 72 hours trying to understand the issue, searching in many forums, including here of course, testing one by one all the existing solutions, in vain. So I’m pretty desperate and, as I tried and retried, I don’t see what I’m missing!

Steps taken so far

The config is pretty basic:

I followed the MAKE documentation step by step: https://www.make.com/en/help/app/google-docs#create-and-configure-a-google-cloud-console-project-for-google-docs.

In my Google Console I created a new project with 2 activated APIs: Google Drive API, Google Docs API.

In the Oauth consent screen:

• I chose MAKE / External / Test mode with Test users.
• I have the 2 authorized domains: make.com, integromat.com
• 4 Scopes added: auth/userinfo.email, auth/documents, auth/drive, auth/docs as it is explained in the MAKE documentation (adding more scopes doesn’t solve the issue).

In the Credentials:

• I created 1 OAuth 2.0 client ID.
• In the Authorized redirect URIs I added: https://www.integromat.com/oauth/cb/google, again as explained in the documentation (I red here and there that I had to add more URIs, like google-restricted, google-custom, oauth2, with make/integromat domains. I tested this, it doesn’t solve the problem).

In MAKE:

• I have a Google Docs module “Create a Document from a Template”.
• I created a connection, filling the advanced settings with my Client ID and Client Secret from my Credentials.

Now when I click on “Sign in with Google”:

• I get from Google an error message: “Error 400 : redirect_uri_mismatch” (see capture).
• Clicking on error details shows: redirect_uri=https://www.integromat.com/oauth/cb/google/ flowName=GeneralOAuthFlow (see capture).
• Finally in MAKE the error shows as: “No access token specified” (see capture).

What am I doing wrong here? Why these simple settings worked just fine during months and now everything’s messed up?

Thanks a lot for your help! All the work I did since almost two years on Smartsuite/Google Docs automations via MAKE is on total standby…

All the best to you guys.

Tom

Screenshots: scenario setup, module configuration, errors

[Fario_Consulting]

Hi,
Could you make sure that the scenario is actually receiving data when it needs to.
Check your filters and see if they’re set up correctly by looking at the history and clicking on any filter icons showing ‘0’.

[CHARBIT]

@Fario_Consulting hi and thank you for your help! For the needs of the test I simplified the scenario to the max. The first module is Smartsuite with its working connection receiving the data seamlessly. The second is Google Docs ‘Create a Document from a Template’. No filters between the two. To make this work (as it worked before during almost two years) I just need to Create a connection, and I’m stuck there! The problem seems to come from Google, but I don’t see why.

[CHARBIT]

Hi there, for those who face the same problem I finally found what’s wrong. In MAKE, when creating the Google Connection, don’t fill the Client ID and Client Secret (Advanced Settings) you previously generated in your Google Console. The Make documentation says: “You will use these values in the Client ID and Client Secret fields in Make.”, which is the reason why I filled those 2 fields. But in my case, it messes all up. I feel all of this it’s far beyond my understanding of all these parameters…