Skip to Workflow Atlas
ETL PipelineAI systemIntermediate

Monthly Financial Report Automation

Monthly Financial Report Automation is a 27-node automation blueprint connecting MySQL, Microsoft Outlook, Langchain AI. Inspect its trigger, execution graph, branches, and implementation requirements.

Interactive system map

Follow the runtime. Inspect what supports it.

Solid horizontal paths show main-channel execution. Violet dependencies sit beneath the exact step they configure or empower.

27

Nodes

30

Links

1

Run groups

Connected tools

3 integrations

  • MySQL
  • Microsoft Outlook
  • LangChain

Canvas controls

Fit wide systems, then zoom into any run group.

Monthly Financial Report Automation execution lanes1 run groups containing 27 workflow nodes and 30 visible links. Solid horizontal lines are main-channel runtime links. Violet dashed lines connect typed dependencies beneath the runtime step they support. Focus any node to inspect its immediate path.Schedule Trigger. trigger node, scheduleTrigger. 0 incoming and 1 outgoing connections.STARTSchedule TriggerTRIGGERSCHEDULETRIGGER0 IN / 1 OUTDate & Time. integration node, dateTime. 1 incoming and 1 outgoing connections.STEP 02Date & TimeINTEGRATIONDATETIME1 IN / 1 OUTPreviousMonth. transform node, code. 1 incoming and 1 outgoing connections.STEP 03PreviousMonthTRANSFORMCODE1 IN / 1 OUTGet Cost Centers with Budgets. MySQL node, mySql. 1 incoming and 1 outgoing connections.STEP 04Get Cost Centers with Bud…MYSQLMYSQL1 IN / 1 OUTCostCentrs. transform node, set. 1 incoming and 1 outgoing connections.STEP 05CostCentrsTRANSFORMSET1 IN / 1 OUTFilter. decision node, filter. 1 incoming and 1 outgoing connections.STEP 06FilterDECISIONFILTER1 IN / 1 OUTLoop Over Items. integration node, splitInBatches. 2 incoming and 1 outgoing connections.STEP 07Loop Over ItemsINTEGRATIONSPLITINBATCHES2 IN / 1 OUTHTML. integration node, html. 1 incoming and 1 outgoing connections.STEP 08HTMLINTEGRATIONHTML1 IN / 1 OUTSelected Cost Center. transform node, set. 1 incoming and 4 outgoing connections.STEP 09Selected Cost CenterTRANSFORMSET1 IN / 4 OUTBusiness Performance AI Agent (Analyst). ai node, agent. 4 incoming and 1 outgoing connections.STEP 10Business Performance AI A…AIAGENT4 IN / 1 OUTProjects. MySQL node, mySql. 1 incoming and 1 outgoing connections.STEP 11ProjectsMYSQLMYSQL1 IN / 1 OUTYTD vs Prevoius Month1. MySQL node, mySql. 1 incoming and 1 outgoing connections.STEP 12YTD vs Prevoius Month1MYSQLMYSQL1 IN / 1 OUTDepartments . MySQL node, mySql. 1 incoming and 1 outgoing connections.STEP 13Departments MYSQLMYSQL1 IN / 1 OUTEmployees. MySQL node, mySql. 1 incoming and 1 outgoing connections.STEP 14EmployeesMYSQLMYSQL1 IN / 1 OUTFinancial Performance. transform node, code. 1 incoming and 1 outgoing connections.STEP 15Financial PerformanceTRANSFORMCODE1 IN / 1 OUTverticalPL. transform node, code. 1 incoming and 1 outgoing connections.STEP 16verticalPLTRANSFORMCODE1 IN / 1 OUTWIP1. transform node, code. 1 incoming and 1 outgoing connections.STEP 17WIP1TRANSFORMCODE1 IN / 1 OUTEmployees1. transform node, code. 1 incoming and 1 outgoing connections.STEP 18Employees1TRANSFORMCODE1 IN / 1 OUTCostCenter. transform node, code. 1 incoming and 1 outgoing connections.STEP 19CostCenterTRANSFORMCODE1 IN / 1 OUTEmail Data. transform node, set. 1 incoming and 1 outgoing connections.STEP 20Email DataTRANSFORMSET1 IN / 1 OUTMicrosoft Outlook2. integration node, microsoftOutlook. 1 incoming and 1 outgoing connections.STEP 21Microsoft Outlook2INTEGRATIONMICROSOFTOUTLOOK1 IN / 1 OUTMerge. decision node, merge. 4 incoming and 1 outgoing connections.STEP 22MergeDECISIONMERGE4 IN / 1 OUTCode. transform node, code. 1 incoming and 1 outgoing connections.STEP 23CodeTRANSFORMCODE1 IN / 1 OUTWait. integration node, wait. 1 incoming and 1 outgoing connections.OUTCOMEWaitINTEGRATIONWAIT1 IN / 1 OUTGoogle Gemini Chat Model. Google AI node, lmChatGoogleGemini. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1Google Gemini Chat ModelGOOGLE AILMCHATGOOGLEGEMINI0 IN / 1 OUTThink. ai node, toolThink. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1ThinkAITOOLTHINK0 IN / 1 OUTCalculator. ai node, toolCalculator. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1CalculatorAITOOLCALCULATOR0 IN / 1 OUT

Signal inspector

Focus, hover, or select a step to isolate its runtime and support links.

Main-channel runtimeTyped dependencytriggeraidecisiontransformintegration
Scroll horizontally to follow every connected flow.27 connected nodesEnter or click to lock · Escape to clear

Runtime breakdown

Read the execution spine before its dependencies.

Each run group separates main-channel steps from the models, tools, retrievers, and data services that support them. Start and outcome labels apply only to runtime nodes.

01

Run Group

Schedule Trigger

27 Execution Links3 Support Dependencies
  1. Start

    Schedule Trigger

    Trigger

  2. Step 2

    Date & Time

    Integration

  3. Step 3

    PreviousMonth

    Transform

  4. Step 4

    Get Cost Centers with Budgets

    Integration

  5. Step 5

    CostCentrs

    Transform

  6. Step 6

    Filter

    Decision

  7. Step 7

    Loop Over Items

    Integration

  8. Step 8

    HTML

    Integration

  9. Step 9

    Selected Cost Center

    Transform

  10. Step 10

    Business Performance AI Agent (Analyst)

    AI reasoning

  11. Step 11

    Projects

    Integration

  12. Step 12

    YTD vs Prevoius Month1

    Integration

  13. Step 13

    Departments

    Integration

  14. Step 14

    Employees

    Integration

  15. Step 15

    Financial Performance

    Transform

  16. Step 16

    verticalPL

    Transform

  17. Step 17

    WIP1

    Transform

  18. Step 18

    Employees1

    Transform

  19. Step 19

    CostCenter

    Transform

  20. Step 20

    Email Data

    Transform

  21. Step 21

    Microsoft Outlook2

    Integration

  22. Step 22

    Merge

    Decision

  23. Step 23

    Code

    Transform

  24. Outcome

    Wait

    Integration

Attached dependencies

These nodes support the runtime above; they are not additional starts or outcomes.

3 nodes
  • Google Gemini Chat Model

    AI reasoning dependency

  • Think

    AI reasoning dependency

  • Calculator

    AI reasoning dependency

Turn the map into a plan

Adapt this blueprint to your company.

Bring the system shape into a workspace, then define the production controls, data boundaries, owners, and delivery sequence around your context.