How I Built an Automated Data-Cleaning Pipeline with n8n (So I Never Touch Messy Spreadsheets Again)

说明与用途

n8n 自动化工作流清理 Google 表单数据，标准化姓名、邮箱、手机号和日期，生成唯一 ID，并输出干净的 Excel 文件和摘要报告，消除手动清理的需要。

问题

Manual cleanup of Google Form submissions becomes tedious due to inconsistent names, duplicate emails, malformed phone numbers, and varied date formats.

结果

The pipeline eliminates weekly manual cleanup, reduces errors from duplicates or typos, provides instant summary reports, and scales from 10 to 10,000 submissions without additional effort.

工作流

• Trigger on new Google Form submission
• Pull raw row into Code node
• Normalize name to title case
• Validate and deduplicate email
• Normalize phone number to 01XXXXXXXXX
• Convert date to YYYY-MM-DD
• Generate unique Customer ID
• Split output to clean master file and summary report
• Write clean data to Excel
• Send summary report

证据

A raw form submissions sheet usually looks something like this: ...

来源

A form submission triggers the workflow, pulls in the raw row, runs it through a Code node that handles all the normalization logic...

来源