Automation library · Lead generation

Local business leads and run AI-powered cold email sequences

Started by a clock, and works across Gmail and Google Sheets. It hands the judgement calls to Gemini. 62 steps, 9 branches, 8 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini

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

The flow

Starts it 5Model 1Logic 36Service 18

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

  1. 1Trigger: Generate AI EmailsSchedule triggerStarts it
  2. 2Trigger: Send Intro EmailsSchedule triggerStarts it
  3. 3Trigger: Send Follow Up 1Schedule triggerStarts it
  4. 4Trigger: Send Follow Up 2Schedule triggerStarts it
  5. 5Trigger: Lead Scraping (GMaps)Schedule triggerStarts it
  6. 6Get row(s) in sheetGoogle SheetsService
  7. 7Get row(s) in sheet1Google SheetsService
  8. 8Get row(s) in sheet4Google SheetsService
  9. 9Get row(s) in sheet5Google SheetsService
  10. 10SettingsSetLogic
  11. 11Check: Intro Mail EmptyIfLogic
  12. 12Check: Intro Ready & Not SentIfLogic
  13. 13Check: Follow Up 1 DueIfLogic
  14. 14Check: Follow Up 2 DueIfLogic
  15. 15Get Zip CodesGoogle SheetsService
  16. 16Loop: Generate AI EmailsSplit In BatchesLogic
  17. 17Loop: Send Intro EmailsSplit In BatchesLogic
  18. 18Loop: Send Follow Up 1Split In BatchesLogic
  19. 19Loop: Send Follow Up 2Split In BatchesLogic
  20. 20ZipsSetLogic
  21. 21Email WriterGoogle GeminiModel
  22. 22Send Intro MailGmailService
  23. 23Check Follow Up 1 DateCodeLogic
  24. 24Check Follow Up 2 DateCodeLogic
  25. 25Filter ZipsFilterLogic
  26. 26Update row in sheetGoogle SheetsService
  27. 27Generate Follow Up DatesCodeLogic
  28. 28Follow Up Mail 1GmailService
  29. 29Follow Up Mail 2GmailService
  30. 30Split OutSplit OutLogic
  31. 31Update Row with all Follow Up Mail DatesGoogle SheetsService
  32. 32Update row with follow up status 1Google SheetsService
  33. 33Update row in sheet3Google SheetsService
  34. 34Limit: Zips Per RunLimitLogic
  35. 35Map Zip FieldSetLogic
  36. 36Get CategoryGoogle SheetsService
  37. 37Merge Zips & CategoriesMergeLogic
  38. 38Build Zip × Category MatrixCodeLogic
  39. 39Set ZipSetLogic
  40. 40Loop SubcatsSplit In BatchesLogic
  41. 41Set Zip1SetLogic
  42. 42GMaps APIHttp RequestService
  43. 43Check: GMaps Result EmptyIfLogic
  44. 44Split Places ArrayCodeLogic
  45. 45Scrape URLHttp RequestService
  46. 46Extract Emails From WebsiteCodeLogic
  47. 47Check: Email FoundIfLogic
  48. 48Add rows in Google SheetsGoogle SheetsService
  49. 49Get StatusGoogle SheetsService
  50. 50Calc Retry Delay (Add Rows)CodeLogic
  51. 51Update Status to SuccessGoogle SheetsService
  52. 52Calc Retry Delay (Get Status)CodeLogic
  53. 53Wait: Backoff Before Retry (Add Rows)WaitLogic
  54. 54Calc Retry Delay (Update Status)CodeLogic
  55. 55Wait: Backoff Before Retry (Get Status)WaitLogic
  56. 56Check: Retry Limit (Add Rows)IfLogic
  57. 57Wait: Backoff Before Retry (Update Status)WaitLogic
  58. 58Check: Retry Limit (Get Status)IfLogic
  59. 59Stop and Error1Stop And ErrorLogic
  60. 60Check: Retry Limit (Sheet Update)IfLogic

How it's built

Starts on
A clock
Steps
62, with 9 branches, 8 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets
Model
Gemini

Questions

What does it need to run?

An n8n account, plus your own Gmail and Google Sheets accounts, and a key for Gemini. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls Gemini. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 62 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 62 steps before you point it at anything that matters.