Automation library · Lead generation

Google Maps to Airtable lead scraper with OpenAI

Started by an event in a connected app, and works across Airtable. It hands the judgement calls to OpenAI. 27 steps, 1 branch, 5 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

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

The flow

Starts it 2Model 2Logic 15Service 8

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

  1. 1OpenAI Chat ModelLm Chat Open AiModel
  2. 2When Executed by Another WorkflowExecute Workflow triggerStarts it
  3. 3When clicking ‘Execute workflow’Manual triggerStarts it
  4. 4Relevant Infos from ImpressumInformation ExtractorModel
  5. 5already scrapedAirtableService
  6. 6Airtable2AirtableService
  7. 7WaitWaitLogic
  8. 8Array all Companies scrapedSummarizeService
  9. 9Filter5FilterLogic
  10. 10Loop Over Items1Split In BatchesLogic
  11. 11SearchwordSetLogic
  12. 12Loop Over Items2Split In BatchesLogic
  13. 13Email not EmptyFilterLogic
  14. 14search PlaceHttp RequestService
  15. 15Execute WorkflowExecute WorkflowLogic
  16. 16Edit Fields1SetLogic
  17. 17Split OutSplit OutLogic
  18. 18Airtable1AirtableService
  19. 19Write in DBAirtableService
  20. 20Place DetailsHttp RequestService
  21. 21Places already scrapedIfLogic
  22. 22Get Impressum-URLSetLogic
  23. 23Loop Over Items3Split In BatchesLogic
  24. 24Successfully scraped Impressumpages?FilterLogic
  25. 25Get Impressum HTMLHttp RequestService
  26. 26HTMLHtmlLogic
  27. 27Wait2WaitLogic

How it's built

Starts on
An event in a connected app
Steps
27, with 1 branch, 5 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Airtable
Model
OpenAI

Questions

What does it need to run?

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

What starts it?

It starts on an event in a connected app.

Does it use AI?

Yes. It calls 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.