Clean & standardize CSV uploads for Google Sheets and Drive import

🧹 Auto-Clean CSV Uploads Before Import

This workflow automatically cleans, validates, and standardizes any CSV file you upload. Perfect for preparing customer lists, sales leads, product catalogs, or any messy datasets before pushing them into Google Sheets, Google Drive, or other systems.

---

⚙️ How It Works

1. CSV Upload (Webhook) - Upload your CSV via webhook (supports form-data, base64, or binary file upload). - Handles files up to ~10MB comfortably.

2. Extract & Parse - Reads raw CSV content. - Validates file structure and headers. - Detects and normalizes column names (e.g. First Name → firstname).

3. Clean & Standardize Data - Removes duplicate rows (based on email or all fields). - Deletes empty rows. - Standardizes fields: - Emails → lowercased, validated format. - Phone numbers → normalized (xxx) xxx-xxxx or +1 format. - Names → capitalized (John Smith). - Text → trims spaces & fixes inconsistent spacing. - Assigns each row a data quality score so you know how “clean” it is.

4. Generate Cleaned CSV - Produces a cleaned CSV file with the same headers. - Saves to Google Drive (optional). - Ready for immediate import into Sheets or any app.