Getting HTTP OAuth 2.0 module to work for google analytics (ga4) and universal analytics (ua)

jaco_west · December 22, 2022, 11:03am

Ive added a new api app in GCS for GA4 & UA data connection to make. I granted credentials and added google analytics scope (I used this authorised domain https://www.integromat.com/oauth/cb/google/). I keep getting the following error when trying to connect via the OAuth 2.0 module:

{“message”:“The request failed due to failure of a previous request.”,“code”:“SC424”,“suberrors”:[{“message”:“Account error (invalid_request)”,“name”:“Error”}]}

Ive rechecked all settings and all is in order. Any ideas, please?

Bjorn.drivn · December 22, 2022, 2:27pm

@jaco_west It’s really hard to debug things for these kind of errors on this side of the community
Either you can create a support ticket (since they have access to scenarios) or you hire a Make Expert to solve this.

jaco_west · December 24, 2022, 5:11am

I have raised a support ticket but no solution. Anyone else with a solution please

jaco_west · January 14, 2023, 2:32pm

My connections used to work, now I keep getting this error, any thoughts please:
Code 401: Request had invalid authentication credentials. Expected OAuth 2 access token, login cookie or other valid authentication credential. See Integrating Google Sign-In into your web app | Authentication | Google Developers.

Bjorn.drivn · January 23, 2023, 12:40pm

We really need more information @jaco_west .

What does your scenario look like?
What are you doing to authorize? Are you doing this in Make or somewhere else?
Show screenshots please
What kind of connection have you setup? What are the scopes you’ve added
etc. etc.

jaco_west · January 28, 2023, 2:14pm

Ok sure

Here are some screenshots, the scenario is triggered once per day on a schedule, connects to GA4 via the Make OAuth 2.0 request module
Ive enabled the Google Analytics Data API v1
In GCS Ive created a project, Enabled the above mentioned API with authorised domains integromat.com and make.com and also created an OAuth 2.0 app. The scopes I added was: https://www.googleapis.com/auth/analytics.readonly https://www.googleapis.com/auth/analytics
I created credentials for a web app with the Authorised redirect URI’s of https://www.integromat.com/oauth/cb/oauth2 AND https://www.integromat.com/oauth/cb/google/
The connection works but only for a short period (I assume the token expires). To try and mitigate this I created a service account. That does not work as I cant find a way to add an authorised URI to a service account. This is the Make error:

Error 400: redirect_uri_mismatch

You can’t sign in to this app because it doesn’t comply with Google’s OAuth 2.0 policy.

If you’re the app developer, register the redirect URI in the Google Cloud Console.

Request details: redirect_uri=https://www.integromat.com/oauth/cb/oauth2

Any ideas please? I’m truly stuck

jaco_west · January 29, 2023, 8:19am

I have to get offline access, & would therefore require a refresh token which I would store to use again and again, as the normal token expires within 1 hour. Ive not been able to set that up correctly, any assistance would be greatly appreciated