Skip to Workflow Atlas
ETL PipelineIntermediate

YouTube Video Data Aggregator

YouTube Video Data Aggregator is a 19-node automation blueprint connecting YouTube, PostgreSQL. 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.

19

Nodes

17

Links

3

Run groups

Connected tools

2 integrations

  • YouTube
  • PostgreSQL

Canvas controls

Fit wide systems, then zoom into any run group.

YouTube Video Data Aggregator execution lanes3 run groups containing 19 workflow nodes and 17 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.Execute Workflow Trigger. trigger node, executeWorkflowTrigger. 0 incoming and 1 outgoing connections.STARTExecute Workflow TriggerTRIGGEREXECUTEWORKFLOWTRIGGER0 IN / 1 OUTPostgres. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.STEP 02PostgresPOSTGRESQLPOSTGRES1 IN / 1 OUTsanitize_data. transform node, code. 1 incoming and 0 outgoing connections.OUTCOMEsanitize_dataTRANSFORMCODE1 IN / 0 OUTcreate_table. PostgreSQL node, postgres. 0 incoming and 0 outgoing connections.CORE RUNTIMEcreate_tablePOSTGRESQLPOSTGRES0 IN / 0 OUTsee table. PostgreSQL node, postgres. 0 incoming and 0 outgoing connections.CORE RUNTIMEsee tablePOSTGRESQLPOSTGRES0 IN / 0 OUTdrop table. PostgreSQL node, postgres. 0 incoming and 0 outgoing connections.CORE RUNTIMEdrop tablePOSTGRESQLPOSTGRES0 IN / 0 OUTWhen clicking ‘Test workflow’. trigger node, manualTrigger. 0 incoming and 1 outgoing connections.STARTWhen clicking ‘Test workf…TRIGGERMANUALTRIGGER0 IN / 1 OUTLoop Over Items. integration node, splitInBatches. 4 incoming and 1 outgoing connections.STEP 02Loop Over ItemsINTEGRATIONSPLITINBATCHES4 IN / 1 OUTfetch_last_registered. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.STEP 03fetch_last_registeredPOSTGRESQLPOSTGRES1 IN / 1 OUTget_videos. integration node, youTube. 1 incoming and 1 outgoing connections.STEP 04get_videosINTEGRATIONYOUTUBE1 IN / 1 OUTif_is_empty. decision node, if. 1 incoming and 2 outgoing connections.STEP 05if_is_emptyDECISIONIF1 IN / 2 OUTalready_populated. transform node, set. 1 incoming and 1 outgoing connections.STEP 06already_populatedTRANSFORMSET1 IN / 1 OUTfind_video_data1. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 07find_video_data1INTEGRATIONHTTPREQUEST1 IN / 1 OUTremove_shorts. transform node, code. 1 incoming and 1 outgoing connections.STEP 08remove_shortsTRANSFORMCODE1 IN / 1 OUTif_empty. decision node, if. 1 incoming and 2 outgoing connections.STEP 09if_emptyDECISIONIF1 IN / 2 OUTmap_data. transform node, set. 1 incoming and 1 outgoing connections.STEP 10map_dataTRANSFORMSET1 IN / 1 OUTstructure_data. transform node, code. 1 incoming and 1 outgoing connections.STEP 11structure_dataTRANSFORMCODE1 IN / 1 OUTcreate_query. transform node, code. 1 incoming and 1 outgoing connections.STEP 12create_queryTRANSFORMCODE1 IN / 1 OUTinsert_items. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.OUTCOMEinsert_itemsPOSTGRESQLPOSTGRES1 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.19 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

Execute Workflow Trigger

2 Execution Links
  1. Start

    Execute Workflow Trigger

    Trigger

  2. Step 2

    Postgres

    Integration

  3. Outcome

    sanitize_data

    Transform

02

Run Group

Standalone nodes

0 Execution Links
  1. Core Runtime

    create_table

    Integration

    see table

    Integration

    drop table

    Integration

03

Run Group

When clicking ‘Test workflow’

15 Execution Links
  1. Start

    When clicking ‘Test workflow’

    Trigger

  2. Step 2

    Loop Over Items

    Integration

  3. Step 3

    fetch_last_registered

    Integration

  4. Step 4

    get_videos

    Integration

  5. Step 5

    if_is_empty

    Decision

  6. Step 6

    already_populated

    Transform

  7. Step 7

    find_video_data1

    Integration

  8. Step 8

    remove_shorts

    Transform

  9. Step 9

    if_empty

    Decision

  10. Step 10

    map_data

    Transform

  11. Step 11

    structure_data

    Transform

  12. Step 12

    create_query

    Transform

  13. Outcome

    insert_items

    Integration

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.