AI Agents

Connect Google Analytics with OpenAI andTelegram

51 nodes 208 124 Scheduled trigger
Download

Workflow Description

An automation workflow that retrieves analytics data from Google Analytics on a scheduled basis, processes it with OpenAI for intelligent analysis, and automatically distributes insights via Telegram, email, and social media platforms to keep your team informed of key performance metrics.

How it works

  1. 1.Retrieve website analytics data from Google Analytics based on configured schedule
  2. 2.Process and calculate metrics using built-in calculation nodes
  3. 3.Send processed data to OpenAI for intelligent analysis and insight generation
  4. 4.Distribute formatted reports to Telegram, email, Facebook, and Twitter channels simultaneously

Use cases

  • Monitor website performance and receive intelligent daily or weekly analytics reports
  • Analyze user trends and receive actionable recommendations from AI
  • Automatically notify marketing team of important metrics across multiple communication channels

Requirements

  • Active Google Analytics account connected to your website
  • OpenAI API key with appropriate permissions
  • Telegram account with channel or group ID configured

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

OpenAI Tool Twitter/X Google Analytics Facebook Email Send AI Agent Telegram

Details

Trigger Scheduled trigger
Nodes 51
Apps 8
Views 208
Downloads 124

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (51)

/

Schedule Trigger

Schedule Trigger

#1

OpenAI Chat Model

OpenAI

#2

Google_Ads

Tool Workflow

#3

Meta_Ads

Tool Workflow

#4

Analytics_Domain_1

Tool Workflow

#5

Analytics_Domain_3

Tool Workflow

#6

Analytics_Domain_2

Tool Workflow

#7

Analytics_Domain_4

Tool Workflow

#8

Analytics_Domain_5

Tool Workflow

#9

Execute Workflow Trigger

Execute Workflow Trigger

#10

Calculator

Tool Calculator

#11

Sticky Note

Sticky Note

#12

Sticky Note2

Sticky Note

#13

Sticky Note3

Sticky Note

#14

Calculator1

Tool Calculator

#15

Sticky Note4

Sticky Note

#16

Calculator3

Tool Calculator

#17

Call Google Analytics data: Last 7 days

Google Analytics

#18

Call Google Analytics data: Last 7 days (previous year)

Google Analytics

#19

Calculation same period previous year

Code

#20

Format data input (previous year)

Code

#21

Format data input (current year)

Code

#22

Assign data from input (current year)

Set

#23

Summarize input (current year)

Summarize

#24

Assign input (previous year)

Set

#25

Summarize input (previous year)

Summarize

#26

Calculate date format for Google Ads request (last 7 days)

Code

#27

Call Google Ads Data: Last 7 days

HTTP Request

#28

Call Google Ads Data: Last 7 days (previous year)

HTTP Request

#29

Call Meta Ads Data: Last 7 days

Facebook Graph Api

#30

Call Meta Ads Data: Last 7 days (previous year)

Facebook Graph Api

#31

Summarize Meta input (current year)

Summarize

#32

Assign Meta data from input (current year)

Set

#33

Assign Meta data input (previous year)

Set

#34

Summarize Meta data input (previous year)

Summarize

#35

Format all Meta data for LLM

Code

#36

Processing for Google Ads report

OpenAI

#37

Format all Google data for LLM

Code

#38

Assign Google Analytics data input (current year)

Set

#39

Summarize Google Analytics input (current year)

Summarize

#40

Calculate date format for meta ads request s

Code

#41

Calculation same period previous year1

Code

#42

Assign Google Analytics data input (previous year)

Set

#43

Summarize Google Analytics input (previous year)

Summarize

#44

Send mail report

Email Send

#45

Processing for Meta Ads Report

OpenAI

#46

Processing for Google Analytics Report

OpenAI

#47

Processing for Telegram Report

OpenAI

#48

Weekly Report Agent

Agent

#49

Send Telegram report

Set

#50

Sticky Note1

Sticky Note

#51

Similar Templates

Automate Google Sheets

8 nodes

HR and IT help desk with audio transcription

27 nodes

Automate the content generator for WordPress using

17 nodes

Connect Todoist with OpenAI

12 nodes

Automate Google Sheets

11 nodes

Connect Google Sheets with Slack

12 nodes