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

by WeblineIndia ✓ · 160 views · created 2026-04-22 · CRM, AI Summarization

What this workflow does

This workflow has 11 nodes and runs on a schedule (every hour). Along the way it connects Zoho CRM and Gmail.

How it runs

Trigger: On a schedule (every hour).

1. Fetch Zoho CRM Records (Zoho CRM): get many (lead)
2. Split Records for Processing (Code): runs custom JavaScript code
3. Validate Email Addresses (Code): runs custom JavaScript code
4. Normalize Phone Numbers (Code): runs custom JavaScript code
5. Detect Duplicate Records (Code): runs custom JavaScript code
6. Enrich Missing Company Data (Code): runs custom JavaScript code
7. Generate Quality Flags (Code): runs custom JavaScript code
8. Generate Quality Summary Report (Code): runs custom JavaScript code
9. Format CRM Report to HTML (Code): runs custom JavaScript code
10. Send Data Quality Report Email (Gmail): uses Gmail

Services it uses

Zoho CRMGmail

Before you upgrade to n8n 3.0

Nodes used (4)

• Zoho CRMn8n-nodes-base.zohoCrm
• Coden8n-nodes-base.code
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Gmailn8n-nodes-base.gmail

From the author

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…

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