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

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.

36

Nodes

37

Links

4

Flows

Connected tools

3 integrations

  • HubSpot
  • Google Sheets
  • Gmail
Client and Owner Data Integration Workflow execution lanes4 connected flows containing 32 workflow nodes and 30 visible links. Solid lines are execution links and dashed lines are support dependencies. Focus any node to inspect its immediate path.Get list of clients. integration node, executeWorkflow. 0 incoming and 1 outgoing connections.Get list of clientsINTEGRATIONEXECUTEWORKFLOW0 IN / 1 OUTChange this for testing. decision node, filter. 1 incoming and 1 outgoing connections.Change this for testingDECISIONFILTER1 IN / 1 OUTCreate entry with email. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.Create entry with emailGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTGet rows from document. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.Get rows from documentGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTIf linkedin url is empty. decision node, if. 1 incoming and 2 outgoing connections.If linkedin url is emptyDECISIONIF1 IN / 2 OUTSearch for user profile by names. integration node, httpRequest. 1 incoming and 1 outgoing connections.Search for user profile b…INTEGRATIONHTTPREQUEST1 IN / 1 OUTSet the profile URL1. transform node, set. 1 incoming and 1 outgoing connections.Set the profile URL1TRANSFORMSET1 IN / 1 OUTProfile URL not found?. decision node, if. 1 incoming and 2 outgoing connections.Profile URL not found?DECISIONIF1 IN / 2 OUTDo nothing. integration node, noOp. 1 incoming and 0 outgoing connections.Do nothingINTEGRATIONNOOP1 IN / 0 OUTSet the profile URL. transform node, set. 1 incoming and 1 outgoing connections.Set the profile URLTRANSFORMSET1 IN / 1 OUTMerge profileURL. transform node, code. 2 incoming and 1 outgoing connections.Merge profileURLTRANSFORMCODE2 IN / 1 OUTSearch for user by link. integration node, httpRequest. 1 incoming and 2 outgoing connections.Search for user by linkINTEGRATIONHTTPREQUEST1 IN / 2 OUTGet last post. integration node, executeWorkflow. 1 incoming and 1 outgoing connections.Get last postINTEGRATIONEXECUTEWORKFLOW1 IN / 1 OUTSet last_position. transform node, set. 1 incoming and 1 outgoing connections.Set last_positionTRANSFORMSET1 IN / 1 OUTSet last_post. transform node, set. 1 incoming and 1 outgoing connections.Set last_postTRANSFORMSET1 IN / 1 OUTif new position. decision node, if. 1 incoming and 1 outgoing connections.if new positionDECISIONIF1 IN / 1 OUTif new post. decision node, if. 1 incoming and 1 outgoing connections.if new postDECISIONIF1 IN / 1 OUTUpdates last position. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.Updates last positionGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTUpdate last post. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.Update last postGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTSet position_updated. transform node, set. 1 incoming and 0 outgoing connections.Set position_updatedTRANSFORMSET1 IN / 0 OUTSet post_updated. transform node, set. 1 incoming and 0 outgoing connections.Set post_updatedTRANSFORMSET1 IN / 0 OUTWhen clicking ‘Test workflow’. trigger node, manualTrigger. 0 incoming and 1 outgoing connections.When clicking ‘Test workf…TRIGGERMANUALTRIGGER0 IN / 1 OUTSet data here. transform node, set. 1 incoming and 1 outgoing connections.Set data hereTRANSFORMSET1 IN / 1 OUTGet list of owners. integration node, httpRequest. 1 incoming and 0 outgoing connections.Get list of ownersINTEGRATIONHTTPREQUEST1 IN / 0 OUTGmail. Gmail node, gmail. 0 incoming and 0 outgoing connections.GmailGMAILGMAIL0 IN / 0 OUTWhen Executed by Another Workflow. trigger node, executeWorkflowTrigger. 0 incoming and 1 outgoing connections.When Executed by Another …TRIGGEREXECUTEWORKFLOWTRIGGER0 IN / 1 OUTEdit. transform node, set. 1 incoming and 1 outgoing connections.EditTRANSFORMSET1 IN / 1 OUTGet list of clients for owner. integration node, httpRequest. 2 incoming and 1 outgoing connections.Get list of clients for o…INTEGRATIONHTTPREQUEST2 IN / 1 OUTIncrement Page. transform node, set. 1 incoming and 1 outgoing connections.Increment PageTRANSFORMSET1 IN / 1 OUTIf. decision node, if. 1 incoming and 2 outgoing connections.IfDECISIONIF1 IN / 2 OUTMerge al the entries. transform node, code. 1 incoming and 1 outgoing connections.Merge al the entriesTRANSFORMCODE1 IN / 1 OUTSplit Out1. transform node, splitOut. 1 incoming and 0 outgoing connections.Split Out1TRANSFORMSPLITOUT1 IN / 0 OUT

Signal inspector

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

Execution linkSupport dependencytriggeraidecisiontransformintegration
Scroll horizontally to follow every connected flow.Showing 32 of 36 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

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

Connected Flow

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

Connected Flow

Gmail

0 Execution Links
  1. Connected Nodes

    Gmail

    Integration

04

Connected Flow

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.