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

Execution flows, separated by connected path.

Each horizontal lane is one connected flow. Solid lines show runtime execution; dashed lines show AI, model, memory, or tool dependencies.

18

Nodes

22

Links

1

Flows

Connected tools

3 integrations

  • HubSpot
  • Google Sheets
  • PostgreSQL
Campaign Data Management Workflow execution lanes1 connected flows containing 18 workflow nodes and 22 visible links. Solid lines are execution links and dashed lines are support dependencies. Focus any node to inspect its immediate path.Schedule Trigger. trigger node, scheduleTrigger. 0 incoming and 1 outgoing connections.Schedule TriggerTRIGGERSCHEDULETRIGGER0 IN / 1 OUTSET SMARTLEAD API KEY. transform node, set. 1 incoming and 3 outgoing connections.SET SMARTLEAD API KEYTRANSFORMSET1 IN / 3 OUTSEARCH. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.SEARCHPOSTGRESQLPOSTGRES1 IN / 1 OUTFETCH ALL CAMPAIGNS. integration node, httpRequest. 1 incoming and 1 outgoing connections.FETCH ALL CAMPAIGNSINTEGRATIONHTTPREQUEST1 IN / 1 OUTPostgres. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.PostgresPOSTGRESQLPOSTGRES1 IN / 1 OUTGoogle Sheets. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.Google SheetsGOOGLE SHEETSGOOGLESHEETS1 IN / 0 OUTLoop Over Items1. integration node, splitInBatches. 3 incoming and 1 outgoing connections.Loop Over Items1INTEGRATIONSPLITINBATCHES3 IN / 1 OUTLoop Over Items. integration node, splitInBatches. 2 incoming and 2 outgoing connections.Loop Over ItemsINTEGRATIONSPLITINBATCHES2 IN / 2 OUTHubSpot. HubSpot node, hubspot. 1 incoming and 1 outgoing connections.HubSpotHUBSPOTHUBSPOT1 IN / 1 OUTEXTRACT CAMPAIGN DATA. integration node, httpRequest. 1 incoming and 1 outgoing connections.EXTRACT CAMPAIGN DATAINTEGRATIONHTTPREQUEST1 IN / 1 OUTIf. decision node, if. 1 incoming and 2 outgoing connections.IfDECISIONIF1 IN / 2 OUTPostgres1. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.Postgres1POSTGRESQLPOSTGRES1 IN / 1 OUTCode. transform node, code. 1 incoming and 1 outgoing connections.CodeTRANSFORMCODE1 IN / 1 OUTUPDATE CAMPAIGN. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.UPDATE CAMPAIGNPOSTGRESQLPOSTGRES1 IN / 1 OUTHUBSPOT TABLE. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.HUBSPOT TABLEPOSTGRESQLPOSTGRES1 IN / 1 OUTUPSERT CAMPAIGN ACTIVITY. PostgreSQL node, postgres. 1 incoming and 2 outgoing connections.UPSERT CAMPAIGN ACTIVITYPOSTGRESQLPOSTGRES1 IN / 2 OUTUPDATE HUBSPOT ACTIVITY TABLE. PostgreSQL node, postgres. 1 incoming and 1 outgoing connections.UPDATE HUBSPOT ACTIVITY T…POSTGRESQLPOSTGRES1 IN / 1 OUTMerge. decision node, merge. 3 incoming and 1 outgoing connections.MergeDECISIONMERGE3 IN / 1 OUT

Signal inspector

Focus, hover, or select a node to illuminate its real path.

Execution linkSupport dependencytriggeraidecisiontransformintegration
Scroll horizontally to follow every connected flow.18 connected nodesEnter or click to lock · Escape to clear

Execution breakdown

Follow each connected flow from start to outcome.

The readable view below uses the same graph relationships as the interactive map. Each row is a connected flow; columns advance only when an actual link connects the nodes.

01

Connected Flow

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