Normalize and validate customer data with Google Sheets highlights

by Reiji Sugiyama ✓ · 12 views · created 2026-05-27 · Document Extraction

What this workflow does

This workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Read Raw Input (Google Sheets): uses Google Sheets
2. Map Source Fields (Edit Fields (Set)): sets or maps fields
3. Normalize Customer Data (Code): runs custom JavaScript code
4. Validate Record Quality (If): checks a condition and branches into true / false
5. Save Normalized Records (Google Sheets): append
6. Save Review Queue (Google Sheets): append
7. Build Highlight Requests Normal (Code): runs custom JavaScript code
8. Build Highlight Requests Review (Code): runs custom JavaScript code
9. Apply Normalized Sheet Cell Highlights (HTTP Request): calls an HTTP API (POST)
10. Apply Review Queue Cell Highlights (HTTP Request): calls an HTTP API (POST)

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

Nodes used (6)

• Google Sheetsn8n-nodes-base.googleSheets
• Manual Triggern8n-nodes-base.manualTrigger
• Edit Fields (Set)n8n-nodes-base.set
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow manually pulls raw customer records from Google Sheets, normalizes and scores key fields (name, phone, address, gender, dates), then routes results to either a normalized master sheet or a review queue and uses the Google Sheets…

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