Scans fresh job postings for buying signals, then delivers ranked, enriched B2B leads in a Google Sheet with a pain narrative ready for cold outreach
This template finds companies that are actively hiring for roles that reveal a buying pain, then turns those signals into a clean list of ranked, contact-ready leads. It is built for sales teams and founders who want a steady stream of high-intent prospects without manually reading job boards every week.
The Signal Lead Hunter agent pulls fresh job postings from Indeed and ZipRecruiter, enriches the companies and contacts through Apollo, removes duplicates, and writes everything to a Google Sheet. Each surviving lead is scored 1 to 10 on how strong its hiring signal is, along with a short pain narrative a rep can paste straight into a cold email. Alongside the sheet, the agent produces a digest of the new high-intent prospects from that run.
The agent runs on a weekly schedule, every Monday at 7am, so the sheet fills with fresh leads at the start of each week. Reps open the sheet, sort by score, and start reaching out with context already written for them.
Apollo
Google Sheets
Indeed
ZipRecruiter
Turns fresh job postings that signal a buying pain into ranked, enriched, deduped B2B leads in a Google Sheet plus a digest of new high-intent prospects.
score-hiring-signal
Load in run step 6 to score each surviving lead 1-10 on hiring-signal strength and to write the pain narrative a rep pastes into cold outreach. Carries the scoring rubric and the role-to-pain library.
weekly hiring signal hunt
At 07:00 AM, only on Monday
You connect four services: Apollo, Google Sheets, Indeed, and ZipRecruiter. Apollo handles company and contact enrichment, Indeed and ZipRecruiter supply the job postings, and Google Sheets receives the ranked leads. Setup takes about 5 minutes.
It runs on a weekly schedule, every Monday at 7am. The Google Sheet fills with fresh leads at the start of each week, so reps can open it, sort by score, and start reaching out.
Each surviving lead lands as an enriched company and contact, ranked from strongest hiring signal to weakest, with a score of 1 to 10 and a short pain narrative for outreach. Alongside the sheet, the agent produces a digest of the newest high-intent prospects from that run.
The score-hiring-signal skill scores every remaining lead 1 to 10 on how strong its hiring signal is, using a scoring rubric and a role-to-pain library. The same skill drafts the pain narrative a rep pastes into a cold email.
No. After enriching each company and contact through Apollo, the agent dedupes against what is already in your Google Sheet before writing new rows, so leads you already have are not repeated.
No. The agent writes the pain narrative and ranks the leads, but it does not send outreach. A rep opens the sheet, sorts by score, and sends the emails with the context already written for them.
© 2026 Rerun. All rights reserved.
