Clean & Standardize CSV for Google Sheets & Drive Import

This n8n workflow processes messy CSV uploads by parsing content, validating structure, and normalizing column names. It removes duplicates (by email or all fields), deletes empty rows, standardizes emails (lowercase, validated), phone numbers (normalized formats), capitalizes names, trims text, and assigns data quality scores to each row.

Benefits include time savings on manual data prep, improved data accuracy for analytics/CRM, and audit-ready reports showing rows processed, duplicates removed, and quality metrics. It handles files up to 10MB, generates cleaned CSVs saved to Google Drive, and optionally clears/re-imports into Sheets for always-fresh master sheets.

Ideal use cases: Preparing customer lists/sales leads for CRM imports, standardizing product catalogs for e-commerce, cleaning survey data for reporting, or maintaining datasets in Sheets/Drive. Perfect for IT teams, marketers, and data analysts needing reliable file conversions without coding.

Key integrations: Webhook for uploads, Google Drive for storage, Google Sheets for direct import, with comprehensive logging for compliance.