Keyflow
Contact

Search Keyflow

Find a shortcut, workflow, MCP server or skill

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

n8n template #2783

Summary

Use template
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 summa

How to set it up

  1. Open template #2783 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
  2. Create 6 credentials under Credentials → Add credential: Send Email, Telegram, Facebook Graph API, Google Analytics, OpenAI Chat Model, OpenAI. Then open each of those nodes and pick the credential.
  3. Check the model in the AI Agent node. The template may point at a model your account can't use; swap it for one you have access to.
  4. Click Execute workflow and step through each node's output to confirm the data looks right.
  5. Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "AI marketing report (Google Analytics & Ads, Meta Ads), sent via email/Telegram" (https://n8n.io/workflows/2783). It uses: Send Email, HTTP Request, Telegram, Facebook Graph API, Google Analytics, Code, AI Agent, OpenAI Chat Model, Calculator, Call n8n Workflow Tool, OpenAI. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Send EmailHTTP RequestTelegramFacebook Graph APIGoogle AnalyticsCodeAI AgentOpenAI Chat ModelCalculatorCall n8n Workflow ToolOpenAI

Questions

Yes. Friedemann Schuetz published it free on n8n.io as a verified creator, and it has 36K views. It runs on n8n Cloud or a self-hosted n8n instance.

Send Email, Telegram, Facebook Graph API, Google Analytics, OpenAI Chat Model, OpenAI. The other 5 nodes are built into n8n.

Similar workflows

NameViews
  1. ✨🤖Automate Multi-Platform Social Media Content Creation with AI205K
  2. ✨🩷Automated Social Media Content Publishing Factory + System Prompt Composition55K
  3. Automated Stock Analysis Reports with Technical & News Sentiment using GPT-4o37K
  4. Automate SEO blog creation + social media with GPT-4, Perplexity and WordPress5,798
  5. Explore n8n Nodes in a Visual Reference Library5,197
  6. Build Your First AI Data Analyst Chatbot134K
  7. 🤖 AI content generation for Auto Service 🚘 Automate your social media📲!27K
  8. Technical stock analysis with Telegram, Airtable and a GPT-powered AI Agent17K