Audit Zoho CRM lead data quality and email HTML reports with Gmail

Zoho CRM Data Quality Guardian using n8n Schedule, Code & Email Nodes

🚀 Quick Start Guide

This n8n workflow automatically audits your Zoho CRM leads on a schedule, cleans and validates emails and phone numbers, detects duplicates, enriches missing company data, generates a structured quality report and sends it as a styled HTML email. It helps maintain a clean, reliable CRM without manual effort.

⚡ Quick Implementation Steps

1. Import the workflow into n8n 2. Connect your Zoho CRM credentials 3. Configure Email (SMTP/Gmail/Outlook) credentials 4. Set the module (Leads is used by default) 5. Configure the Schedule Trigger (hourly/daily) 6. Run a test execution 7. Check the email report in your inbox

---

📌 What It Does

This workflow acts as an automated data quality auditor for your Zoho CRM. It runs on a scheduled basis and fetches all lead records, then processes each record individually through a series of validation and transformation steps. Email addresses are cleaned and validated using a regex pattern, while phone numbers are standardized into a consistent international format.