Skip to Workflow Atlas
ETL PipelineAI systemIntermediate

Survey Data Processing & Insights Generation

Survey Data Processing & Insights Generation is a 30-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.

30

Nodes

30

Links

2

Run groups

Connected tools

3 integrations

  • OpenAI
  • Google Sheets
  • Qdrant

Canvas controls

Fit wide systems, then zoom into any run group.

Survey Data Processing & Insights Generation execution lanes2 run groups containing 30 workflow nodes and 30 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 OUTGet Survey Results. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 02Get Survey ResultsGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTConvert to Question Answer Pairs. transform node, set. 1 incoming and 1 outgoing connections.STEP 03Convert to Question Answe…TRANSFORMSET1 IN / 1 OUTQA Pairs to List. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 04QA Pairs to ListTRANSFORMSPLITOUT1 IN / 1 OUTQdrant Vector Store. ai node, vectorStoreQdrant. 3 incoming and 1 outgoing connections.STEP 05Qdrant Vector StoreAIVECTORSTOREQDRANT3 IN / 1 OUTPrep Values For Trigger. transform node, set. 1 incoming and 1 outgoing connections.STEP 06Prep 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 OUTGet Sheet Details. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 02Get Sheet DetailsINTEGRATIONHTTPREQUEST1 IN / 1 OUTSet Variables. transform node, set. 1 incoming and 1 outgoing connections.STEP 03Set VariablesTRANSFORMSET1 IN / 1 OUTCreate Insights Sheet. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 04Create Insights SheetGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTGet Survey Headers. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 05Get Survey HeadersGOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTExtract Questions. transform node, set. 1 incoming and 1 outgoing connections.STEP 06Extract QuestionsTRANSFORMSET1 IN / 1 OUTQuestions to List. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 07Questions to ListTRANSFORMSPLITOUT1 IN / 1 OUTFor Each Question.... integration node, splitInBatches. 3 incoming and 1 outgoing connections.STEP 08For Each Question...INTEGRATIONSPLITINBATCHES3 IN / 1 OUTFind All Answers. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 09Find All AnswersINTEGRATIONHTTPREQUEST1 IN / 1 OUTApply K-means Clustering Algorithm. transform node, code. 1 incoming and 1 outgoing connections.STEP 10Apply K-means Clustering …TRANSFORMCODE1 IN / 1 OUTHas Clusters?. decision node, if. 1 incoming and 2 outgoing connections.STEP 11Has Clusters?DECISIONIF1 IN / 2 OUTClusters To List. transform node, splitOut. 1 incoming and 1 outgoing connections.STEP 12Clusters To ListTRANSFORMSPLITOUT1 IN / 1 OUTOnly Clusters With 3+ points. decision node, filter. 1 incoming and 1 outgoing connections.STEP 13Only Clusters With 3+ poi…DECISIONFILTER1 IN / 1 OUTPrep Values For Export. transform node, set. 1 incoming and 1 outgoing connections.STEP 14Prep Values For ExportTRANSFORMSET1 IN / 1 OUTExport To Sheets1. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.STEP 15Export To Sheets1GOOGLE SHEETSGOOGLESHEETS1 IN / 1 OUTGet Payload of Points. integration node, httpRequest. 1 incoming and 1 outgoing connections.STEP 16Get Payload of PointsINTEGRATIONHTTPREQUEST1 IN / 1 OUTSurvey Insights Agent. ai node, informationExtractor. 2 incoming and 1 outgoing connections.STEP 17Survey Insights AgentAIINFORMATIONEXTRACTOR2 IN / 1 OUTPrep Output For Export. transform node, set. 1 incoming and 1 outgoing connections.STEP 18Prep Output For ExportTRANSFORMSET1 IN / 1 OUTExport To Sheets. Google Sheets node, googleSheets. 1 incoming and 1 outgoing connections.OUTCOMEExport To SheetsGOOGLE SHEETSGOOGLESHEETS1 IN / 1 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.30 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’

6 Execution Links3 Support Dependencies
  1. Start

    When clicking ‘Test workflow’

    Trigger

  2. Step 2

    Get Survey Results

    Integration

  3. Step 3

    Convert to Question Answer Pairs

    Transform

  4. Step 4

    QA Pairs to List

    Transform

  5. Step 5

    Qdrant Vector Store

    AI reasoning

  6. Step 6

    Prep Values For Trigger

    Transform

  7. 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

20 Execution Links1 Support Dependency
  1. Start

    Execute Workflow Trigger

    Trigger

  2. Step 2

    Get Sheet Details

    Integration

  3. Step 3

    Set Variables

    Transform

  4. Step 4

    Create Insights Sheet

    Integration

  5. Step 5

    Get Survey Headers

    Integration

  6. Step 6

    Extract Questions

    Transform

  7. Step 7

    Questions to List

    Transform

  8. Step 8

    For Each Question...

    Integration

  9. Step 9

    Find All Answers

    Integration

  10. Step 10

    Apply K-means Clustering Algorithm

    Transform

  11. Step 11

    Has Clusters?

    Decision

  12. Step 12

    Clusters To List

    Transform

  13. Step 13

    Only Clusters With 3+ points

    Decision

  14. Step 14

    Prep Values For Export

    Transform

  15. Step 15

    Export To Sheets1

    Integration

  16. Step 16

    Get Payload of Points

    Integration

  17. Step 17

    Survey Insights Agent

    AI reasoning

  18. Step 18

    Prep Output For Export

    Transform

  19. 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.