Skip to Workflow Atlas
ETL PipelineAI systemIntermediate

Automated Review Analysis and Export

Automated Review Analysis and Export is a 24-node automation blueprint connecting OpenAI, Google Sheets, Qdrant. 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.

24

Nodes

22

Links

2

Run groups

Connected tools

3 integrations

  • OpenAI
  • Google Sheets
  • Qdrant

Canvas controls

Fit wide systems, then zoom into any run group.

Automated Review Analysis and Export execution lanes2 run groups containing 24 workflow nodes and 22 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.When clicking ‘Test workflow’. trigger node, manualTrigger. 0 incoming and 1 outgoing connections.STARTWhen clicking ‘Test workf…TRIGGERMANUALTRIGGER0 IN / 1 OUTSet Variables. transform node, set. 1 incoming and 1 outgoing connections.STEP 02Set VariablesTRANSFORMSET1 IN / 1 OUTClear Existing Reviews. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 03Clear Existing ReviewsINTEGRATIONHTTPREQUEST1 IN / 1 OUTGet TrustPilot Page. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 04Get TrustPilot PageINTEGRATIONHTTPREQUEST1 IN / 1 OUTExtract Reviews. integration node, html. 1 incoming and 1 outgoing connections.STEP 05Extract ReviewsINTEGRATIONHTML1 IN / 1 OUTZip Entries. transform node, set. 1 incoming and 1 outgoing connections.STEP 06Zip EntriesTRANSFORMSET1 IN / 1 OUTReviews to List. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 07Reviews to ListTRANSFORMSPLITOUT1 IN / 1 OUTQdrant Vector Store. ai node, vectorStoreQdrant. 3 incoming and 1 outgoing connections.STEP 08Qdrant Vector StoreAIVECTORSTOREQDRANT3 IN / 1 OUTPrep Values For Trigger. transform node, set. 1 incoming and 1 outgoing connections.STEP 09Prep Values For TriggerTRANSFORMSET1 IN / 1 OUTTrigger Insights. integration node, executeWorkflow. 1 incoming and 0 outgoing connections.OUTCOMETrigger InsightsINTEGRATIONEXECUTEWORKFLOW1 IN / 0 OUTEmbeddings OpenAI. OpenAI node, embeddingsOpenAi. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1Embeddings OpenAIOPENAIEMBEDDINGSOPENAI0 IN / 1 OUTDefault Data Loader. ai node, documentDefaultDataLoader. 1 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1Default Data LoaderAIDOCUMENTDEFAULTDATALOAD1 IN / 1 OUTRecursive Character Text Splitter. ai node, textSplitterRecursiveCharacterTextSplitter. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 2Recursive Character Text …AITEXTSPLITTERRECURSIVECH0 IN / 1 OUTExecute Workflow Trigger. trigger node, executeWorkflowTrigger. 0 incoming and 1 outgoing connections.STARTExecute Workflow TriggerTRIGGEREXECUTEWORKFLOWTRIGGER0 IN / 1 OUTSet Variables1. transform node, set. 1 incoming and 1 outgoing connections.STEP 02Set Variables1TRANSFORMSET1 IN / 1 OUTFind Reviews. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 03Find ReviewsINTEGRATIONHTTPREQUEST1 IN / 1 OUTApply K-means Clustering Algorithm. transform node, code. 1 incoming and 1 outgoing connections.STEP 04Apply K-means Clustering …TRANSFORMCODE1 IN / 1 OUTClusters To List. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 05Clusters To ListTRANSFORMSPLITOUT1 IN / 1 OUTOnly Clusters With 3+ points. decision node, filter. 1 incoming and 1 outgoing connections.STEP 06Only Clusters With 3+ poi…DECISIONFILTER1 IN / 1 OUTGet Payload of Points. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 07Get Payload of PointsINTEGRATIONHTTPREQUEST1 IN / 1 OUTCustomer Insights Agent. ai node, informationExtractor. 2 incoming and 1 outgoing connections.STEP 08Customer Insights AgentAIINFORMATIONEXTRACTOR2 IN / 1 OUTPrep Output For Export. transform node, set. 1 incoming and 1 outgoing connections.STEP 09Prep Output For ExportTRANSFORMSET1 IN / 1 OUTExport To Sheets. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.OUTCOMEExport To SheetsGOOGLE SHEETSGOOGLESHEETS1 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.24 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

When clicking ‘Test workflow’

9 Execution Links3 Support Dependencies
  1. Start

    When clicking ‘Test workflow’

    Trigger

  2. Step 2

    Set Variables

    Transform

  3. Step 3

    Clear Existing Reviews

    Integration

  4. Step 4

    Get TrustPilot Page

    Integration

  5. Step 5

    Extract Reviews

    Integration

  6. Step 6

    Zip Entries

    Transform

  7. Step 7

    Reviews to List

    Transform

  8. Step 8

    Qdrant Vector Store

    AI reasoning

  9. Step 9

    Prep Values For Trigger

    Transform

  10. Outcome

    Trigger Insights

    Integration

Attached dependencies

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

3 nodes
  • Embeddings OpenAI

    AI reasoning dependency

  • Default Data Loader

    AI reasoning dependency

  • Recursive Character Text Splitter

    AI reasoning dependency

02

Run Group

Execute Workflow Trigger

9 Execution Links1 Support Dependency
  1. Start

    Execute Workflow Trigger

    Trigger

  2. Step 2

    Set Variables1

    Transform

  3. Step 3

    Find Reviews

    Integration

  4. Step 4

    Apply K-means Clustering Algorithm

    Transform

  5. Step 5

    Clusters To List

    Transform

  6. Step 6

    Only Clusters With 3+ points

    Decision

  7. Step 7

    Get Payload of Points

    Integration

  8. Step 8

    Customer Insights Agent

    AI reasoning

  9. Step 9

    Prep Output For Export

    Transform

  10. Outcome

    Export To Sheets

    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.