Ingest Excel data into Oracle and chat with it using Select AI and Azure OpenAI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Oracle Database.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Validate & Normalize File (Code): runs custom JavaScript code
- Configure Select AI Profile (Edit Fields (Set)): sets 1 field: profileName
- Extract from Excel (Extract from File): extracts data from a file (xlsx)
- Oracle Select AI Query (Oracle Database): execute
- Infer Schema & Table Name (Code): runs custom JavaScript code
- Format Chat Response (Code): runs custom JavaScript code
- Create Oracle Table (Oracle Database): execute
- Split into Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Restore Data Rows (Code): runs custom JavaScript code
- Insert Rows into Oracle (Oracle Database): uses Oracle Database
…plus 4 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 (8)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Extract from File
n8n-nodes-base.extractFromFile - Oracle Database
n8n-nodes-base.oracleDatabase - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - Respond to Webhook
n8n-nodes-base.respondToWebhook - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger
From the author
Overview This n8n workflow template enables querying Excel data stored in an Oracle Database using natural language powered by Oracle Select AI. The solution consists of two workflows: - Workflow A uploads an Excel file, creates a table in Oracle Database,…