{
  "openruna_format": "flow-graph-v1",
  "title": "Online Marketing Weekly Report",
  "slug": "online-marketing-weekly-report",
  "source_filename": "1905_Telegram_Googleanalytics_Automation_Webhook.json",
  "nodes": [
    {
      "id": "Schedule Trigger",
      "name": "Schedule Trigger",
      "integration": "schedule",
      "kind": "trigger"
    },
    {
      "id": "OpenAI Chat Model",
      "name": "OpenAI Chat Model",
      "integration": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "kind": "action"
    },
    {
      "id": "Google_Ads",
      "name": "Google_Ads",
      "integration": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "kind": "action"
    },
    {
      "id": "Meta_Ads",
      "name": "Meta_Ads",
      "integration": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "kind": "action"
    },
    {
      "id": "Analytics_Domain_1",
      "name": "Analytics_Domain_1",
      "integration": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "kind": "action"
    },
    {
      "id": "Analytics_Domain_3",
      "name": "Analytics_Domain_3",
      "integration": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "kind": "action"
    },
    {
      "id": "Analytics_Domain_2",
      "name": "Analytics_Domain_2",
      "integration": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "kind": "action"
    },
    {
      "id": "Analytics_Domain_4",
      "name": "Analytics_Domain_4",
      "integration": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "kind": "action"
    },
    {
      "id": "Analytics_Domain_5",
      "name": "Analytics_Domain_5",
      "integration": "@n8n/n8n-nodes-langchain.toolWorkflow",
      "kind": "action"
    },
    {
      "id": "Execute Workflow Trigger",
      "name": "Execute Workflow Trigger",
      "integration": "executeWorkflow",
      "kind": "trigger"
    },
    {
      "id": "Calculator",
      "name": "Calculator",
      "integration": "@n8n/n8n-nodes-langchain.toolCalculator",
      "kind": "action"
    },
    {
      "id": "Calculator1",
      "name": "Calculator1",
      "integration": "@n8n/n8n-nodes-langchain.toolCalculator",
      "kind": "action"
    },
    {
      "id": "Calculator3",
      "name": "Calculator3",
      "integration": "@n8n/n8n-nodes-langchain.toolCalculator",
      "kind": "action"
    },
    {
      "id": "Call Google Analytics data: Last 7 days",
      "name": "Call Google Analytics data: Last 7 days",
      "integration": "googleAnalytics",
      "kind": "action"
    },
    {
      "id": "Call Google Analytics data: Last 7 days (previous year)",
      "name": "Call Google Analytics data: Last 7 days (previous year)",
      "integration": "googleAnalytics",
      "kind": "action"
    },
    {
      "id": "Calculation same period previous year",
      "name": "Calculation same period previous year",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Format data input (previous year)",
      "name": "Format data input (previous year)",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Format data input (current year)",
      "name": "Format data input (current year)",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Assign data from input (current year)",
      "name": "Assign data from input (current year)",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Summarize input (current year)",
      "name": "Summarize input (current year)",
      "integration": "summarize",
      "kind": "action"
    },
    {
      "id": "Assign input (previous year)",
      "name": "Assign input (previous year)",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Summarize input (previous year)",
      "name": "Summarize input (previous year)",
      "integration": "summarize",
      "kind": "action"
    },
    {
      "id": "Calculate date format for Google Ads request (last 7 days)",
      "name": "Calculate date format for Google Ads request (last 7 days)",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Call Google Ads Data: Last 7 days",
      "name": "Call Google Ads Data: Last 7 days",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Call Google Ads Data: Last 7 days (previous year)",
      "name": "Call Google Ads Data: Last 7 days (previous year)",
      "integration": "httpRequest",
      "kind": "action"
    },
    {
      "id": "Call Meta Ads Data: Last 7 days",
      "name": "Call Meta Ads Data: Last 7 days",
      "integration": "facebookGraphApi",
      "kind": "action"
    },
    {
      "id": "Call Meta Ads Data: Last 7 days (previous year)",
      "name": "Call Meta Ads Data: Last 7 days (previous year)",
      "integration": "facebookGraphApi",
      "kind": "action"
    },
    {
      "id": "Summarize Meta input (current year)",
      "name": "Summarize Meta input (current year)",
      "integration": "summarize",
      "kind": "action"
    },
    {
      "id": "Assign Meta data from input (current year)",
      "name": "Assign Meta data from input (current year)",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Assign Meta data input (previous year)",
      "name": "Assign Meta data input (previous year)",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Summarize Meta data input (previous year)",
      "name": "Summarize Meta data input (previous year)",
      "integration": "summarize",
      "kind": "action"
    },
    {
      "id": "Format all Meta data for LLM",
      "name": "Format all Meta data for LLM",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Processing for Google Ads report",
      "name": "Processing for Google Ads report",
      "integration": "@n8n/n8n-nodes-langchain.openAi",
      "kind": "action"
    },
    {
      "id": "Format all Google data for LLM",
      "name": "Format all Google data for LLM",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Assign Google Analytics data input (current year)",
      "name": "Assign Google Analytics data input (current year)",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Summarize Google Analytics input (current year)",
      "name": "Summarize Google Analytics input (current year)",
      "integration": "summarize",
      "kind": "action"
    },
    {
      "id": "Calculate date format for meta ads request s",
      "name": "Calculate date format for meta ads request s",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Calculation same period previous year1",
      "name": "Calculation same period previous year1",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Assign Google Analytics data input (previous year)",
      "name": "Assign Google Analytics data input (previous year)",
      "integration": "set",
      "kind": "logic"
    },
    {
      "id": "Summarize Google Analytics input (previous year)",
      "name": "Summarize Google Analytics input (previous year)",
      "integration": "summarize",
      "kind": "action"
    },
    {
      "id": "Send mail report",
      "name": "Send mail report",
      "integration": "emailSend",
      "kind": "action"
    },
    {
      "id": "Processing for Meta Ads Report",
      "name": "Processing for Meta Ads Report",
      "integration": "@n8n/n8n-nodes-langchain.openAi",
      "kind": "action"
    },
    {
      "id": "Processing for Google Analytics Report",
      "name": "Processing for Google Analytics Report",
      "integration": "@n8n/n8n-nodes-langchain.openAi",
      "kind": "action"
    },
    {
      "id": "Processing for Telegram Report",
      "name": "Processing for Telegram Report",
      "integration": "@n8n/n8n-nodes-langchain.openAi",
      "kind": "action"
    },
    {
      "id": "Weekly Report Agent",
      "name": "Weekly Report Agent",
      "integration": "@n8n/n8n-nodes-langchain.agent",
      "kind": "action"
    },
    {
      "id": "Send Telegram report",
      "name": "Send Telegram report",
      "integration": "telegram",
      "kind": "action"
    }
  ],
  "edges": [
    {
      "from": "Schedule Trigger",
      "to": "Weekly Report Agent"
    },
    {
      "from": "Weekly Report Agent",
      "to": "Processing for Telegram Report"
    },
    {
      "from": "Weekly Report Agent",
      "to": "Send mail report"
    },
    {
      "from": "Execute Workflow Trigger",
      "to": "Call Google Analytics data: Last 7 days"
    },
    {
      "from": "Assign input (previous year)",
      "to": "Summarize input (previous year)"
    },
    {
      "from": "Format all Meta data for LLM",
      "to": "Processing for Meta Ads Report"
    },
    {
      "from": "Format all Google data for LLM",
      "to": "Processing for Google Ads report"
    },
    {
      "from": "Processing for Telegram Report",
      "to": "Send Telegram report"
    },
    {
      "from": "Summarize input (current year)",
      "to": "Calculation same period previous year"
    },
    {
      "from": "Call Meta Ads Data: Last 7 days",
      "to": "Assign Meta data from input (current year)"
    },
    {
      "from": "Summarize input (previous year)",
      "to": "Format all Google data for LLM"
    },
    {
      "from": "Format data input (current year)",
      "to": "Assign data from input (current year)"
    },
    {
      "from": "Call Google Ads Data: Last 7 days",
      "to": "Format data input (current year)"
    },
    {
      "from": "Format data input (previous year)",
      "to": "Assign input (previous year)"
    },
    {
      "from": "Summarize Meta input (current year)",
      "to": "Call Meta Ads Data: Last 7 days (previous year)"
    },
    {
      "from": "Assign data from input (current year)",
      "to": "Summarize input (current year)"
    },
    {
      "from": "Calculation same period previous year",
      "to": "Call Google Ads Data: Last 7 days (previous year)"
    },
    {
      "from": "Assign Meta data input (previous year)",
      "to": "Summarize Meta data input (previous year)"
    },
    {
      "from": "Calculation same period previous year1",
      "to": "Call Google Analytics data: Last 7 days (previous year)"
    },
    {
      "from": "Call Google Analytics data: Last 7 days",
      "to": "Assign Google Analytics data input (current year)"
    },
    {
      "from": "Summarize Meta data input (previous year)",
      "to": "Format all Meta data for LLM"
    },
    {
      "from": "Assign Meta data from input (current year)",
      "to": "Summarize Meta input (current year)"
    },
    {
      "from": "Calculate date format for meta ads request s",
      "to": "Call Meta Ads Data: Last 7 days"
    },
    {
      "from": "Call Meta Ads Data: Last 7 days (previous year)",
      "to": "Assign Meta data input (previous year)"
    },
    {
      "from": "Summarize Google Analytics input (current year)",
      "to": "Calculation same period previous year1"
    },
    {
      "from": "Summarize Google Analytics input (previous year)",
      "to": "Processing for Google Analytics Report"
    },
    {
      "from": "Assign Google Analytics data input (current year)",
      "to": "Summarize Google Analytics input (current year)"
    },
    {
      "from": "Call Google Ads Data: Last 7 days (previous year)",
      "to": "Format data input (previous year)"
    },
    {
      "from": "Assign Google Analytics data input (previous year)",
      "to": "Summarize Google Analytics input (previous year)"
    },
    {
      "from": "Call Google Analytics data: Last 7 days (previous year)",
      "to": "Assign Google Analytics data input (previous year)"
    },
    {
      "from": "Calculate date format for Google Ads request (last 7 days)",
      "to": "Call Google Ads Data: Last 7 days"
    }
  ]
}