Scout Hiring Leads Daily

What This Workflow Does

This workflow automates your daily lead generation by scouting recent job postings that signal companies are actively expanding. It extracts key details like company names and job titles, enriches that data by researching CEOs and company summaries, updates your CRM spreadsheet, and drafts personalized outreach emails—all before you start your workday.

At a high level, it performs five steps:

1. Triggers every morning at 8:00 AM (Asia/Calcutta timezone) to kick off the process automatically.
2. Scrapes a job board URL (like Hacker News Jobs) to pull the latest raw job posting data.
3. Extracts the top 5 companies hiring from the scraped content, identifying company names and job titles.
4. Enriches each lead by searching the web for the CEO/Founder name and a concise company summary.
5. Logs everything to Google Sheets and drafts personalized outreach emails in Gmail for each lead.

What You Need

• A Needle account to create and run the workflow.
• A job board URL with recent postings (e.g., https://news.ycombinator.com/jobs).
• A Google Sheets spreadsheet you control — you'll need its spreadsheet ID.
• A Gmail account connected to Needle with permissions to create draft emails.
• Needle connectors for Web Search, Google Sheets, and Gmail enabled and authorized.

How the Flow Works

AI Agent Phases

The AI agent node handles the heavy lifting in a structured sequence:

1. Extraction — Parses the scraped job board text to identify the 5 most recent companies and their posted job titles.
2. Enrichment — Uses web search to find the CEO or Founder name and a one-sentence summary of each company.
3. Database Update — Adds a row to your Google Sheet for each lead with columns: Company Name, Job Title, CEO/Founder Name, Company Summary, and Date.
4. Outreach Drafting — Creates a Gmail draft for each CEO/Founder with a personalized subject line and body referencing their new hire.

Output

At the end of each run, you get:

• A Google Sheet updated with fresh lead data: company names, job titles, CEO/Founder names, company summaries, and the date.
• Draft emails in Gmail ready to review and send, tailored to each CEO/Founder congratulating them on their expansion.

Setup Notes

• For testing: Set the trigger node to manual mode so you can run the workflow on demand.
• Spreadsheet ID: Replace SPREADSHEET_ID_PLACEHOLDER in the AI node's prompt with your actual Google Sheet ID.
• Connectors: Make sure Google Sheets and Gmail connectors are properly authorized in Needle before running.
• Draft emails are not sent automatically — they're saved as drafts so you have full control over when and how you reach out.
• Custom job boards: You can change the URL in the web scraper node to target other job boards like Indeed, Glassdoor, or any startup job site.