Skip to content
FlowHub
FluxonLab
A
AI Automationfree

AI marketing report (Google Analytics & Ads, Meta Ads), sent via email/Telegram

by Friedemann Schuetzadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAAI AgentCalculatorCalculatorCall n8n Workflow ToolCall n8n Workflow ToolCCodeFacebook Graph APIFacebook Graph APIGoogle AnalyticsGoogle AnalyticsHTTP RequestHTTP RequestOpenAIOpenAI Chat ModelOpenAI Chat ModelSend EmailSend EmailTelegramTelegram
Share Post Share
ScSchedule TriggerOpenAI Chat ModelOpenAI Chat Mod…TWGoogle_AdsTWMeta_AdsTWAnalytics_Domain_1Analytics_Domai…TWAnalytics_Domain_3Analytics_Domai…TWAnalytics_Domain_2Analytics_Domai…TWAnalytics_Domain_4Analytics_Domai…TWAnalytics_Domain_5Analytics_Domai…EWExecute Workflow TriggerExecute Workflo…TCCalculatorTCCalculator1TCCalculator3GACall Google Analytics data: Last 7 daysCall Google Ana…GACall Google Analytics data: Last 7 days (previous year)Call Google Ana…CoCalculation same period previous yearCalculation sam…CoFormat data input (previous year)Format data inp…CoFormat data input (current year)Format data inp…SeAssign data from input (current year)Assign data fro…SuSummarize input (current year)Summarize input…SeAssign input (previous year)Assign input (p…SuSummarize input (previous year)Summarize input…CoCalculate date format for Google Ads request (last 7 days)Calculate date …HRCall Google Ads Data: Last 7 daysCall Google Ads…HRCall Google Ads Data: Last 7 days (previous year)Call Google Ads…Call Meta Ads Data: Last 7 daysCall Meta Ads D…Call Meta Ads Data: Last 7 days (previous year)Call Meta Ads D…SuSummarize Meta input (current year)Summarize Meta …SeAssign Meta data from input (current year)Assign Meta dat…SeAssign Meta data input (previous year)Assign Meta dat…SuSummarize Meta data input (previous year)Summarize Meta …CoFormat all Meta data for LLMFormat all Meta…Processing for Google Ads reportProcessing for …CoFormat all Google data for LLMFormat all Goog…SeAssign Google Analytics data input (current year)Assign Google A…SuSummarize Google Analytics input (current year)Summarize Googl…CoCalculate date format for meta ads request sCalculate date …CoCalculation same period previous year1Calculation sam…SeAssign Google Analytics data input (previous year)Assign Google A…SuSummarize Google Analytics input (previous year)Summarize Googl…ESSend mail reportProcessing for Meta Ads ReportProcessing for …Processing for Google Analytics ReportProcessing for …Processing for Telegram ReportProcessing for …AgWeekly Report AgentWeekly Report A…Send Telegram reportSend Telegram r…123456789101112
1/5
FLOWS
STEPS · 12
Runs on a schedule

What this workflow does This workflow retrieves Online Marketing data (Google Analytics for several domains, Google Ads, Meta Ads) 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: time trigger (e.g. every Monday at 7 a.m.) retrieval of Online Marketing data from the last 7 days (via sub workflows) assignment and summary of the data retrieval of Online Marketing data from the same time period of the previous year allocation and summary of the data preparation in tabular form and brief analysis by AI. sending the report as an email preparation in short form by AI for Telegram (optional) sending as Telegram message. Requirements The following accesses are required for the workflow: Google Analytics (via Google Analytics API): Documentation Google Ads (via HTTP Request -> Google Ads API):Documentation Meta Ads (via Facebook Graph API): Documentation AI API access (e.g.

Tags

n8nreference-onlyagentemail-sendfacebook-graph-apigoogle-analyticslm-chat-open-aiopen-aitelegramtool-calculatortool-workflow
Connects
AAI AgentcalculatorCalculatorcalln8nworkflowtoolCall n8n Workflow ToolCCodefacebookgraphapiFacebook Graph APIgoogleanalyticsGoogle Analytics
CategoryAI Automation
Triggermanual
Complexityadvanced
Nodes46
AddedJan 23, 2025

Related workflows

See all AI Automation→
AopenaichatmodelS
free

Run a Telegram voice and chat assistant with OpenAI, Gmail, Calendar, and Notion

Quick overview This workflow turns a Telegram bot into a personal assistant that understands text or voice notes (transcribed with OpenAI), can read Gmail and Google Calendar, look up Notion tasks and contacts, and can draft and send emails with an approval step in Telegram. How it works Triggers when a new Telegram message arrives. Loads assistant settings (name, OpenAI model, languages, memory window) and checks whether the message is a voice note or plain text. If it is a voice note, downloads the audio from Telegram and transcribes it with OpenAI; otherwise it uses the message text as the user input. Sends the user input to an OpenAI-powered agent that keeps short-term chat memory and decides whether to call Gmail, Google Calendar, or Notion tools to answer the request. If the agent decides to send an email via Gmail, it asks for explicit approval in Telegram before proceeding. Sends the agent’s final response back to the user in Telegram. Setup Create a Telegram bot with @BotFather, add your Telegram credentials in n8n, and start a chat with the bot so it can reply to you. Add an OpenAI API credential and set the desired chat model and transcription language in the Configurati

by Dr. Firas
ACembeddingsopenai
free

Route WhatsApp support requests with Claude, Supabase, HubSpot and Slack

Quick overview This workflow turns incoming WhatsApp messages (text, audio, images, and documents) into actionable support interactions by extracting content, detecting sentiment, and using an AI agent with a Supabase knowledge base to route requests to Google Calendar, HubSpot, Slack, Gmail, and back to WhatsApp. How it works Receives incoming WhatsApp messages via a WhatsApp webhook trigger. Routes the message by type and converts it into text using OpenAI Whisper for audio, OpenAI GPT-4o Vision for images, or a PDF extractor for documents (or passes text messages through). Loads the sender’s session context from Supabase and runs sentiment/language detection on the extracted text. Uses a LangChain AI agent (Claude) with Supabase vector search (with OpenAI embeddings and Cohere reranking) plus tool access (Google Calendar, HubSpot, Slack, and Gmail) to produce a structured intent, response, and metadata. Logs conversation analytics (intent, sentiment, message type, and response length) to an n8n Data Table. Routes by intent to either create a Google Calendar event, create/update a HubSpot contact, email a document via Gmail (and upload it to Google Drive), create a HubSpot ticket

by Multifly
airtableCfacebookgraphapi
free

Post TikTok, YouTube Shorts and Instagram Reels with Airtable, OpenAI and Google

Quick Overview This workflow runs on a schedule, pulls the next publish-ready video from Airtable, uses OpenAI, Google Gemini, and CloudConvert to generate a transcript, title, description, tags, and hashtags, then uploads to YouTube Shorts, posts an Instagram Reel via Meta Graph API, and queues TikTok publishing via Google Sheets. How it works Runs on a schedule (or manually) and waits a random number of minutes to stagger posting. Searches Airtable for content marked Publish = true and Status = “In Publish Queue”, then selects a single record to process. Downloads the video, converts it to MP3 with CloudConvert, and transcribes the audio with OpenAI. Uses OpenAI and Google Gemini to extract a main keyword, generate a YouTube-optimized title, and create YouTube tags, hashtags, and a full YouTube description, then derives a shorter content-only caption for Instagram/TikTok. Uploads the video to tmpfiles.org to generate a direct file URL and updates the Airtable record with the generated metadata and set Status = “Published”. Uploads the video to YouTube with the generated title, description, and tags. Creates and publishes an Instagram Reel via the Meta (Facebook) Graph API after a

by Iliyan Ivanov