Automation library · Lead generation

Audit CRM lead data quality with Google Sheets and NeverBounce

Started by a clock, and works across Google Sheets. 27 steps, 5 branches: large, and worth reading before you trust it with anything live.

Large

Download free
27 stepsLarge: read it before trusting it with anything live
5Branches: places the flow splits
0Loops or waits
1Service it connects to

The flow

Starts it 1Logic 19Service 7

The steps in the order they run, from what starts it.

  1. 1Sunday 20:00Schedule triggerStarts it
  2. 2configCodeLogic
  3. 3[cred] Sheets - read leadsGoogle SheetsService
  4. 4audit and safe autofixCodeLogic
  5. 5prepare audit resultsCodeLogic
  6. 6anything to write back?IfLogic
  7. 7prepare safe fixes for LeadsCodeLogic
  8. 8sheet was already cleanNo OpLogic
  9. 9writes enabled?IfLogic
  10. 10mergeMergeLogic
  11. 11[cred] Sheets - update safe fixes in placeGoogle SheetsService
  12. 12STOP: dry run - nothing writtenNo OpLogic
  13. 13pick stale addressesCodeLogic
  14. 14NeverBounce configured?IfLogic
  15. 15anything stale?IfLogic
  16. 16merge recheckMergeLogic
  17. 17[cred] NeverBounce - recheckHttp RequestService
  18. 18nothing to recheckNo OpLogic
  19. 19build quality reportCodeLogic
  20. 20apply recheck resultsCodeLogic
  21. 21[cred] Sheets - log quality summaryGoogle SheetsService
  22. 22[cred] Sheets - write recheck resultsGoogle SheetsService
  23. 23prepare human review itemsCodeLogic
  24. 24Webhook configured?IfLogic
  25. 25[cred] Sheets - log human review itemsGoogle SheetsService
  26. 26[cred] Post the reportHttp RequestService
  27. 27EndNo OpLogic

How it's built

Starts on
A clock
Steps
27, with 5 branches
Size
Large: read it before trusting it with anything live
Connects to
Google Sheets
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Google Sheets account. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

No. Every step is fixed logic or a call to a service, so it does the same thing every time.

How long does it take to set up?

Take your time. At 27 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 27 steps before you point it at anything that matters.