Automation library · Lead generation

Generate leads with Google Maps

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

Large

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

The flow

Starts it 3Logic 27Service 6

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

  1. 1When clicking "Execute Workflow"Manual triggerStarts it
  2. 2Run workflow every hoursSchedule triggerStarts it
  3. 3Execute Workflow TriggerExecute Workflow triggerStarts it
  4. 4SettingsSetLogic
  5. 5GS - Get Zip CodesGoogle SheetsService
  6. 6ZipsSetLogic
  7. 7Filter ZipsFilterLogic
  8. 8Set Row NumberSetLogic
  9. 9Split OutSplit OutLogic
  10. 10LimitLimitLogic
  11. 11Loop ZipsSplit In BatchesLogic
  12. 12GS - Get SubcategoryGoogle SheetsService
  13. 13Filter SubcategoriesFilterLogic
  14. 14SubcategorySetLogic
  15. 15Loop SubcatsSplit In BatchesLogic
  16. 16Set ZipSetLogic
  17. 17GMaps APIHttp RequestService
  18. 18If EmptyIfLogic
  19. 19Place ArrayCodeLogic
  20. 20Set Place IDSetLogic
  21. 21Remove DuplicatesRemove DuplicatesLogic
  22. 22Add rows in Google SheetsGoogle SheetsService
  23. 23GS - Get StatusGoogle SheetsService
  24. 24Exponential BackoffCodeLogic
  25. 25Update Status to SuccessGoogle SheetsService
  26. 26Exponential Backoff2CodeLogic
  27. 27WaitWaitLogic
  28. 28Exponential Backoff1CodeLogic
  29. 29Wait2WaitLogic
  30. 30Check Max Retries1IfLogic
  31. 31Wait1WaitLogic
  32. 32Check Max Retries2IfLogic
  33. 33Stop and Error1Stop And ErrorLogic
  34. 34Check Max RetriesIfLogic
  35. 35Stop and Error2Stop And ErrorLogic
  36. 36Stop and ErrorStop And ErrorLogic

How it's built

Starts on
A clock
Steps
36, with 4 branches, 5 loops or waits
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 36 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 36 steps before you point it at anything that matters.