Automation library · Lead generation

Zip code-based business lead generation with Google Maps

Started by a clock, and works across Discord, Google Sheets and Telegram. 27 steps, 3 branches, 4 loops or waits: large, and worth reading before you trust it with anything live.

Large

27 stepsLarge: read it before trusting it with anything live
3Branches: places the flow splits
4Loops or waits
3Services it connects to

The flow

Starts it 1Logic 17Service 9

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

  1. 1ScheduleSchedule triggerStarts it
  2. 2Get All Zip CodeGoogle SheetsService
  3. 3LimitLimitLogic
  4. 4LoopSplit In BatchesLogic
  5. 5Get Subcategory form sheetGoogle SheetsService
  6. 6Filter subcategoriFilterLogic
  7. 7get subcategorySetLogic
  8. 8Loop SubcatsSplit In BatchesLogic
  9. 9Set zipSetLogic
  10. 10Google Map APIHttp RequestService
  11. 11IfIfLogic
  12. 12PlaceCodeLogic
  13. 13Set PlaceSetLogic
  14. 14Remove DuplicatesRemove DuplicatesLogic
  15. 15Add rows in Google SheetsGoogle SheetsService
  16. 16Get StatusGoogle SheetsService
  17. 17Exponential BackoffCodeLogic
  18. 18Update Status to SuccessGoogle SheetsService
  19. 19Do nothingNo OpLogic
  20. 20WaitWaitLogic
  21. 21Exponential Backoff1CodeLogic
  22. 22RapiwaRapiwaService
  23. 23Send a text messageTelegramService
  24. 24Send a messageDiscordService
  25. 25Check Max RetriesIfLogic
  26. 26Wait1WaitLogic
  27. 27Check maximum retries.IfLogic

How it's built

Starts on
A clock
Steps
27, with 3 branches, 4 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Discord, Google Sheets, Telegram
Model
None. This is plumbing, not judgement

Questions

What does it need to run?

An n8n account, plus your own Discord, Google Sheets and Telegram 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 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.