How do I use Google Analytics resource for GA4?

Queries and Resources
1

I'm trying to pull Google analytics data into retool, specifically from a GA4 profile. I understand that to do that it requires the data v1 API. It's also my understanding that we need the enterprise version of retool for this. As we have access to retool spaces, I believe we have enterprise.

What I can't work out is how to do it. I created the google credentials and created a google analytics resource that works correctly, but the resource itself only shows analytics v3 and reporting v4. I can't find another resource for the data API, and after hours of looking I'm stumped as to what I'm supposed to do.

Thanks

2

Hello @Sam_Matthews!

I just double checked your account and you are on the enterprise plan!

Here are our docs on setting up a Google Analytics Resource in Retool.

What step of this process are you having issues? What data can you get and what is the data you are looking to get? I had no idea someone could get different versions for analytics and reporting :sweat_smile:

Our docs also includes a link to Google's official docs on how to use GA. Hopefully those can provide more information on the API to query what you need once you set up the resource.

3

Have you managed to solve this? I have the same

4

Hello @Carlos_Hidalgo,

Were you able to set up the GA resource or is that the step of setup you are currently on?

I was going to ask @Sam_Matthews if their resource is created and working successfully, where the disconnect is.

If they can share a screenshot of a query to the GA resource and where it shows analytics v3/reporting v4 so I can better understand what they are missing from the resource to help :crossed_fingers:

5

Hi @Jack_T ,
Sure, here is the screenshot:
image
And the response is: { "error": { "code": 403, "message": "User does not have sufficient permissions for this profile.", "errors": [ { "message": "User does not have sufficient permissions for this profile.", "domain": "global", "reason": "insufficientPermissions" } ] } }
I asked Google Analytics Team, and they answered me: "if your application needs to access data in a Google Analytics 4 property, it is necessary to update the code to use the Data API v1" plus obselete links (1 and 2 )

Paulo, from Retool Team too, told me that you dont have the option for Data v1 yet, correct? Do you know where (aprox) it will be?

6

Ah ok thank you for the explanation @Carlos_Hidalgo,

I am not sure when we will have the Data API v1, but I will update this post if i hear anything from our eng team.

In terms of the permission error that is coming from the Google account side of things to enable requests to come for your app/account/retool.

That is a bummer they gave you obsolete links, Google changes their APIs a lot and it is hard for us to keep up :smiling_face_with_tear:

7

I've read that it's necessary to setup a Google Workspace account to allow Retool access to the GA4 property is this correct? There is nothing about in the Docs. When I click "Connect with OAuth" and choose an account I want to connect with I always end up with getting the "App blocked" screen.

Are there other options to connect to GA? Thanks in advance

8

Hello @MLindenhofer,

It is not strictly necessary to set up a Google Workspace account to allow Retool access to a GA4 (Google Analytics 4) property.

However, you do need to ensure that Retool has proper access to the GA4 property through the Google Analytics API. But I am curious, did you read in the forums or in our docs that setting up a Google Workspace is necessary?

These are the steps for setting up GA4 with Retool:

  1. Service Account:
  • Create a Google Cloud Platform (GCP) project if you don’t already have one.
  • Enable the Google Analytics Admin and Reporting APIs in your GCP project.
  • Create a service account in the GCP project and generate a JSON key for it.
  1. Grant Access to the Service Account:
  • Add the service account email (e.g., your-service-account@your-project.iam.gserviceaccount.com) as a user with appropriate permissions (like Viewer or Editor) to your GA4 property in the Google Analytics Admin settings.
  1. Connect Retool:
  • Upload the JSON key to Retool when configuring your resource.
  • Use Retool’s Google APIs integration or a custom REST/GraphQL API to query the GA4 data.
9

Hi @Jack_T,

But I am curious, did you read in the forums or in our docs that setting up a Google Workspace is necessary?
No - elsewhere

I've set up the service account and tried to connect it within a REST-API Ressource with "Google Service Account" as Authentication (with the OAuth I get a redirect uri mismatch error) - but I still can't connect to GA4. Is there a problem with the connection to the new v1 beta API?

10

Hi @MLindenhofer,

That is odd that you were getting a redirect mismatch error. I would say double check the URLs in the auth flow.

What is the error you are getting when you try to connect with a REST API resource? Can you share a screenshot of the error?

I don't think there is any issue with the new v1 beta but it seems this is a fairly new release for google, so I would say test out using GA4 with the non-beta API option as that has worked for other users.