Skip to Workflow Atlas
Playbook AtlasWorkflow Atlas
Workflow blueprintBrowse workflows
ETL PipelineIntermediate

Campaign Data Management Workflow

Campaign Data Management Workflow is a 18-node automation blueprint connecting HubSpot, Google Sheets, PostgreSQL. Inspect its trigger, execution graph, branches, and implementation requirements.

HubSpotGoogle SheetsPostgreSQL

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.

18

Nodes

22

Links

1

Run groups

Connected tools

3 integrations

  • HubSpot
  • Google Sheets
  • PostgreSQL

Canvas controls

Fit wide systems, then zoom into any run group.

Campaign Data Management Workflow execution lanes1 run groups containing 18 workflow nodes and 22 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 OUTSET SMARTLEAD API KEY. transform node, set. 1 incoming and 3 outgoing connections.STEP 02SET SMARTLEAD API KEYTRANSFORMSET1 IN / 3 OUTSEARCH. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.STEP 03SEARCHPOSTGRESQLPOSTGRES1 IN / 1 OUTFETCH ALL CAMPAIGNS. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 03FETCH ALL CAMPAIGNSINTEGRATIONHTTPREQUEST1 IN / 1 OUTPostgres. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.STEP 03PostgresPOSTGRESQLPOSTGRES1 IN / 1 OUTGoogle Sheets. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.STEP 04Google SheetsGOOGLE SHEETSGOOGLESHEETS1 IN / 0 OUTLoop Over Items1. integration node, splitInBatches. 3 incoming and 1 outgoing connections.STEP 05Loop Over Items1INTEGRATIONSPLITINBATCHES3 IN / 1 OUTLoop Over Items. integration node, splitInBatches. 2 incoming and 2 outgoing connections.STEP 06Loop Over ItemsINTEGRATIONSPLITINBATCHES2 IN / 2 OUTHubSpot. HubSpot node, hubspot. 1 incoming and 1 outgoing connections.STEP 07HubSpotHUBSPOTHUBSPOT1 IN / 1 OUTEXTRACT CAMPAIGN DATA. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 08EXTRACT CAMPAIGN DATAINTEGRATIONHTTPREQUEST1 IN / 1 OUTIf. decision node, if. 1 incoming and 2 outgoing connections.STEP 09IfDECISIONIF1 IN / 2 OUTPostgres1. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.STEP 10Postgres1POSTGRESQLPOSTGRES1 IN / 1 OUTCode. transform node, code. 1 incoming and 1 outgoing connections.STEP 11CodeTRANSFORMCODE1 IN / 1 OUTUPDATE CAMPAIGN. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.STEP 12UPDATE CAMPAIGNPOSTGRESQLPOSTGRES1 IN / 1 OUTHUBSPOT TABLE. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.STEP 13HUBSPOT TABLEPOSTGRESQLPOSTGRES1 IN / 1 OUTUPSERT CAMPAIGN ACTIVITY. PostgreSQL node, postgres. 1 incoming and 2 outgoing connections.STEP 14UPSERT CAMPAIGN ACTIVITYPOSTGRESQLPOSTGRES1 IN / 2 OUTUPDATE HUBSPOT ACTIVITY TABLE. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.STEP 15UPDATE HUBSPOT ACTIVITY T…POSTGRESQLPOSTGRES1 IN / 1 OUTMerge. decision node, merge. 3 incoming and 1 outgoing connections.OUTCOMEMergeDECISIONMERGE3 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.18 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

22 Execution Links

  1. Start

    Schedule Trigger

    Trigger

  2. Step 2

    SET SMARTLEAD API KEY

    Transform

  3. Step 3

    SEARCH

    Integration

    FETCH ALL CAMPAIGNS

    Integration

    Postgres

    Integration

  4. Step 4

    Google Sheets

    Integration

  5. Step 5

    Loop Over Items1

    Integration

  6. Step 6

    Loop Over Items

    Integration

  7. Step 7

    HubSpot

    Integration

  8. Step 8

    EXTRACT CAMPAIGN DATA

    Integration

  9. Step 9

    If

    Decision

  10. Step 10

    Postgres1

    Integration

  11. Step 11

    Code

    Transform

  12. Step 12

    UPDATE CAMPAIGN

    Integration

  13. Step 13

    HUBSPOT TABLE

    Integration

  14. Step 14

    UPSERT CAMPAIGN ACTIVITY

    Integration

  15. Step 15

    UPDATE HUBSPOT ACTIVITY TABLE

    Integration

  16. Outcome

    Merge

    Decision

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.

Create a build planReturn to the atlas