Audit CRM lead data quality with Google Sheets and NeverBounce

by Atharva Ashtekar ✓ · 3 views · created 2026-09-10 · CRM, AI Summarization

What this workflow does

This workflow has 27 nodes and runs on a schedule (cron 0 0 20 * * 0). Along the way it connects Google Sheets. It also calls api.neverbounce.com over HTTP.

How it runs

Trigger: On a schedule (cron 0 0 20 * * 0).

1. config (Code): runs custom JavaScript code
2. [cred] Sheets - read leads (Google Sheets): uses Google Sheets
3. audit and safe autofix (Code): runs custom JavaScript code
4. prepare audit results (Code): runs custom JavaScript code
5. anything to write back? (If): checks a condition and branches into true / false
6. prepare safe fixes for Leads (Code): runs custom JavaScript code
7. writes enabled? (If): checks a condition and branches into true / false
8. Merge: merges the data from its input branches
9. [cred] Sheets - update safe fixes in place (Google Sheets): update
10. pick stale addresses (Code): runs custom JavaScript code

…plus 12 more steps. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: api.neverbounce.com

Before you upgrade to n8n 3.0

Nodes used (7)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• No Operation, do nothingn8n-nodes-base.noOp
• Mergen8n-nodes-base.merge
• Ifn8n-nodes-base.if
• HTTP Requestn8n-nodes-base.httpRequest

From the author

Quick overview This workflow runs weekly to audit and clean CRM lead data in Google Sheets, optionally revalidating stale emails via NeverBounce, then logs a data quality summary and human-review items back to Google Sheets and can post the report to a…

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