Weekly recruiter sourcing pipeline into Bullhorn

Build me a weekly recruiter sourcing workflow that turns a saved ideal-candidate brief into vetted prospects sitting in Bullhorn, ready to outreach. This should be an agent workflow.

Trigger: cron, every Monday at 7am in the user's local timezone.

Prompt config (the role brief the agent uses on every run): a free-text role title, a seniority level, a list of must-have skills, a list of target locations, a list of current employers to pull from, a list of past employers to pull from, a shortlist size (default 10 to 15), the Slack channel ID to post the digest into, and the Bullhorn owner user ID that should own newly created candidates.

Step 1: longlist (free). Call RocketReach Search People with the title, seniority, skills, location, and current/past employer filters from the prompt config. Use page_size 100 and paginate until you have at least 100 candidates or the result set is exhausted. Search People returns matches without contact info and does not consume lookup credits, so do not call Person Lookup yet.

Step 2: shortlist (free). Read the role brief and the longlist, score each profile against the brief (title fit, seniority fit, skills match, location fit, employer signal), and pick the top N where N is the shortlist size from the prompt config. Keep a one-line rationale per pick ("why this candidate") and a one-line reason for the strongest candidates you rejected. Do not enrich anyone yet.

Step 3: dedupe against Bullhorn (free). For each shortlisted candidate, call Bullhorn Search Entities on the Candidate entity with a Lucene query that matches on email or LinkedIn URL or (firstName AND lastName AND companyName). If a non-deleted Candidate already exists, drop the candidate from the enrichment list and remember them as "already in Bullhorn" for the digest. This step matters: it prevents wasting RocketReach lookup credits on candidates we already have.

Step 4: enrich (costs credits). For each remaining shortlisted candidate, call RocketReach Person Lookup with the RocketReach profile ID from Step 1 to retrieve verified email, phone, and LinkedIn URL. Use lookup_type "standard". Person Lookup is async — if the response status is "searching" or "progress", poll Check Person Lookup Status until status is "complete" (cap at ~30 seconds per candidate, then move on). If a lookup ultimately returns no verified email, skip that candidate and note it for the digest.

Step 5: create prospect in Bullhorn. For each successfully enriched candidate, call Bullhorn Create Entity on the Candidate entity. Populate firstName, lastName, email, mobile (if returned), and the LinkedIn URL on the appropriate social profile field. Set status to a passive/prospect status (e.g. "New Lead" or the equivalent in this Bullhorn instance) and set owner to the Bullhorn owner user ID from the prompt config. Do NOT attach the candidate to a specific JobOrder — there is no job application yet, this is a sourced prospect. After creating the Candidate, create a Bullhorn Note attached to it containing the one-line "why this candidate" rationale from Step 2 and a "sourced via weekly RocketReach pipeline" tag.

Step 6: digest. Call Slack Send a Message to the channel from the prompt config. The digest should include: how many profiles were sourced from RocketReach in total, how many were shortlisted, how many made it through dedupe, how many were successfully enriched and created in Bullhorn, the shortlist itself (name, current title, current company, one-line rationale, link to the new Bullhorn Candidate record), the candidates skipped because they were already in Bullhorn (name + "already in Bullhorn"), the candidates skipped because enrichment failed, and a closing link to the Bullhorn Candidate list view filtered to this week's sourced batch.

Guardrails: never call Person Lookup before dedupe; never create a Candidate in Bullhorn that already exists; always reuse the Bullhorn BhRestToken across operations in the same run instead of re-authenticating per call; respect RocketReach's 5 requests/second cap and honour Retry-After on 429 responses; if the entire RocketReach search returns zero results or the Bullhorn session can't be established, post a short Slack message to the same channel explaining what failed and exit cleanly.

Note on the ATS: the original ask referenced Greenhouse, but Bullhorn is the supported recruiting CRM here and is the right fit for sourced prospects (no job application required, full Candidate + Note model). Build against Bullhorn.