Normalize and validate customer data with Google Sheets highlights
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 API to highlight missing cells. How it works 1. Starts on a manual trigger and reads raw customer data from a Google Sheets sheet named rawinput. 2. Maps incoming columns into a consistent internal structure (record ID, source, dates, and pos
At a glance
Normalize and validate customer data with Google Sheets highlights is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets
- Modules
- 11
- Price
- Free
- Version
- v1.0

About this workflow
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 API to highlight missing cells. How it works 1. Starts on a manual trigger and reads raw customer data from a Google Sheets sheet named rawinput. 2. Maps incoming columns into a consistent internal structure (record ID, source, dates, and postal code) for downstream processing. 3. Normalizes customer fields (name formatting, phone and postal-code digits, gender mapping, prefecture/address splitting, and date formatting) and computes a completeness score plus a review reason. 4. Checks whether the record meets the quality threshold (completeness score 6 80) to determine if it is acceptable. 5. Appends accepted records to the normalizedmaster sheet and sends a Google Sheets batchUpdate request to highlight any empty cells. 6. Appends records needing attention to the reviewqueue sheet and sends a Google Sheets batchUpdate request to highlight empty cells for faster review. Setup 1. Create a Google Sheets OAuth2 credential in n8n and connect it to this workflow. 2. Replace YOURSPREADSHEETID in all Google Sheets and HTTP Request nodes with your target spreadsheet ID. 3. Ensure the spreadsheet contains sheets named rawinput, normalizedmaster, and reviewqueue with columns that match the fields written by the workflow (for example: name, email, phone, prefecture, address, birthdate, status, completenessscore, and reviewreason). 4. Verify the sheet tab IDs used for highlighting (1144211222 for normalizedmaster and 1278913705 for reviewqueue) match your spreadsheet, and update them if they differ. 5. (Optional) Adjust the quality threshold (currently completeness score 6 80) and normalization rules in the code to match your data requirements.
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Save Facebook pages posts to a Google Sheets spreadsheet
Generate content ideas with Gemini Pro and store in Google Sheets
Add a new row to a Google Sheets spreadsheet from a new message in WhatsApp Business Cloud
Lead generation automate on LinkedIn - personalisation, enrichment
Use the Math service to evaluate math expressions specified in a Google Sheets spreadsheet
Generate bulk Google Slides certificates 📜 as PDFs and email them with Gmail
Analyze hotel reviews with OpenAI GPT-4o-mini and Airtable sentiment fields
Scrape LinkedIn job listings for hiring signals & prospecting with Bright Data
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you