Back to Templates

Auto-Analyze Google Analytics Data with Gemini AI & Smart Gmail/Telegram Routing

Created by

Created by: Rully Saputra || rullysaputra15

Rully Saputra

Last update

Last update a day ago

Share


Who’s it for

This workflow is ideal for marketing teams, growth analysts, and business owners who need regular Google Analytics insights without manually digging through data. It’s also perfect for organizations that want to ensure positive performance updates reach stakeholders quickly while negative trends get immediate attention from the internal team.

How it works / What it does

The workflow runs weekly on a set schedule, pulls key performance metrics from Google Analytics, and aggregates the data into a clean summary.
An AI Agent (powered by Google Gemini and connected to Simple Memory for historical context) analyzes the data, generates actionable insights, and classifies the sentiment as Positive, Negative, or Neutral.

  • Positive sentiment → Automatically emailed to stakeholders via Gmail.
  • Negative sentiment → Sent instantly to a designated Telegram group for faster response.

This ensures wins are celebrated, and issues are addressed promptly.

How to set up

  • Configure the Schedule Trigger for your preferred reporting day/time.
  • Connect the Google Analytics node with your property ID and metrics/dimensions.
  • Set up the AI Agent with Google Gemini/others model API credentials.
  • Connect Gmail and Telegram accounts to their respective nodes.
  • Adjust sentiment routing rules.

Requirements

  • Google Analytics account with API access
  • Google Gemini API key
  • Gmail account with OAuth connection
  • Telegram bot token and group chat ID

How to customize the workflow

  • Modify the AI prompt to include custom KPIs or industry-specific recommendations.
  • Change the schedule frequency (daily, monthly, or on-demand).
  • Add Neutral sentiment handling (e.g., log to Google Sheets).
  • Extend with Slack, Discord, or other notification channels.