Skip to Workflow Atlas
ETL PipelineAI systemIntermediate

Client and Owner Data Integration Workflow

Client and Owner Data Integration Workflow is a 36-node automation blueprint connecting HubSpot, Google Sheets, Gmail. 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.

36

Nodes

37

Links

4

Run groups

Connected tools

3 integrations

  • HubSpot
  • Google Sheets
  • Gmail

Canvas controls

Fit wide systems, then zoom into any run group.

Client and Owner Data Integration Workflow execution lanes4 run groups containing 32 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.Get list of clients. integration node, executeWorkflow. 0 incoming and 1 outgoing connections.STARTGet list of clientsINTEGRATIONEXECUTEWORKFLOW0 IN / 1 OUTChange this for testing. decision node, filter. 1 incoming and 1 outgoing connections.STEP 02Change this for testingDECISIONFILTER1 IN / 1 OUTCreate entry with email. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 03Create entry with emailGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTGet rows from document. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 04Get rows from documentGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTIf linkedin url is empty. decision node, if. 1 incoming and 2 outgoing connections.STEP 05If linkedin url is emptyDECISIONIF1 IN / 2 OUTSearch for user profile by names. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 06Search for user profile b…INTEGRATIONHTTPREQUEST1 IN / 1 OUTSet the profile URL1. transform node, set. 1 incoming and 1 outgoing connections.STEP 06Set the profile URL1TRANSFORMSET1 IN / 1 OUTProfile URL not found?. decision node, if. 1 incoming and 2 outgoing connections.STEP 07Profile URL not found?DECISIONIF1 IN / 2 OUTDo nothing. integration node, noOp. 1 incoming and 0 outgoing connections.STEP 08Do nothingINTEGRATIONNOOP1 IN / 0 OUTSet the profile URL. transform node, set. 1 incoming and 1 outgoing connections.STEP 08Set the profile URLTRANSFORMSET1 IN / 1 OUTMerge profileURL. transform node, code. 2 incoming and 1 outgoing connections.STEP 09Merge profileURLTRANSFORMCODE2 IN / 1 OUTSearch for user by link. integration node, httpRequest. 1 incoming and 2 outgoing connections.STEP 10Search for user by linkINTEGRATIONHTTPREQUEST1 IN / 2 OUTGet last post. integration node, executeWorkflow. 1 incoming and 1 outgoing connections.STEP 11Get last postINTEGRATIONEXECUTEWORKFLOW1 IN / 1 OUTSet last_position. transform node, set. 1 incoming and 1 outgoing connections.STEP 11Set last_positionTRANSFORMSET1 IN / 1 OUTSet last_post. transform node, set. 1 incoming and 1 outgoing connections.STEP 12Set last_postTRANSFORMSET1 IN / 1 OUTif new position. decision node, if. 1 incoming and 1 outgoing connections.STEP 12if new positionDECISIONIF1 IN / 1 OUTif new post. decision node, if. 1 incoming and 1 outgoing connections.STEP 13if new postDECISIONIF1 IN / 1 OUTUpdates last position. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 13Updates last positionGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTUpdate last post. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 14Update last postGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTSet position_updated. transform node, set. 1 incoming and 0 outgoing connections.STEP 14Set position_updatedTRANSFORMSET1 IN / 0 OUTSet post_updated. transform node, set. 1 incoming and 0 outgoing connections.OUTCOMESet post_updatedTRANSFORMSET1 IN / 0 OUTWhen clicking ‘Test workflow’. trigger node, manualTrigger. 0 incoming and 1 outgoing connections.STARTWhen clicking ‘Test workf…TRIGGERMANUALTRIGGER0 IN / 1 OUTSet data here. transform node, set. 1 incoming and 1 outgoing connections.STEP 02Set data hereTRANSFORMSET1 IN / 1 OUTGet list of owners. integration node, httpRequest. 1 incoming and 0 outgoing connections.OUTCOMEGet list of ownersINTEGRATIONHTTPREQUEST1 IN / 0 OUTGmail. Gmail node, gmail. 0 incoming and 0 outgoing connections.CORE RUNTIMEGmailGMAILGMAIL0 IN / 0 OUTWhen Executed by Another Workflow. trigger node, executeWorkflowTrigger. 0 incoming and 1 outgoing connections.STARTWhen Executed by Another …TRIGGEREXECUTEWORKFLOWTRIGGER0 IN / 1 OUTEdit. transform node, set. 1 incoming and 1 outgoing connections.STEP 02EditTRANSFORMSET1 IN / 1 OUTGet list of clients for owner. integration node, httpRequest. 2 incoming and 1 outgoing connections.STEP 03Get list of clients for o…INTEGRATIONHTTPREQUEST2 IN / 1 OUTIncrement Page. transform node, set. 1 incoming and 1 outgoing connections.STEP 04Increment PageTRANSFORMSET1 IN / 1 OUTIf. decision node, if. 1 incoming and 2 outgoing connections.STEP 05IfDECISIONIF1 IN / 2 OUTMerge al the entries. transform node, code. 1 incoming and 1 outgoing connections.STEP 06Merge al the entriesTRANSFORMCODE1 IN / 1 OUTSplit Out1. transform node, splitOut. 1 incoming and 0 outgoing connections.OUTCOMESplit Out1TRANSFORMSPLITOUT1 IN / 0 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.Showing 32 of 36 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

Get list of clients

21 Execution Links
  1. Start

    Get list of clients

    Integration

  2. Step 2

    Change this for testing

    Decision

  3. Step 3

    Create entry with email

    Integration

  4. Step 4

    Get rows from document

    Integration

  5. Step 5

    If linkedin url is empty

    Decision

  6. Step 6

    Search for user profile by names

    Integration

    Set the profile URL1

    Transform

  7. Step 7

    Profile URL not found?

    Decision

  8. Step 8

    Do nothing

    Integration

    Set the profile URL

    Transform

  9. Step 9

    Merge profileURL

    Transform

  10. Step 10

    Search for user by link

    Integration

  11. Step 11

    Get last post

    Integration

    Set last_position

    Transform

  12. Step 12

    Set last_post

    Transform

    if new position

    Decision

  13. Step 13

    if new post

    Decision

    Updates last position

    Integration

  14. Step 14

    Update last post

    Integration

    Set position_updated

    Transform

  15. Outcome

    Set post_updated

    Transform

02

Run Group

When clicking ‘Test workflow’

2 Execution Links
  1. Start

    When clicking ‘Test workflow’

    Trigger

  2. Step 2

    Set data here

    Transform

  3. Outcome

    Get list of owners

    Integration

03

Run Group

Gmail

0 Execution Links
  1. Core Runtime

    Gmail

    Integration

04

Run Group

When Executed by Another Workf…

7 Execution Links
  1. Start

    When Executed by Another Workflow

    Trigger

  2. Step 2

    Edit

    Transform

  3. Step 3

    Get list of clients for owner

    Integration

  4. Step 4

    Increment Page

    Transform

  5. Step 5

    If

    Decision

  6. Step 6

    Merge al the entries

    Transform

  7. Outcome

    Split Out1

    Transform

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.