AutomationMart
Home/Browse/Create a Google Analytics data report with AI and sent it to e-mail and Telegram
n8n

Create a Google Analytics data report with AI and sent it to e-mail and Telegram

n8nn8n13 modulesv1.0
OpenAITelegramLinkedIn

What this workflow does This workflow retrieves Google Analytics data from the last 7 days and the same period in the previous year. The data is then prepared by AI as a table, analyzed and provided with a small summary. The summary is then sent by email to a desired address and, shortened and summarized again, sent to a Telegram account. This workflow has the following sequence: 1. time trigger (e.g. every Monday at 7 a.m.) 2. retrieval of Google Analytics data from the last 7 days 3. assignmen

At a glance

Create a Google Analytics data report with AI and sent it to e-mail and Telegram is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI, Telegram, LinkedIn. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
OpenAI, Telegram, LinkedIn
Modules
13
Price
Free
Version
v1.0
Create a Google Analytics data report with AI and sent it to e-mail and Telegram workflow diagram

About this workflow

What this workflow does This workflow retrieves Google Analytics data from the last 7 days and the same period in the previous year. The data is then prepared by AI as a table, analyzed and provided with a small summary. The summary is then sent by email to a desired address and, shortened and summarized again, sent to a Telegram account. This workflow has the following sequence: 1. time trigger (e.g. every Monday at 7 a.m.) 2. retrieval of Google Analytics data from the last 7 days 3. assignment and summary of the data 4. retrieval of Google Analytics data from the last 7 days of the previous year 5. allocation and summary of the data 6. preparation in tabular form and brief analysis by AI. 7. sending the report as an email 8. preparation in short form by AI for Telegram (optional) 9. sending as Telegram message. Requirements The following accesses are required for the workflow: - Google Analytics (via Google Analytics API): Documentation - AI API access (e.g. via OpenAI, Anthropic, Google or Ollama) - SMTP access data (for sending the mail) - Telegram access data (optional for sending as Telegram message): Documentation Feel free to contact me via LinkedIn, if you have any questions!

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

[AI Tools 101] AI Summarisation with OpenAI and Google Sheets

Learn how to automate content summarisation using OpenAI's GPT models. This template is part of the [AI Tools 101 YouTube course series](https://www.youtube.com/watch?v=htApI1WhnpE&list=PLrED3I754LhmTtlldfGklaEMh-ZaCa3EK&index=4&ab_channel=Make), providing step-by-step guidance to streamline your workflow with AI-powered summarisation. Follow along to effortlessly generate concise summaries from your data.

Free

Automate daily Hindu festival posts on X with Google Gemini and GPT-4o Mini 🤖

Automate Daily Hindu Festival Posts on X (Twitter) with AI 🐦 This workflow automates the entire process of creating and publishing culturally rich social media content about Hindu festivals. It starts by building a comprehensive festival calendar for the year in a Google Sheet, then runs daily to post engaging, bilingual updates on X (formerly Twitter). 🗓️ The workflow uses a sophisticated dual-AI system: Google Gemini acts as a content generator creating multiple post options ✍️, while OpenAI's

Free

Recipe recommendation engine with Bright Data MCP & OpenAI 4o mini

Notice Community nodes can only be installed on self-hosted instances of n8n. Who this is for Recipe Recommendation Engine with Bright Data MCP & OpenAI is a powerful automated workflow combines Bright Data's MCP for scraping trending or regional recipe data with OpenAI 4o mini to generate personalized recipe recommendations. This automated workflow is designed for: Food Bloggers & Culinary Creators : Who want to automate the extraction and curation of recipes from across the web to generate co

Free

Route Chatwoot customer chats to AI and live agents with Groq and Gemini

Quick overview This workflow automates customer chat with Chatwoot & n8n AI agent that handles incoming chats, qualifies leads, answers FAQs from Pinecone knowledge base, and escalates to a live human agent when one is online. Works with any Chatwoot inbox: web widget, WhatsApp, Telegram, and more. How it works 1. Receives a POST webhook from Chatwoot when a message is created in a conversation. 2. Extracts message and sender fields into a clean structure, then ignores outgoing messages t

Free

Log meal nutrients from Telegram to Google Sheets using an AI agent

Who is this for? This workflow is ideal for individuals focused on nutrition tracking, meal planning, or diet optimization—whether you’re a health-conscious individual, fitness coach, or developer working on a healthtech app. It also fits well for anyone who wants to capture their meal data via voice or text, without manually entering everything into a spreadsheet. What problem is this workflow solving? Manually logging meals and breaking down their nutritional content is time-consuming and ofte

Free

Create daily Israeli economic newsletter using RSS and GPT-4o

Daily Economic News Brief for Israel (Hebrew, RTL, GPT-4o) Overview ### Stay ahead of the curve with this AI-powered workflow that delivers a daily economic summary tailored for professionals tracking the Israeli economy. At 8:00 PM Israel Time, this workflow: - Retrieves the latest articles from Calcalist and Mako via RSS - Filters duplicates and irrelevant stories - Uses OpenAI’s GPT-4o to identify the 5 most important stories of the day - Summarizes each article in concise, readable Hebrew -

Free

Generate PDF business proposals with Google Gemini and PDF Generator API

AI-Powered Automated Proposal & Lead Management System This advanced n8n workflow automates the transition from "Raw Lead" to "Sent Proposal." By integrating Email Verification, Large Language Models (LLMs), and Document Automation, it eliminates manual data entry and ensures that every proposal sent is personalized, professional, and delivered to a verified address. 🛠️ How It Works 1. Data Intake & Validation The workflow is triggered via a Webhook. Before any processing occurs, the data passes

Free

Automate sprint planning with OpenAI, Google Calendar, and Gmail for agile teams

Who is this for? This workflow is designed for Scrum Masters and Agile Coaches who prepare and coordinate Sprint Planning sessions, using Google Calendar, Google Sheets, and OpenAI. 🧩 What problem is this workflow solving? It solves the manual and time-consuming task of collecting, validating, and preparing backlog items for sprint planning—especially when coordinating with distributed teams or large product backlogs. ⚙️ What this workflow does Every week, the workflow: - Detects if a Sprint Pla

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free