DevSource: AY Automate

CSV Import Data Cleaning Pipeline

Runs an uploaded CSV through a standard cleaning pass — trimming whitespace, normalizing phone/email formats, dropping exact duplicates — before it's imported anywhere, so bad data doesn't propagate downstream.

What this template does

Runs an uploaded CSV through a standard cleaning pass — trimming whitespace, normalizing phone/email formats, dropping exact duplicates — before it's imported anywhere, so bad data doesn't propagate downstream. It's categorized in our directory under Dev & Agent Automation agent coordination, CI/CD glue, and developer-tool integrations — including our own Claude Code + n8n templates.

Integrations

  • Google Sheets
    Google Sheets

Setup steps

  1. 1Trigger on new file upload to a watched folder.
  2. 2Trim whitespace and normalize phone/email formatting.
  3. 3Drop exact duplicate rows.
  4. 4Write the cleaned file to a destination folder or import target.

More Dev templates

Other dev & agent automation templates in our directory.