Skip to main content

Auto-analyze Google Analytics data with Gemini AI & smart Gmail/Telegram routing

Workflow preview

Workflow preview
100%
Auto-analyze Google Analytics data with Gemini AI & smart Gmail/Telegram routing preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

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...

Best for

  • Market Research automation workflows
  • Multimodal AI automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.scheduletrigger, n8n-nodes-base.aggregate, @n8n/n8n-nodes-langchain.lmchatgooglegemini, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.memorybufferwindow, n8n-nodes-base.googleanalytics, n8n-nodes-base.telegram, @n8n/n8n-nodes-langchain.sentimentanalysis

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Rully Saputra.

Original n8n.io source

1.1 Workflow description

Title
Auto-analyze Google Analytics data with Gemini AI & smart Gmail/Telegram routing
Workflow name
Auto-analyze Google Analytics data with Gemini AI & smart Gmail/Telegram routing

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.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 2 - Aggregate

Type / Role
n8n-nodes-base.aggregate - aggregate
Config choices
Version 1

Block 3 - Google Gemini Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
Config choices
Version 1

Block 4 - AI Agent

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 2.1

Block 5 - Simple Memory

Type / Role
@n8n/n8n-nodes-langchain.memoryBufferWindow - memoryBufferWindow
Config choices
Version 1.3

Block 6 - Get a weekly report

Type / Role
n8n-nodes-base.googleAnalytics - googleAnalytics
Config choices
Version 2

Block 7 - Send a message to group

Type / Role
n8n-nodes-base.telegram - telegram
Config choices
Version 1.2

Block 8 - Insight Sentiment Analysis

Type / Role
@n8n/n8n-nodes-langchain.sentimentAnalysis - sentimentAnalysis
Config choices
Version 1.1

Block 9 - Notify Stakeholders

Type / Role
n8n-nodes-base.gmail - gmail
Config choices
Version 2.1

Block 10 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 11 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 12 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 13 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 14 - Sticky Note4

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 15 - Sticky Note5

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Auto-analyze Google Analytics data with Gemini AI & smart Gmail/Telegram routing
Complexity advanced
Nodes 15
Categories Market Research, Multimodal AI
Author Rully Saputra
Published 08 Aug 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/7183/7183.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Auto-analyze Google Analytics data with Gemini AI & smart Gmail/Telegram routing do?

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...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, Multimodal AI use case.