Webhook

CSV Clean‑Up Automation

Detects missing or malformed rows in an uploaded CSV, generates correction suggestions via OpenAI, and saves a cleaned version.

n8nHub

İndir

İstatistikler

Görüntülenme 35
Beğeni 1
İndirme 2

Kurulum Kılavuzu

1. Add a **Webhook** node (POST) to receive the CSV file.
2. Connect a **Spreadsheet File** node set to *Read* the incoming binary data as CSV.
3. Add an **IF** node to check for empty cells or rows with inconsistent column counts.
4. For rows that fail the check, use an **OpenAI** node (Chat Completion) with a prompt that asks for a corrected version of the row.
5. Merge the corrected rows with the valid rows using a **Merge** node (Append).
6. Pass the merged data to another **Spreadsheet File** node set to *Write* CSV.
7. Store the cleaned file with a **Google Drive** (or **FTP**) node, or return it directly from the **Webhook** response.
8. Activate the workflow and test by POST‑ing a CSV file to the webhook URL.