Skip to Workflow Atlas
ETL PipelineIntermediate

Automated Competitor Review Aggregator

Automated Competitor Review Aggregator is a 11-node automation blueprint connecting ScrapingBee, Google Sheets, Slack. 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.

11

Nodes

11

Links

1

Run groups

Connected tools

3 integrations

  • ScrapingBee
  • Google Sheets
  • Slack

Canvas controls

Fit wide systems, then zoom into any run group.

Automated Competitor Review Aggregator execution lanes1 run groups containing 11 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.Execute workflow every day. trigger node, scheduleTrigger. 0 incoming and 2 outgoing connections.STARTExecute workflow every dayTRIGGERSCHEDULETRIGGER0 IN / 2 OUTGet all past reviews. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 02Get all past reviewsGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTAdd your competitors here. transform node, code. 1 incoming and 1 outgoing connections.STEP 02Add your competitors hereTRANSFORMCODE1 IN / 1 OUTGet G2 data with ScrapingBee. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 03Get G2 data with Scraping…INTEGRATIONHTTPREQUEST1 IN / 1 OUTGet review section HTML. integration node, html. 1 incoming and 1 outgoing connections.STEP 04Get review section HTMLINTEGRATIONHTML1 IN / 1 OUTIterate on reviews. transform node, itemLists. 1 incoming and 1 outgoing connections.STEP 05Iterate on reviewsTRANSFORMITEMLISTS1 IN / 1 OUTExtract structured data. integration node, html. 1 incoming and 1 outgoing connections.STEP 06Extract structured dataINTEGRATIONHTML1 IN / 1 OUTConvert Review HTML to Markdown. integration node, markdown. 1 incoming and 1 outgoing connections.STEP 07Convert Review HTML to Ma…INTEGRATIONMARKDOWN1 IN / 1 OUTContinue only if review is new. decision node, merge. 2 incoming and 2 outgoing connections.STEP 08Continue only if review i…DECISIONMERGE2 IN / 2 OUTSend new review to Slack. Slack node, slack. 1 incoming and 0 outgoing connections.OUTCOMESend new review to SlackSLACKSLACK1 IN / 0 OUTAdd new review to Google Sheets. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.OUTCOMEAdd new review to Google …GOOGLE SHEETSGOOGLESHEETS1 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.11 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

Execute workflow every day

11 Execution Links
  1. Start

    Execute workflow every day

    Trigger

  2. Step 2

    Get all past reviews

    Integration

    Add your competitors here

    Transform

  3. Step 3

    Get G2 data with ScrapingBee

    Integration

  4. Step 4

    Get review section HTML

    Integration

  5. Step 5

    Iterate on reviews

    Transform

  6. Step 6

    Extract structured data

    Integration

  7. Step 7

    Convert Review HTML to Markdown

    Integration

  8. Step 8

    Continue only if review is new

    Decision

  9. Outcome

    Send new review to Slack

    Integration

    Add new review to Google Sheets

    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.