Ai data extraction with dynamic prompts and Baserow
Ready for 3.0What this workflow does
This AI workflow has 30 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI Chat Model.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Table Fields API (HTTP Request): calls an HTTP API
- Get Prompt Fields (Code): runs custom JavaScript code
- Get Event Body (Edit Fields (Set)): sets or maps fields
- Event Type (Switch): routes items into 3 branches
- Rows to List (Split Out): splits a list into separate items
- Filter: keeps only the items that match a condition
- Filter: keeps only the items that match a condition
- List Table API (HTTP Request): calls an HTTP API
- Get Row (HTTP Request): calls an HTTP API
- Get Valid Rows (Code): runs custom JavaScript code
…plus 13 more steps. See the full node list below.
Services it uses
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 (12)
- Webhook
n8n-nodes-base.webhook - Switch
n8n-nodes-base.switch - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set - Extract from File
n8n-nodes-base.extractFromFile - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Split Out
n8n-nodes-base.splitOut - Filter
n8n-nodes-base.filter - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
This n8n template introduces the Dynamic Prompts AI workflow pattern which are incredible for certain types of data extraction tasks where attributes are unknown or need to remain flexible. The general idea behind this pattern is that the prompts for…