Skip to Workflow Atlas
ETL Pipeline with AI EnhancementAI systemIntermediate

Automated Review Aggregation and Notification

Automated Review Aggregation and Notification is a 12-node automation blueprint connecting Bright Data, OpenAI, Google Sheets. 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

12

Links

1

Run groups

Connected tools

4 integrations

  • Bright Data
  • OpenAI
  • Google Sheets
  • Gmail

Canvas controls

Fit wide systems, then zoom into any run group.

Automated Review Aggregation and Notification execution lanes1 run groups containing 12 workflow nodes and 12 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.On form submission - Discover Jobs. trigger node, formTrigger. 0 incoming and 1 outgoing connections.STARTOn form submission - Disc…TRIGGERFORMTRIGGER0 IN / 1 OUTHTTP Request- Post API call to Bright Data. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 02HTTP Request- Post API ca…INTEGRATIONHTTPREQUEST1 IN / 1 OUTWait - Polling Bright Data. integration node, wait. 2 incoming and 1 outgoing connections.STEP 03Wait - Polling Bright DataINTEGRATIONWAIT2 IN / 1 OUTSnapshot Progress. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 04Snapshot ProgressINTEGRATIONHTTPREQUEST1 IN / 1 OUTIf - Checking status of Snapshot - if data is ready or not. decision node, if. 1 incoming and 2 outgoing connections.STEP 05If - Checking status of S…DECISIONIF1 IN / 2 OUTHTTP Request - Getting data from Bright Data. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 06HTTP Request - Getting da…INTEGRATIONHTTPREQUEST1 IN / 1 OUTGoogle Sheets - Adding All Reviews. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 07Google Sheets - Adding Al…GOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTFiltering only bad reviews. decision node, filter. 1 incoming and 1 outgoing connections.STEP 08Filtering only bad reviewsDECISIONFILTER1 IN / 1 OUTAggregating all filtered reviews. transform node, aggregate. 1 incoming and 1 outgoing connections.STEP 09Aggregating all filtered …TRANSFORMAGGREGATE1 IN / 1 OUTBasic LLM Chain. ai node, chainLlm. 2 incoming and 1 outgoing connections.STEP 10Basic LLM ChainAICHAINLLM2 IN / 1 OUTSend Summary To Marketers. Gmail node, gmail. 1 incoming and 0 outgoing connections.OUTCOMESend Summary To MarketersGMAILGMAIL1 IN / 0 OUTOpenAI Chat Model. OpenAI node, lmChatOpenAi. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1OpenAI Chat ModelOPENAILMCHATOPENAI0 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.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

On form submission - Discover …

11 Execution Links1 Support Dependency
  1. Start

    On form submission - Discover Jobs

    Trigger

  2. Step 2

    HTTP Request- Post API call to Bright Data

    Integration

  3. Step 3

    Wait - Polling Bright Data

    Integration

  4. Step 4

    Snapshot Progress

    Integration

  5. Step 5

    If - Checking status of Snapshot - if data is ready or not

    Decision

  6. Step 6

    HTTP Request - Getting data from Bright Data

    Integration

  7. Step 7

    Google Sheets - Adding All Reviews

    Integration

  8. Step 8

    Filtering only bad reviews

    Decision

  9. Step 9

    Aggregating all filtered reviews

    Transform

  10. Step 10

    Basic LLM Chain

    AI reasoning

  11. Outcome

    Send Summary To Marketers

    Integration

Attached dependencies

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

1 node
  • OpenAI Chat Model

    AI reasoning dependency

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.