cotera
Back to Prompts

Recruiting Pipeline Builder

Target a company, define your role, get a scored candidate list in Google Sheets.

Executive recruitingTalent sourcingCompetitive hiringPipeline building

The Challenge

You know the companies you want to recruit from, but sourcing is a slog. Searching, enriching, evaluating, organizing — it takes hours per search. This prompt does the research, scores candidates against your requirements, and gives you a ready-to-use spreadsheet.

What This Prompt Does

Search Target Company

Find candidates by title and seniority

Enrich Profiles

Get full context from LinkedIn

Score Candidates

Rate fit against your job requirements

Export to Sheets

Get a ready-to-use candidate pipeline

The Prompt

The Prompt

Task

Given a target company to recruit from and a job description/role requirements, use @Apollo/Search PeopleName it "Apollo/Search People" and call it with @Apollo/Search People to find candidates, @LinkedIn/Get ProfileName it "LinkedIn/Get Profile" and call it with @LinkedIn/Get Profile to enrich their profiles, score them against your requirements, and export the results to Google Sheets using @Google Sheets/Append RowName it "Google Sheets/Append Row" and call it with @Google Sheets/Append Row.

Example: Find senior engineers at Stripe who might be a good fit for our Staff Engineer role and put them in a spreadsheet.

Input

The user will provide:

  1. Target company to recruit from
  2. Role/job description or key requirements
  3. Google Sheets spreadsheet ID for output

Example: "Find product managers at Notion who could be good VPs. Sheet ID: abc123"

Context

What to Search For

Apollo filters:

  • Company name (current employer)
  • Job title keywords
  • Seniority level
  • Location (if relevant)
  • Years of experience

LinkedIn enrichment:

  • Current role tenure
  • Previous experience
  • Education background
  • Skills and endorsements
  • Recent activity and posts

Scoring Criteria

Experience fit (0-10):

  • Relevant industry experience
  • Role progression
  • Company caliber
  • Years at level

Skills match (0-10):

  • Technical skills alignment
  • Domain expertise
  • Leadership experience (if needed)

Cultural signals (0-10):

  • LinkedIn activity (thought leadership)
  • Career trajectory
  • Education
  • Side projects or open source

Output Format

Create a scored candidate list with all relevant data for recruiter outreach.

Output

Search Summary:

  • Target company: [Company]
  • Role: [Job title]
  • Candidates found: [count]
  • Top matches: [count with score > 7]

Google Sheets Output:

Each row will contain:

| Name | Current Title | Company | LinkedIn | Email | Experience Score | Skills Score | Culture Score | Total Score | Notes | |------|--------------|---------|----------|-------|-----------------|--------------|---------------|-------------|-------| | [Name] | [Title] | [Company] | [URL] | [email] | [0-10] | [0-10] | [0-10] | [0-30] | [Key highlights] |

Top Candidates:

1. [Name] — Score: [X/30]

Current: [Title] at [Company] ([tenure]) LinkedIn: [URL] Email: [if available]

Why they match:

  • [Reason 1]
  • [Reason 2]
  • [Reason 3]

Potential concerns:

  • [Any flags]

Outreach angle: [Suggested approach based on profile]

2. [Name] — Score: [X/30]

(Same format)

Outreach Template:

Based on the candidate profiles, here's a personalized outreach template:

Subject: [Suggested subject line]

Hi [Name],

[Personalized opening based on their background]

[Value prop for your opportunity]

[Soft CTA]

Best, [Your name]

Example Usage

Try asking:

  • →"Find senior engineers at Stripe for our Staff Engineer role"
  • →"Build a candidate list of PMs at Notion who could be VP-level"
  • →"Source designers from Figma for our Senior Product Designer role"