Automation library · Lead generation

Scrape Google Maps by area & generate outreach messages

Started by someone submitting a form, and works across Postgres. It hands the judgement calls to Gemini and OpenAI. 27 steps, 4 branches, 3 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini, OpenAI

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

The flow

Starts it 2Model 5Logic 15Service 5

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

  1. 1On form submissionForm triggerStarts it
  2. 2When clicking ‘Execute workflow’Manual triggerStarts it
  3. 3scrape_as_markdownMcp Client ToolModel
  4. 4Google Gemini Chat ModelLm Chat Google GeminiModel
  5. 5gpt-5-miniLm Chat Open AiModel
  6. 6Extract latitude and logitude from URLSetLogic
  7. 7Create TablePostgresService
  8. 8Scrape & SummarizeAgentModel
  9. 9Message GeneratorChain LlmModel
  10. 10Bright Data | Request dataHttp RequestService
  11. 11Set FieldsSetLogic
  12. 12Supabase | Upsert rowPostgresService
  13. 13Count1SetLogic
  14. 14MergeMergeLogic
  15. 15Loop Over ItemsSplit In BatchesLogic
  16. 16No Operation, do nothing4No OpLogic
  17. 17Company website existsIfLogic
  18. 18Check status of data extractionBright DataService
  19. 19Request finishedIfLogic
  20. 20Download the snapshot contentBright DataService
  21. 21Reached retry limitIfLogic
  22. 22Snapshot finished buildingIfLogic
  23. 23Wait5WaitLogic
  24. 24Organize dataSetLogic
  25. 25WaitWaitLogic
  26. 26Count Increment1SetLogic
  27. 27Set LimitLimitLogic

How it's built

Starts on
Someone submitting a form
Steps
27, with 4 branches, 3 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Postgres
Model
Gemini, OpenAI

Questions

What does it need to run?

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

What starts it?

It starts on someone submitting a form.

Does it use AI?

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

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.