Recruiting Pipeline Builder

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]