Automation library · Lead generation

Extract sales leads from Google Jobs, LinkedIn & Indeed

Started by a clock, and works across Apify, Gmail, Google Sheets and Slack. It hands the judgement calls to OpenAI. 31 steps, 1 branch: large, and worth reading before you trust it with anything live.

LargeCalls a model: OpenAI

Download free
31 stepsLarge: read it before trusting it with anything live
1Branch: places the flow splits
0Loops or waits
4Services it connects to

The flow

Starts it 2Model 6Logic 11Service 12

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

  1. 1Schedule Trigger - Daily 9AMSchedule triggerStarts it
  2. 2Schedule Trigger - Weekly Monday 8AMSchedule triggerStarts it
  3. 3OpenAI Chat Model (Weekly)Lm Chat Open AiModel
  4. 4Structured Output Parser (Weekly)Output Parser StructuredModel
  5. 5OpenAI Chat Model (Daily)Lm Chat Open AiModel
  6. 6Structured Output Parser (Daily)Output Parser StructuredModel
  7. 7Set ConfigurationSetLogic
  8. 8Set - Weekly Report ConfigSetLogic
  9. 9AI Agent - Weekly Trend AnalysisAgentModel
  10. 10AI Agent - Analyze and Generate EmailAgentModel
  11. 11Google Sheets - Get Target CompaniesGoogle SheetsService
  12. 12Google Sheets - Get Raw Jobs (Weekly)Google SheetsService
  13. 13Google Sheets - Get Qualified Leads (Weekly)Google SheetsService
  14. 14Google Sheets - Save Weekly ReportGoogle SheetsService
  15. 15Google Sheets - Save Qualified LeadsGoogle SheetsService
  16. 16Apify - Scrape Google JobsApifyService
  17. 17Apify - Scrape LinkedIn JobsApifyService
  18. 18Apify - Scrape Indeed JobsApifyService
  19. 19Merge - Weekly DataMergeLogic
  20. 20Slack - Send Weekly ReportSlackService
  21. 21Gmail - Send Weekly ReportGmailService
  22. 22Slack - Send Lead AlertSlackService
  23. 23Code - Normalize Google JobsCodeLogic
  24. 24Code - Normalize LinkedIn JobsCodeLogic
  25. 25Code - Normalize Indeed JobsCodeLogic
  26. 26Code - Aggregate Weekly StatisticsCodeLogic
  27. 27Merge - Combine All SourcesMergeLogic
  28. 28Code - Deduplicate and Filter by DateCodeLogic
  29. 29Google Sheets - Save Raw JobsGoogle SheetsService
  30. 30Code - Filter by Target KeywordsCodeLogic
  31. 31IF - Check Matches FoundIfLogic

How it's built

Starts on
A clock
Steps
31, with 1 branch
Size
Large: read it before trusting it with anything live
Connects to
Apify, Gmail, Google Sheets, Slack
Model
OpenAI

Questions

What does it need to run?

An n8n account, plus your own Apify, Gmail, Google Sheets and Slack accounts, 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 31 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 31 steps before you point it at anything that matters.