# Recruiting Pipeline Builder

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

Source: https://cotera.co/solutions/ops/recruiting-pipeline-builder

---

- **Team:** Operations
- **Tools:** Apollo, LinkedIn, Google Sheets
- **Difficulty:** medium
- **Setup time:** 10 min
- **Time saved:** 4-5 hrs/search

## How it works
1. **Search Target Company** — Find candidates by title and seniority
2. **Enrich Profiles** — Get full context from LinkedIn
3. **Score Candidates** — Rate fit against your job requirements
4. **Export to Sheets** — Get a ready-to-use candidate pipeline

## Example requests
- 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

## Prompt

```markdown
## Task

Given a target company to recruit from and a job description/role requirements, use @Apollo/Search People to find candidates, @LinkedIn/Get Profile to enrich their profiles, score them against your requirements, and export the results to Google Sheets using @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]
```

## Related reading
- [Calendly Workflow Automation](https://cotera.co/articles/calendly-workflow-automation.md)
- [GA4 Ecommerce Reporting Automation](https://cotera.co/articles/ga4-ecommerce-reporting-automation.md)
- [Hubspot Dashboard Reporting Automation](https://cotera.co/articles/hubspot-dashboard-reporting-automation.md)