Clean & standardize CSV uploads for Google Sheets and Drive import

by David Olusola ✓ · 919 views · created 2025-08-30 · Document Extraction

What this workflow does

This workflow has 9 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Drive and Google Sheets.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

1. Extract CSV Content (Code): runs custom JavaScript code
2. Parse CSV Data (Code): runs custom JavaScript code
3. Clean & Standardize Data (Code): runs custom JavaScript code
4. Generate Clean CSV (Code): runs custom JavaScript code
5. Save to Google Drive (Google Drive): uses Google Drive
6. Clear Existing Sheet (Google Sheets): clear
7. Prepare for Sheets (Code): runs custom JavaScript code
8. Import to Google Sheets (Google Sheets): append

Services it uses

Google DriveGoogle Sheets

Before you upgrade to n8n 3.0

Nodes used (4)

• Webhookn8n-nodes-base.webhook
• Coden8n-nodes-base.code
• Google Driven8n-nodes-base.googleDrive
• Google Sheetsn8n-nodes-base.googleSheets

From the author

🧹 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,…

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