Weekly GA4 channel report in Google Sheets
Every Monday, add last week's sessions, users and key events for each GA4 channel to a running history tab in your sheet.
Letaido's Google Analytics integration gives an AI agent your GA4 reports, so the numbers land in your sheet, Slack or Notion every week.
GA4 jobs, checked step by step. Open one to watch it run.
Every Monday, add last week's sessions, users and key events for each GA4 channel to a running history tab in your sheet.
Every Monday, post last week's GA4 sessions, top channels and top pages to Slack, each compared with the week before.
Ask why traffic fell and the agent compares two weeks in GA4 by channel and landing page, then tells you where the loss came from.
Every Monday, write each published post's last 28 days of GA4 views, engaged sessions and key events to its row in Notion.
Every month, find pages that win GA4 key events but rank in positions 5 to 20 in Ahrefs, and list them for a refresh.
Every Monday, compare last week's GA4 purchases and revenue with paid Shopify orders and post the gap to Slack, so broken tracking gets caught.
Six ways to get GA4 data into the rest of your work.
| Option | Set up by asking | Writes the summary | Runs on its own | No code | Works across your apps |
|---|---|---|---|---|---|
| Yes | Yes | Yes | Yes | Yes | |
| Google Analytics product links | No | No | Yes | Yes | Partly |
| GA4 custom insights | No | Partly | Yes | Yes | No |
| Zapier, Make and similar | Partly | No | Yes | Yes | Yes |
| GA4 Data and Admin APIs | No | No | Partly | No | Partly |
| Google Analytics MCP server | Yes | Yes | Partly | Partly | No |
| Option | How it works | Best for | Watch out for |
|---|---|---|---|
| Letaido AI agent | You describe the job. The agent runs the GA4 reports it needs, reads the numbers and writes the result to 64 other apps. | Weekly summaries, sheet history and checks that need a judgement call. | 65 apps, not thousands. GA4 can't start a job, so jobs run on a schedule or when you ask. |
| Google Analytics product links | Links you set in GA4 Admin to Google Ads, Search Console, BigQuery and other Google products. | Sharing conversions and audiences with Google Ads, or seeing Search Console queries inside GA4. | Google products only. They move data; they don't write anything up for you. |
| GA4 custom insights | Rules you set in GA4, such as a 20% drop in active users, checked hourly, daily, weekly or monthly, with optional email alerts. | Being told inside GA4 when a number crosses a line. | Up to 50 per property. The alert stays in GA4 or your inbox. |
| Zapier, Make and similar | Workflows built from GA4 steps, such as a new conversion event trigger or a run report action. | Fixed handoffs, like a sheet row for every new conversion event. | You build and fix one workflow per job. |
| GA4 Data and Admin APIs | Developers call the Data API for reports and the Admin API for settings, from their own code. | In-house dashboards and tools with exact needs. | Needs developers and quota care: about 10 requests at a time per property. |
| Google Analytics MCP server | Google's open source server that you run on your own computer, so an AI client such as Gemini CLI can run GA4 reports. | Asking questions about your traffic in a chat. | Read only, and you install and run it yourself. Scheduling depends on your AI client. |
Connect Google Analytics 4 once. After that, you describe each job in plain English.
Allow all read operations once per app; approve each kind of write once.
Save it to run every Monday.
A schedule starts the job, or you do by asking.
If the connect card shows Connect with Google Analytics, sign in and approve. Otherwise use your own OAuth client: a Google Cloud project with the Data and Admin APIs on, its client id and secret, and a refresh token.
The Google account you connect needs at least the Viewer role on each GA4 property. Settings changes need the Editor role and the edit scope.
Use the numeric property id, like 123456789, in the job. A G- measurement id points to a data stream, not a property.
Allow all read operations once per app; approve each kind of write once. Then save it to repeat.
25 actions in 9 groups, from standard reports to key events and custom dimensions.
If the connect card shows Connect with Google Analytics, sign in and approve. Otherwise connect your own OAuth client with the Data and Admin APIs on. Set its consent screen to In production or Internal, because Testing tokens expire after 7 days.
The one you name by its numeric property id, like 123456789. The connected Google account needs at least the Viewer role on it. A G- measurement id is a data stream, not a property.
Yes. Google publishes an open source, read only server that you run on your own computer for an AI client such as Gemini CLI. Letaido is not an MCP server. It has its own Google Analytics connector and runs jobs on a schedule across 64 other apps.
Letaido is its own AI agent, so there is nothing to wire into ChatGPT. Connect GA4 to Letaido and ask in the chat, or save the job to run every week.
No. GA4 can't send Letaido an event, so jobs run on a schedule, like the Monday summary, or when you ask.
With the Editor role and the edit scope, it can update property settings, create or delete data streams and key events, and register or archive custom dimensions and metrics. None of the jobs above changes GA4. Allow all read operations once per app; approve each kind of write once.
Custom insights flag a change inside GA4 or by email. Letaido reads the numbers, explains what moved and writes it where your team works, like Slack or a Notion page.
Connect Google Analytics 4, then ask for a job like "Log weekly GA4 channel results in Google Sheets". Leta gets it done on your schedule, or the moment you ask.
Get LetaidoPull traffic overviews, top pages, traffic sources, and events reports across any date range.
Build and run generic, pivot, and realtime reports with any dimensions, metrics, filters, and date ranges.
Verify which dimensions and metrics can be combined in a single report before running it.
List, view, and update GA4 property settings such as display name, time zone, currency, and industry.
Create, list, and permanently delete web data streams on a GA4 property.
Mark events as key events, list existing conversions, and delete conversion definitions from a GA4 property.
Create, list, and archive custom dimensions on a GA4 property.
Create, list, and archive custom metrics on a GA4 property.
Send raw API requests to any GA4 Admin or Data endpoint not covered by other actions.