Normalize and validate CSV data with Anthropic/OpenAI, Postgres, Slack and Sheets

Overview This workflow automates CSV data processing from upload to database insertion.

It accepts CSV files via webhook, uses AI to detect schema and standardize columns, cleans and validates the data, and stores it in Postgres. Errors are logged separately, and notifications are sent for visibility.

---

How It Works

1. CSV Upload A webhook receives CSV files for processing.

2. Validation The workflow checks if the uploaded file is a valid CSV format. Invalid files are rejected with an error report.

3. Data Extraction The CSV is parsed into structured rows for further processing.

4. Schema Detection AI analyzes the data to: - Infer column types - Normalize column names - Detect inconsistencies