Automation library · Lead generation

Generate, score, and send B2B leads with Airtable

Started by a clock, and works across Airtable and Email. 83 steps, 11 branches, 2 loops or waits: large, and worth reading before you trust it with anything live.

Large

Download free
83 stepsLarge: read it before trusting it with anything live
11Branches: places the flow splits
2Loops or waits
2Services it connects to

The flow

Starts it 4Logic 34Service 22

The steps in the order they run, from what starts it. The first 60 of 83.

  1. 1Manual Lead Discovery TriggerManual triggerStarts it
  2. 2Scheduled Lead DiscoverySchedule triggerStarts it
  3. 3Scheduled Lead ScoringSchedule triggerStarts it
  4. 4Scheduled Outreach ProcessingSchedule triggerStarts it
  5. 5Set Lead Discovery ConfigSetLogic
  6. 6Set Scoring ConfigSetLogic
  7. 7Set Outreach ConfigSetLogic
  8. 8Check Lead Discovery ConfigCodeLogic
  9. 9Verify Scoring ConfigCodeLogic
  10. 10Check Outreach ConfigCodeLogic
  11. 11Build Search MatrixCodeLogic
  12. 12Fetch Scoring LeadsAirtableService
  13. 13Fetch Approved Send LeadsAirtableService
  14. 14Fetch Awaiting Approval LeadsAirtableService
  15. 15Batch Process SearchesSplit In BatchesLogic
  16. 16Compute Opportunity ScoreCodeLogic
  17. 17Set Approved Send DetailsSetLogic
  18. 18Set Approval Queue DataSetLogic
  19. 19Split PlacesSplit OutLogic
  20. 20Post Places SearchHttp RequestService
  21. 21Create Lead RecommendationCodeLogic
  22. 22Log Approval TimestampAirtableService
  23. 23Craft Professional MessageCodeLogic
  24. 24Store Approval Queue in CRMAirtableService
  25. 25Deduplicate by IDRemove DuplicatesLogic
  26. 26Set Search ContextSetLogic
  27. 27Handle Places API ErrorStop And ErrorLogic
  28. 28Log Scoring in CRMAirtableService
  29. 29Confirm Email EligibilityIfLogic
  30. 30Confirm WhatsApp EligibilityIfLogic
  31. 31Confirm Instagram EligibilityIfLogic
  32. 32Set Lead DetailsSetLogic
  33. 33Wait 2 SecondsWaitLogic
  34. 34Route Leads by PrioritySwitchLogic
  35. 35Flag Email as SendingHttp RequestService
  36. 36Organize WhatsApp Send DetailsSetLogic
  37. 37Create Instagram Send DetailsSetLogic
  38. 38Sync Lead with CRM by IDAirtableService
  39. 39Prepare High Priority OutreachCodeLogic
  40. 40Prepare Moderate Priority OutreachCodeLogic
  41. 41Set Low Priority OutreachSetLogic
  42. 42Dispatch Approved EmailEmail SendService
  43. 43Verify WhatsApp EligibilityIfLogic
  44. 44Verify Instagram EligibilityIfLogic
  45. 45Verify Website ExistsIfLogic
  46. 46Save High Priority OutreachAirtableService
  47. 47Save Moderate Priority OutreachAirtableService
  48. 48Save Low Priority to CRMAirtableService
  49. 49Flag Email as SentAirtableService
  50. 50Flag Email as FailedHttp RequestService
  51. 51Flag WhatsApp as SendingHttp RequestService
  52. 52Arrange WhatsApp Manual ReviewSetLogic
  53. 53Flag Instagram as SendingHttp RequestService
  54. 54Organize Instagram Manual ReviewSetLogic
  55. 55Check Valid WebsiteIfLogic
  56. 56Flag No Website in CRMAirtableService
  57. 57Dispatch WhatsApp MessageHttp RequestService
  58. 58Log WhatsApp Manual ReviewHttp RequestService
  59. 59Dispatch Instagram DMHttp RequestService
  60. 60Log Instagram Manual ReviewHttp RequestService

How it's built

Starts on
A clock
Steps
83, with 11 branches, 2 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Airtable, Email
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Airtable and Email accounts. 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 83 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 83 steps before you point it at anything that matters.