Create a Lookio RAG assistant from a CSV text corpus
Ready for 3.0What this workflow does
This workflow has 9 nodes and runs when someone submits an n8n form (“CSV”). It uses only n8n's built-in nodes. It also calls api.lookio.app over HTTP.
How it runs
Trigger: When someone submits an n8n form (“CSV”).
- Convert CSV to JSON (Extract from File): extracts data from a file
- Convert to txt (Convert to File): converts data to a file (to text)
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Aggregate: combines items into one
- Import resource to Lookio (HTTP Request): calls api.lookio.app (POST)
- Convert IDs into an Array (Edit Fields (Set)): sets 1 field: IDs
- Create Lookio assistant (HTTP Request): calls api.lookio.app (POST)
- Success message form ending (n8n Form): shows the next form page
HTTP calls to: api.lookio.app
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Convert to File
n8n-nodes-base.convertToFile - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Extract from File
n8n-nodes-base.extractFromFile - n8n Form Trigger
n8n-nodes-base.formTrigger - Aggregate
n8n-nodes-base.aggregate - Edit Fields (Set)
n8n-nodes-base.set - n8n Form
n8n-nodes-base.form - HTTP Request
n8n-nodes-base.httpRequest
From the author
This advanced template automates the creation of a Lookio Assistant populated with a specific corpus of text. Instead of uploading files one by one, you can simply upload a CSV containing multiple text resources. The workflow iterates through the rows,…