Failed to verify connection 'My Google connection'

[Make_Money]

Hello, I have a script error with google sheets - watch new rows 3 days after automation
19:41
Cannot initialize the scenario because of the reason ‘Failed to verify connection ‘My Google connection’. Account error (invalid_grant)’
19:41

• Failed to verify connection ‘My Google connection’. Account error (invalid_grant)
  19:41
  Scenario initialization failed with an error.

I saw this article where this problem is solved - Google Authentication issue: Status Code Error 400 - #13 by Bjorn.drivn

Gave the answer - @Bjorn.drivn, but I would like to clarify if I did it right, because in google the console has changed. so I wanted to clarify this point so I can do it right away.

1. Go to https://console.cloud.google.com/welcome

2. Created a new project Make Integration.

3. Connect Gmail API

4. Click OAuth Consent Screen

5. Clicked Get Started

6. Follow photos 1 through 5 inclusive:
   

   
   
   
   
   
   
   
   
   
   
   
   
   

7. Entered everything as on the photo https://www.integromat.com/oauth/cb/google-restricted

8. Enter domains - make.com integromat.com
   

   
   
   
   

9. Click Publish App

or did you only have to do these steps?

1. Go to https://console.cloud.google.com/welcome
2. Created a new Make Integration project.
3. Clicked OAuth Consent Screen.
4. Click Get Started.
5. Follow photos 1 through 5 inclusive.
6. Click Publish App.

[momomomonmon]

@Make_Money
Hi, Perhaps you should look at the Help Center below.
https://www.make.com/en/help/apps/productivity/google-sheets#create-and-configure-a-google-cloud-platform-project-for-google-sheets

I compared the screenshots you posted with the Help Center and there seem to be some differences.

Configure your OAuth consent screen for Google Sheets

11. In the Data Access section, click Add or remove scopes, add the following scopes: > 11.
    https://www.googleapis.com/auth/spreadsheets
    https://www.googleapis.com/auth/drive

Create your Google Sheets client credentials

5. In the Authorized redirect URIs section, click + Add URI and enter the following redirect URI
   https://www.integromat.com/oauth/cb/google/

I’m not sure what the correct Redirect URI is, but the following answer may be helpful.

Submitting URLs to Google Indexing API

1. Enable the API Direct Link: Google Cloud console [Screenshot_2024-01-23_090101] 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 [Screenshot_2024-01-23_100157] Here are all the known redirect URIs you need for your Google Cloud Console OAuth app. If you set these…

[Make_Money]

Hi @momomomonmon! Thank you for your reply! I am very grateful for your help!
I took additional steps on my google account to the existing configurations earlier:

1. I changed the project name to Make.
   

   

2. Opened the left navigation menu and gone to APIs & Services > Library. Found out for the following APIs: Google Sheets API and Google Drive API. Clicked the relevant API, then click Enable. “If you see the Manage button instead of the Enable button, you can proceed to the next step: the API is already enabled.”
   

   
   
   
   

3. Changed App Name to Make
   

   

4. In Google Auth Platforms in the Clients, under Authorized redirect URIs add these URIs:

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.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

5. In the Data Access section, I clicked Add or remove scopes, add the following scopes:
   https://www.googleapis.com/auth/spreadsheets
   https://www.googleapis.com/auth/drive
   
   

! But after step 5, a window has now appeared - “Your app requires verification. When you have finished configuring your information, please submit your app for review.”

Question: For to avoid weekly reauthorization I need to verify these moments?

[momomomonmon]

@Make_Money

Question : For to avoid weekly reauthorization I need to verify these moments?

I think you should run Verification because the make help center note states that if it is verified, it will not be reauthenticated.
Ref: make help center - Note about Publishing Status

However, I see a lot of posts about re-verification, so I don’t know if this can be resolved.
There are a couple of older posts that say you will be asked to re-verify, but I’ll post them for your reference.

• HTTP OAuth2 Module - How to get Refresh Token for Google APIs
• Google Authentication issue: Status Code Error 400

[samliew]

@Make_Money

“Your app requires verification. When you have finished configuring your information, please submit your app for review.”

You can ignore this message, it is just a warning and NOT an error. You do not need to “Submit for Verification” as you are using it privately.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.