StacksGPT
Research & Analysis

Weekly Google Analytics Report by Email and Telegram

Each week, compare the last seven days of Google Analytics data with the same days last year and send an AI-written report by email and Telegram.

The Problem

Opening analytics dashboards every week and writing up what changed is easy to skip, so stakeholders go without a regular view of traffic.

How This Template Solves It

A marketing lead gets a report on Monday morning. The workflow pulls key metrics, compares them with the same week last year, has AI build a table with percentage changes and a short analysis, emails it, and sends a shorter version to Telegram.

How It Works

  1. 1A schedule trigger starts the run each week.
  2. 2Fetches and summarizes the last seven days of Google Analytics data.
  3. 3Fetches and summarizes the same seven days from the previous year.
  4. 4OpenAI builds a table of the changes with a brief analysis.
  5. 5Sends the report by email and a shorter text version to Telegram.

What You Need

  • A Google Analytics property with API access
  • An OpenAI API key
  • An SMTP email account
  • A Telegram bot, optional

What Stays Under Your Control

  • People decide what to do based on the report.

Watch Out For

  • Some node names in the template are in German. Rename them if that helps your team.
  • A year on year comparison needs a property that already has data from last year.

Step-by-Step Blueprint

This template is the starting point for a full guide with setup steps and prompts:

Adapted from a community workflow template. Before publishing we removed credentials, account and file IDs, email addresses and sample data. The original author's setup notes are kept inside the workflow file.

More Research & Analysis Templates