Automation library · Lead generation

US medical leads finder – GPT + Serper + Findymail + Sheets

Started by a clock, and works across Google Sheets. It hands the judgement calls to OpenAI. 26 steps, 4 branches, 5 loops or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
26 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 1Model 3Logic 18Service 4

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

  1. 1Schedule TriggerSchedule triggerStarts it
  2. 2Message a model2Open AiModel
  3. 3Prepare Search QueriesCodeLogic
  4. 4Loop Over Items3Split In BatchesLogic
  5. 5Query Pagination ManagerCodeLogic
  6. 6Wait6WaitLogic
  7. 7Search Websites Depicted On a Given Google Search PageHttp RequestService
  8. 8Provide Search ResultsMergeLogic
  9. 9Check Search ResultsCodeLogic
  10. 10No search results?IfLogic
  11. 11Prepare Parsed Companies for PaginationMergeLogic
  12. 12Flatten Search Results: For GPT to AnalyzeCodeLogic
  13. 13Extract Company Info from Search ResultsOpen AiModel
  14. 14Parse JSON Array from Model OutputCodeLogic
  15. 15Loop Over ItemsSplit In BatchesLogic
  16. 16WaitWaitLogic
  17. 17Linkedin CEO Search From Website XYZHttp RequestService
  18. 18Iterate Organic ResultsCodeLogic
  19. 19If1IfLogic
  20. 20Extract Owner/Executive/Leader infoOpen AiModel
  21. 21If2IfLogic
  22. 22Parse CEO InfoCodeLogic
  23. 23IfIfLogic
  24. 24Wait2WaitLogic
  25. 25Append or update row in sheetGoogle SheetsService
  26. 26Linkedin CEO/Exec SearchHttp RequestService

How it's built

Starts on
A clock
Steps
26, with 4 branches, 5 loops or waits
Size
Large: read it before trusting it with anything live
Connects to
Google Sheets
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Google Sheets account, and a key for OpenAI. 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 OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

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