What it is.
The workflow retrieves the last 7 days from Google Analytics across several domains, Google Ads, and Meta Ads, plus the same period a year earlier. An AI node builds the table, reads it, and writes a summary.
The full summary goes out by email and a shortened one to Telegram. A week-on-week report tells you about last week's weather, while the same week last year tells you whether the channel is growing.
What you get.
- One table covering Google Analytics, Google Ads, and Meta Ads for the same window.
- A year-over-year comparison in that same table.
- A written summary from an AI node, so the email has words as well as numbers.
- A short version pushed to Telegram for a phone.
- Multi-domain Analytics support, which matters if you run more than one property.
How to set it up.
Connect the Google Analytics API, the Google Ads API, and the Facebook Graph API; all three need their own credentials.
List your Analytics property IDs in the node that loops over domains.
Set the SMTP credential and the recipient, and add a Telegram bot token if you want the short version.
Check the date ranges, since the template uses the last 7 days plus the matching week a year earlier.
Edit the AI prompt so the summary answers the question your team asks on Monday.
Schedule it for the morning of your weekly review and run it once by hand first.
Use cases
One window, three sources
Pull analytics and both ad platforms for the same dates into a single table.
Year-over-year without the manual pull
Let it compute the comparison nobody gets round to doing.
Send it before the meeting
Schedule the run so the table lands ahead of the review.
Best for
A weekly marketing standup
One email with three channels and a year-over-year read is most of the meeting.
Founders without an analyst
The summary comes written, so nobody has to interpret a dashboard before the meeting.
Multi-domain setups
It loops over Analytics properties, so a company with several sites gets one report.