Convert CSV/XLSX files into a normalized SQL schema with GPT-4

by ResilNext ✓ · 102 views · created 2026-03-25 · Document Extraction, AI Summarization

What this workflow does

This AI workflow has 14 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.

1. Workflow Configuration (Edit Fields (Set)): sets 3 fields: fkOverlapThreshold, maxNormalizationDepth, minUniquePercentForPK
2. Check File Type (If): checks a condition and branches into true / false
3. Extract CSV Data (Extract from File): extracts data from a file
4. Extract Excel Data (Extract from File): extracts data from a file (xlsx)
5. Column Profiling Engine (Code): runs custom JavaScript code
6. Aggregate: combines items into one
7. Schema Reasoning Agent (AI Agent): runs an AI agent, with model: OpenAI GPT; output parser: Schema JSON Parser
8. Rule Validator (Code): runs custom JavaScript code
9. SQL Schema Generator (Code): runs custom JavaScript code
10. Generate Data Dictionary & ERD (Code): runs custom JavaScript code

…plus 1 more step. See the full node list below.

Services it uses

OpenAI Chat Model

Before you upgrade to n8n 3.0

Nodes used (10)

• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• Ifn8n-nodes-base.if
• Extract from Filen8n-nodes-base.extractFromFile
• Coden8n-nodes-base.code
• Aggregaten8n-nodes-base.aggregate
• AI Agent@n8n/n8n-nodes-langchain.agent
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Respond to Webhookn8n-nodes-base.respondToWebhook
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi

From the author

Automatically converts CSV/XLSX files into a fully validated database schema using AI, generating SQL scripts, ERD diagrams, a data dictionary, and load plans to accelerate database design and data onboarding. --- EXPLANATION This workflow automates the…

View the original on n8n.io → Check your own copy