Skip to Workflow Atlas
ETL (Extract, Transform, Load) PipelineAI systemIntermediate

Company Data Enrichment Workflow

Company Data Enrichment Workflow is a 12-node automation blueprint connecting OpenAI, Google Sheets, ScrapingBee. 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.

12

Nodes

11

Links

2

Run groups

Connected tools

3 integrations

  • OpenAI
  • Google Sheets
  • ScrapingBee

Canvas controls

Fit wide systems, then zoom into any run group.

Company Data Enrichment Workflow execution lanes2 run groups containing 12 workflow nodes and 11 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.Webhook. trigger node, webhook. 0 incoming and 1 outgoing connections.STARTWebhookTRIGGERWEBHOOK0 IN / 1 OUTGet rows from Google Sheet. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 02Get rows from Google SheetGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTLoop Over Items. integration node, splitInBatches. 2 incoming and 2 outgoing connections.STEP 03Loop Over ItemsINTEGRATIONSPLITINBATCHES2 IN / 2 OUTAI Agent. ai node, agent. 4 incoming and 1 outgoing connections.STEP 04AI AgentAIAGENT4 IN / 1 OUTUpdate Company's Row on Google Sheet. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.OUTCOMEUpdate Company's Row on G…GOOGLE SHEETSGOOGLESHEETS1 IN / 0 OUTOpenAI Chat Model. OpenAI node, lmChatOpenAi. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1OpenAI Chat ModelOPENAILMCHATOPENAI0 IN / 1 OUTStructured Output Parser. ai node, outputParserStructured. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1Structured Output ParserAIOUTPUTPARSERSTRUCTURED0 IN / 1 OUTCall n8n workflow : Scrape companies homepage content. ai node, toolWorkflow. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1Call n8n workflow : Scra…AITOOLWORKFLOW0 IN / 1 OUTTool called from Agent. trigger node, executeWorkflowTrigger. 0 incoming and 1 outgoing connections.STARTTool called from AgentTRIGGEREXECUTEWORKFLOWTRIGGER0 IN / 1 OUTSet company url. transform node, set. 1 incoming and 1 outgoing connections.STEP 02Set company urlTRANSFORMSET1 IN / 1 OUTScrapingBee : Scrape company's homepage data . integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 03ScrapingBee : Scrape comp…INTEGRATIONHTTPREQUEST1 IN / 1 OUTHTML to Markdown. integration node, markdown. 1 incoming and 0 outgoing connections.OUTCOMEHTML to MarkdownINTEGRATIONMARKDOWN1 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.12 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

Webhook

5 Execution Links3 Support Dependencies
  1. Start

    Webhook

    Trigger

  2. Step 2

    Get rows from Google Sheet

    Integration

  3. Step 3

    Loop Over Items

    Integration

  4. Step 4

    AI Agent

    AI reasoning

  5. Outcome

    Update Company's Row on Google Sheet

    Integration

Attached dependencies

These nodes support the runtime above; they are not additional starts or outcomes.

3 nodes
  • OpenAI Chat Model

    AI reasoning dependency

  • Structured Output Parser

    AI reasoning dependency

  • Call n8n workflow : Scrape companies homepage content

    AI reasoning dependency

02

Run Group

Tool called from Agent

3 Execution Links
  1. Start

    Tool called from Agent

    Trigger

  2. Step 2

    Set company url

    Transform

  3. Step 3

    ScrapingBee : Scrape company's homepage data

    Integration

  4. Outcome

    HTML to Markdown

    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.