Marketing & Advertising Automation

0869 Wait Datetime Send Scheduled

Scheduled

High

Nodes

Scheduled

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

schedule Trigger

Schedule Trigger

1 node

my Sql

YTD vs Prevoius Month1, Get Cost Centers with Budgets, Employees, Departments , Projects

5 nodes

split In Batches

Loop Over Items

1 node

set

CostCentrs, Selected Cost Center, Email Data

3 nodes

date Time

Date & Time

1 node

code

PreviousMonth, verticalPL, Code, CostCenter, WIP1, Employees1, Financial Performance

7 nodes

filter

Filter

1 node

html

HTML

1 node

merge

Merge

1 node

microsoft Outlook

Microsoft Outlook2

1 node

wait

Wait

1 node

tool Calculator

Calculator

1 node

agent

Business Performance AI Agent (Analyst)

1 node

tool Think

Think

1 node

lm Chat Google Gemini

Google Gemini Chat Model

1 node

sticky Note

Sticky Note, Sticky Note1, Sticky Note11

3 nodes

Workflow JSON

41.8 KB

{
  "meta": {
    "instanceId": "32d80f55a35a7b57f8e47a2ac19558d9f5bcec983a5519d9c29ba713ff4f12c7"
  },
  "name": "0869 Wait Datetime Send Scheduled",
  "nodes": [
    {
      "id": "fdd55253-5cb6-4b1f-9c93-6915f254f700",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -60,
        -240
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "months",
              "triggerAtDayOfMonth": 5
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "c8d6064a-3fd7-478d-891c-6ade336daa1f",
      "name": "YTD vs Prevoius Month1",
      "type": "n8n-nodes-base.mySql",
      "onError": "continueRegularOutput",
      "position": [
        640,
        0
      ],
      "parameters": {
        "query": "SELECT\n  --  budget_data.fiscal_year AS `Year`,\n  --  budget_data.cost_center AS `Cost Center`,\n    budget_data.budget_group AS `Budget Group...

Showing first 1000 characters. Click "Expand" to view the full JSON.