Bear Brown
← All N8N workflows
AI & researchAgentCodeEmail SendExecute Workflow TriggerFacebook Graph Api

Online Marketing Weekly Report

Configured with Agent, Email Send, Execute Workflow Trigger, Facebook Graph Api, and additional nodes. Review the connections and setup before adapting this template.

Download workflow JSONView files on GitHub ↗46 nodes · MIT
Workflow preview
TriggerSchedule TriggerSchedule TriggerAI & modelsOpenAI Chat ModelOpenAI Chat ModelSubworkflowGoogle_AdsTool WorkflowSubworkflowMeta_AdsTool WorkflowSubworkflowAnalytics_Domain_1Tool WorkflowSubworkflowAnalytics_Domain_3Tool WorkflowSubworkflowAnalytics_Domain_2Tool WorkflowSubworkflowAnalytics_Domain_4Tool WorkflowSubworkflowAnalytics_Domain_5Tool WorkflowTriggerExecute WorkflowTriggerExecute Workflow TriggerIntegrationCalculatorTool CalculatorIntegrationCalculator1Tool CalculatorIntegrationCalculator3Tool CalculatorIntegrationCall Google Analyticsdata: Last 7 daysGoogle AnalyticsIntegrationCall Google Analyticsdata: Last 7 days…Google AnalyticsCodeCalculation same periodprevious yearCodeCodeFormat data input(previous year)CodeCodeFormat data input(current year)CodeTransformAssign data from input(current year)Edit FieldsTransformSummarize input(current year)SummarizeTransformAssign input (previousyear)Edit FieldsTransformSummarize input(previous year)SummarizeCodeCalculate date formatfor Google Ads request…CodeWeb / APICall Google Ads Data:Last 7 daysHTTP RequestWeb / APICall Google Ads Data:Last 7 days (previous…HTTP RequestIntegrationCall Meta Ads Data:Last 7 daysFacebook Graph ApiIntegrationCall Meta Ads Data:Last 7 days (previous…Facebook Graph ApiTransformSummarize Meta input(current year)SummarizeTransformAssign Meta data frominput (current year)Edit FieldsTransformAssign Meta data input(previous year)Edit FieldsTransformSummarize Meta datainput (previous year)SummarizeCodeFormat all Meta datafor LLMCodeAI & modelsProcessing for GoogleAds reportOpen AiCodeFormat all Google datafor LLMCodeTransformAssign Google Analyticsdata input (current…Edit FieldsTransformSummarize GoogleAnalytics input…SummarizeCodeCalculate date formatfor meta ads request sCodeCodeCalculation same periodprevious year1CodeTransformAssign Google Analyticsdata input (previous…Edit FieldsTransformSummarize GoogleAnalytics input…SummarizeMessagingSend mail reportEmail SendAI & modelsProcessing for Meta AdsReportOpen AiAI & modelsProcessing for GoogleAnalytics ReportOpen AiAI & modelsProcessing for TelegramReportOpen AiAI & modelsWeekly Report AgentAgentMessagingSend Telegram reportTelegram

Node categories in this workflow

  • Trigger
  • AI & models
  • Subworkflow
  • Integration
  • Code
  • Transform
  • Web / API
  • Messaging

Icons describe general node roles, inferred from node types. Inspect the parameters for the configured action.

Drag to pan; use + and − to zoom. Reconstructed from the exported node positions; nothing runs here. Dashed lines represent non-main connections. Full node names and notes appear below.

How it works

The exported workflow contains the following configured nodes. Their connections are shown above; inspect the JSON for the complete logic, expressions, and external actions.

Workflow node names, types, and operations
NodeCategoryTypeOperation
Schedule TriggerTriggerSchedule TriggerSee node parameters
OpenAI Chat ModelAI & modelsOpenAI Chat ModelSee node parameters
Google_AdsSubworkflowTool WorkflowSee node parameters
Meta_AdsSubworkflowTool WorkflowSee node parameters
Analytics_Domain_1SubworkflowTool WorkflowSee node parameters
Analytics_Domain_3SubworkflowTool WorkflowSee node parameters
Analytics_Domain_2SubworkflowTool WorkflowSee node parameters
Analytics_Domain_4SubworkflowTool WorkflowSee node parameters
Analytics_Domain_5SubworkflowTool WorkflowSee node parameters
Execute Workflow TriggerTriggerExecute Workflow TriggerSee node parameters
CalculatorIntegrationTool CalculatorSee node parameters
Calculator1IntegrationTool CalculatorSee node parameters
Calculator3IntegrationTool CalculatorSee node parameters
Call Google Analytics data: Last 7 daysIntegrationGoogle AnalyticsSee node parameters
Call Google Analytics data: Last 7 days (previous year)IntegrationGoogle AnalyticsSee node parameters
Calculation same period previous yearCodeCodeSee node parameters
Format data input (previous year)CodeCodeSee node parameters
Format data input (current year)CodeCodeSee node parameters
Assign data from input (current year)TransformEdit FieldsSee node parameters
Summarize input (current year)TransformSummarizeSee node parameters
Assign input (previous year)TransformEdit FieldsSee node parameters
Summarize input (previous year)TransformSummarizeSee node parameters
Calculate date format for Google Ads request (last 7 days)CodeCodeSee node parameters
Call Google Ads Data: Last 7 daysWeb / APIHTTP RequestPOST
Call Google Ads Data: Last 7 days (previous year)Web / APIHTTP RequestPOST
Call Meta Ads Data: Last 7 daysIntegrationFacebook Graph ApiSee node parameters
Call Meta Ads Data: Last 7 days (previous year)IntegrationFacebook Graph ApiSee node parameters
Summarize Meta input (current year)TransformSummarizeSee node parameters
Assign Meta data from input (current year)TransformEdit FieldsSee node parameters
Assign Meta data input (previous year)TransformEdit FieldsSee node parameters
Summarize Meta data input (previous year)TransformSummarizeSee node parameters
Format all Meta data for LLMCodeCodeSee node parameters
Processing for Google Ads reportAI & modelsOpen AiSee node parameters
Format all Google data for LLMCodeCodeSee node parameters
Assign Google Analytics data input (current year)TransformEdit FieldsSee node parameters
Summarize Google Analytics input (current year)TransformSummarizeSee node parameters
Calculate date format for meta ads request sCodeCodeSee node parameters
Calculation same period previous year1CodeCodeSee node parameters
Assign Google Analytics data input (previous year)TransformEdit FieldsSee node parameters
Summarize Google Analytics input (previous year)TransformSummarizeSee node parameters
Send mail reportMessagingEmail SendSee node parameters
Processing for Meta Ads ReportAI & modelsOpen AiSee node parameters
Processing for Google Analytics ReportAI & modelsOpen AiSee node parameters
Processing for Telegram ReportAI & modelsOpen AiSee node parameters
Weekly Report AgentAI & modelsAgentSee node parameters
Send Telegram reportMessagingTelegramSee node parameters

Setup

  1. Download the JSON and import it into an isolated n8n instance. Leave the workflow inactive.
  2. Connect your own credentials through n8n’s credential store. Replace REPLACE_WITH_* values with your resource identifiers.
  3. Inspect API destinations, Code nodes, database queries, file paths, and outbound actions.
  4. Run with synthetic data and harmless destinations. Enable triggers only after checking the actual outputs.

Requirements

An n8n instance with the listed node types and compatible versions. Service-connected workflows may require accounts, credentials, or paid APIs.

Credential types declared in the source

  • facebookGraphApi
  • googleAdsOAuth2Api
  • googleAnalyticsOAuth2
  • googleOAuth2Api
  • openAiApi
  • smtp
  • telegramApi

Workflow notes

Sticky Note1

Welcome to Online Marketing Weekly Report Workflow!

This workflow has the following sequence:

  1. time trigger (e.g. every Monday at 7 a.m.)
  2. retrieval of Online Marketing data from the last 7 days (via sub workflows)
  3. assignment and summary of the data
  4. retrieval of Online Marketing data from the same time period 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.

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. via OpenAI, Anthropic, Google or Ollama)
  • SMTP access data (for sending the mail)
  • Telegram access data (optional for sending as Telegram message): Documentation

You can contact me via LinkedIn, if you have any questions: https://www.linkedin.com/in/friedemann-schuetz

Online Marketing Weekly Report

Online Marketing Weekly Report

Purpose and structure

This folder contains the Online Marketing Weekly Report workflow. Its executable nodes use agent, code, emailSend, executeWorkflowTrigger, facebookGraphApi, googleAnalytics, httpRequest, lmChatOpenAi, openAi, scheduleTrigger, set, summarize, telegram, toolCalculator, toolWorkflow. The table and connection map below are derived from the JSON, not an inferred guarantee of behavior.

Setup

Import inactive. Configure your own credentials and replace REPLACE_WITH_* values. Review external destinations and Code nodes before running.

Entry points

Schedule Trigger, Execute Workflow Trigger

Verification

Sanitized source candidate; not runtime-tested. This overview is generated from node metadata. Read the folder README for the connection map, credential types, and license.

Attribution

https://github.com/Zie619/n8n-workflows/blob/94007c1445d9258a7da116646b79473e7c7c3282/workflows/Telegram/1905_Telegram_Googleanalytics_Automation_Webhook.json MIT; preserve source notices.

Canvas section labels

These name areas of the original canvas; they do not include explanatory instructions.

  • Sub-Workflow: Google Analytics Data
  • Sub-Workflow: Meta Ads Data
  • Main Workflow: Weekly Report Assistant
  • Sub-Workflow: Google Ads Data

More in AI & research

"Hey Siri, Ask Agent" workflow#️⃣Nostr #damus AI Powered Reporting + Gmail + Telegram(G) - Email Classification