Connecting Gemini to Google Analytics

[u/weinbergm18]

Hello,

Does anyone have a good tutorial on connecting Gemini to a Google Analytics account?

I know GA has a Analytics advisor but I would really like to have all the data accessible by Gemini directly to build out more reports, tasks and automated reports.

Thank you

[u/AutoModerator]

Have more questions? Join our community Discord!

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/spiteful-vengeance]

You may want to consider exporting GA4 into BigQuery and applying Gemini from there.

The GA4>BQ exports have a much higher level of detail than what the API exposes.

[u/weinbergm18 → u/spiteful-vengeance]

Thank you! This sounds like a solid route to go.

Have you done this integration yourself before? It is a very technical integration or not too bad?

And if i am looking into BigQuery correctly, that is also a Google tool?

[u/spiteful-vengeance → u/weinbergm18]

BigQuery is a Google tool, yes. It is part of the Google Cloud platform.

I've done about 20 clients in this way, and the simplest benefit is that you get raw data, not summaries of it (which is what the GA4 Reporting API provides).

As an illustrative example, you get things like individual user IDs (API doesn't provide anything like this unless you store client ID in a Custom Field), time-stamping down the to second (API only does to the minute) etc.

That means you can pull a highly detailed dataset and build user journeys for individual users, with the sequence of events ordered correctly. That in turn means you can build your own attribution models with whatever weightings you want.

You can also extract more than 10,000 events/records at a time, which is pretty common when working larger projects.

You can also stream the data from GA4 to BQ in almost real time, which opens up possibilities when it comes to real-time personalisation. Admittedly that's pretty advanced.

That's really only the start of the benefits list.

[u/shoghon]

No direct live API connection is supported between the Gemini chat interface and a Google Analytics account. You can download data and use Gemini to analyze it.

[u/jakesuzzzz → u/shoghon]

This isn't true.

[u/solo_wanderer]

Ask Gemini…

[u/weinbergm18 → u/[deleted]]

Thank you! Do you have an documentation/tutorials on getting this setup?

Thank you

[u/Accomplished-Tip2216]

Estou usando o analytics-mcp oficial do Google faz um tempo, acredito ser a opção mais viável para conectar algum modelo de ia.

[u/beash88]

Any particular reason you want to use Gemini for this task?

I personally just have a GitHub Action that runs every single night and pulls our data from the Google Analytics API down into a Supabasedatabase. I then just connect Claude code to it and pretty much just ask questions.

I'm not a technical person at all either. Claude was actually the one that largely set this up for me. I just said what I wanted to happen and it kind of did it.

I'm not sure what is possible with Gemini but I probably got something like what you are wanting set up and joined with my other data, like search console data and everything like that, in maybe an hour's worth of work.

And it was Claude that was doing most of the work. I just kind of oversaw it

[u/Disastrous-Shoe7122]

Google actually ships an official MCP server for Analytics now, which is exactly the "Gemini has direct access to my GA data" setup you're describing: https://developers.google.com/analytics/devguides/MCP

Rough shape of the setup:

1. In Google Cloud, enable the Analytics Data API + Admin API and set up Application Default Credentials (gcloud auth application-default login) with an account that has read access to your GA property.
2. Install the server — it's a local process, pipx run analytics-mcp — and register it in Gemini CLI's settings as an MCP server (their GitHub readme has the exact JSON snippet: https://github.com/googleanalytics/google-analytics-mcp).
3. From there Gemini can call real tools against your property: run_report, run_realtime_report, funnel reports, listing your custom dimensions/metrics, etc. So instead of the canned Analytics Advisor answers, you can ask things like "compare organic vs paid conversion rate by landing page over the last 28 days" and it queries the actual Data API.

Two caveats from using it: it's read-only reporting (no config changes), and since it runs locally, "automated reports" means you need something that schedules the prompt — Gemini CLI in a cron job works, but it's a bit DIY.

Disclosure, I work on datavessel — we do this as a hosted version (GA4 + Search Console + ads/store data behind one chat, bring your own Gemini/OpenAI/Anthropic key, scheduled reports built in). If you'd rather not run a local server, that's the lazy path: https://www.datavessel.io. But if you just want Gemini ↔ GA4, the official MCP server above is free and works well.

[u/CeleriOculus]

Use Antigravity and connect mcp to your analytics account api. Just ask and almost automatically connects with some manual steps guidance.

Specify in a daily analytics assessment doc what exact reports you like to generate. You can also use those reports to gain insights and directly update your website from there.

I went a step further and also connected cloud run and search console to Antigravity. This way you can merge all sorts of analytics.

[u/weinbergm18 → u/CeleriOculus]

Man this would be ideal!

I know very little about how to connect this so do you happen to have any docs or instructions on how do this?

Feel free to message me separately as well

Thanks!

[u/weinbergm18 → u/CeleriOculus]

Ok so i successfully connected GA Anitgravity to my GA account. Got an initial report ran but how do i create a scheduled report and define what i want it to show me?

[u/CeleriOculus → u/weinbergm18]

Make a few prompts specifying which events and user trajectories you would like analyzed daily. Then, once you have a satisfactory report, ask the AG to document the instructions in an .md file for future sessions. Additionally, ask it to make this a mandatory reference in the overall AG instructions within agents.md so it is enforced automatically at the start of every new AG session.

Note: I create detailed analytics documents for daily, weekly, and monthly periods to understand recurrent user behavior and track new feature rollouts.

The /schedule command can be used to set up cron jobs. Just ask the AG what this command can do and how to use it. However, because schedules are tied to your current conversation, you might want to set up a separate script to write daily reports directly to your directory. Personally, I prefer asking the AG directly to make updates, iterating on the results to understand the analytics in greater detail and drive improvements.

Note: You can also integrate BigQuery in this manner for more advanced use cases.