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

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.

24

Nodes

22

Links

2

Flows

Connected tools

3 integrations

  • OpenAI
  • Google Sheets
  • Qdrant
Automated Review Analysis and Export execution lanes2 connected flows containing 24 workflow nodes and 22 visible links. Solid lines are execution links and dashed lines are support dependencies. Focus any node to inspect its immediate path.When clicking ‘Test workflow’. trigger node, manualTrigger. 0 incoming and 1 outgoing connections.When clicking ‘Test workf…TRIGGERMANUALTRIGGER0 IN / 1 OUTEmbeddings OpenAI. OpenAI node, embeddingsOpenAi. 0 incoming and 1 outgoing connections.Embeddings OpenAIOPENAIEMBEDDINGSOPENAI0 IN / 1 OUTRecursive Character Text Splitter. ai node, textSplitterRecursiveCharacterTextSplitter. 0 incoming and 1 outgoing connections.Recursive Character Text …AITEXTSPLITTERRECURSIVECH0 IN / 1 OUTSet Variables. transform node, set. 1 incoming and 1 outgoing connections.Set VariablesTRANSFORMSET1 IN / 1 OUTDefault Data Loader. ai node, documentDefaultDataLoader. 1 incoming and 1 outgoing connections.Default Data LoaderAIDOCUMENTDEFAULTDATALOAD1 IN / 1 OUTClear Existing Reviews. integration node, httpRequest. 1 incoming and 1 outgoing connections.Clear Existing ReviewsINTEGRATIONHTTPREQUEST1 IN / 1 OUTGet TrustPilot Page. integration node, httpRequest. 1 incoming and 1 outgoing connections.Get TrustPilot PageINTEGRATIONHTTPREQUEST1 IN / 1 OUTExtract Reviews. integration node, html. 1 incoming and 1 outgoing connections.Extract ReviewsINTEGRATIONHTML1 IN / 1 OUTZip Entries. transform node, set. 1 incoming and 1 outgoing connections.Zip EntriesTRANSFORMSET1 IN / 1 OUTReviews to List. transform node, splitOut. 1 incoming and 1 outgoing connections.Reviews to ListTRANSFORMSPLITOUT1 IN / 1 OUTQdrant Vector Store. ai node, vectorStoreQdrant. 3 incoming and 1 outgoing connections.Qdrant Vector StoreAIVECTORSTOREQDRANT3 IN / 1 OUTPrep Values For Trigger. transform node, set. 1 incoming and 1 outgoing connections.Prep Values For TriggerTRANSFORMSET1 IN / 1 OUTTrigger Insights. integration node, executeWorkflow. 1 incoming and 0 outgoing connections.Trigger InsightsINTEGRATIONEXECUTEWORKFLOW1 IN / 0 OUTExecute Workflow Trigger. trigger node, executeWorkflowTrigger. 0 incoming and 1 outgoing connections.Execute Workflow TriggerTRIGGEREXECUTEWORKFLOWTRIGGER0 IN / 1 OUTOpenAI Chat Model. OpenAI node, lmChatOpenAi. 0 incoming and 1 outgoing connections.OpenAI Chat ModelOPENAILMCHATOPENAI0 IN / 1 OUTSet Variables1. transform node, set. 1 incoming and 1 outgoing connections.Set Variables1TRANSFORMSET1 IN / 1 OUTFind Reviews. integration node, httpRequest. 1 incoming and 1 outgoing connections.Find ReviewsINTEGRATIONHTTPREQUEST1 IN / 1 OUTApply K-means Clustering Algorithm. transform node, code. 1 incoming and 1 outgoing connections.Apply K-means Clustering …TRANSFORMCODE1 IN / 1 OUTClusters To List. transform node, splitOut. 1 incoming and 1 outgoing connections.Clusters To ListTRANSFORMSPLITOUT1 IN / 1 OUTOnly Clusters With 3+ points. decision node, filter. 1 incoming and 1 outgoing connections.Only Clusters With 3+ poi…DECISIONFILTER1 IN / 1 OUTGet Payload of Points. integration node, httpRequest. 1 incoming and 1 outgoing connections.Get Payload of PointsINTEGRATIONHTTPREQUEST1 IN / 1 OUTCustomer Insights Agent. ai node, informationExtractor. 2 incoming and 1 outgoing connections.Customer Insights AgentAIINFORMATIONEXTRACTOR2 IN / 1 OUTPrep Output For Export. transform node, set. 1 incoming and 1 outgoing connections.Prep Output For ExportTRANSFORMSET1 IN / 1 OUTExport To Sheets. Google Sheets node, googleSheets. 1 incoming and 0 outgoing connections.Export To SheetsGOOGLE SHEETSGOOGLESHEETS1 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.24 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

When clicking ‘Test workflow’

9 Execution Links3 Support Dependencies
  1. Start

    When clicking ‘Test workflow’

    Trigger

    Embeddings OpenAI

    AI reasoning

    Recursive Character Text Splitter

    AI reasoning

  2. Step 2

    Set Variables

    Transform

    Default Data Loader

    AI reasoning

  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

02

Connected Flow

Execute Workflow Trigger

9 Execution Links1 Support Dependency
  1. Start

    Execute Workflow Trigger

    Trigger

    OpenAI Chat Model

    AI reasoning

  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

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.