Job post to sales lead pipeline with Scrape.do, Apollo.io & OpenAI

by Onur ✓ · 250 views · created 2025-12-16 · Lead Generation, Multimodal AI

What this workflow does

This workflow has 13 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets. It also calls api.scrape.do and api.apollo.io over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. Set Search Parameters (Edit Fields (Set)): sets 4 fields: jobTitle, location, daysPosted…
2. Scrape.do Indeed API (HTTP Request): calls api.scrape.do
3. Parse Indeed Jobs (Code): runs custom JavaScript code
4. Add New Company (Google Sheets): append
5. Apollo Organization Search (HTTP Request): calls api.apollo.io (POST)
6. Extract Apollo Org Data (Code): runs custom JavaScript code
7. Apollo People Search (HTTP Request): calls api.apollo.io (POST)
8. Format Leads (Code): runs custom JavaScript code
9. Generate Personalized Message (OpenAI): work with chat
10. Merge Lead + Message (Code): runs custom JavaScript code

…plus 1 more step. See the full node list below.

Services it uses

Google Sheets

HTTP calls to: api.scrape.do, api.apollo.io

Before you upgrade to n8n 3.0

Nodes used (7)

• n8n Form Triggern8n-nodes-base.formTrigger
• Edit Fields (Set)n8n-nodes-base.set
• HTTP Requestn8n-nodes-base.httpRequest
• Coden8n-nodes-base.code
• Google Sheetsn8n-nodes-base.googleSheets
• OpenAIn8n-nodes-base.openAi
• Manual Triggern8n-nodes-base.manualTrigger

From the author

Lead Sourcing by Job Posts For Outreach With Scrape.do API & Open AI & Google Sheets Overview This n8n workflow automates the complete lead generation process by scraping job postings from Indeed, enriching company data via Apollo.io, identifying…

View the original on n8n.io → Check your own copy