# Apollo Prospect List to Google Sheets

> Search Apollo for the right prospects, enrich their profiles, and drop a clean list into Google Sheets — ready for your team to review and act on.

Source: https://cotera.co/solutions/sales/apollo-prospect-list-builder

---

- **Team:** Sales
- **Tools:** Apollo
- **Difficulty:** medium
- **Setup time:** 10 min
- **Time saved:** 1-2 hrs/week

## How it works
1. **Search by ICP** — Find companies and people matching your exact criteria
2. **Enrich Contacts** — Get verified emails, phones, and LinkedIn profiles
3. **Deduplicate** — Check the sheet for existing entries before adding
4. **Export to Sheets** — Append clean, structured rows to your Google Sheet

## Example requests
- Find 20 SDR managers at SaaS companies and add to my sheet
- Build a prospect list of CFOs at logistics companies in Texas
- Search for product managers at Series A startups and export to Google Sheets

## Prompt

```markdown
## Task

Use @Apollo/Search Organizations and @Apollo/Search People to find prospects matching the user's criteria. Enrich each person with @Apollo/Enrich Person to get verified contact details. Then use @Google Sheets/Read Range to check for existing entries and @Google Sheets/Append Row to add each new prospect as a row in a Google Sheet.

**Example:** Find 20 Head of Sales contacts at e-commerce companies with 100-500 employees and add them to my prospect tracking sheet.

## Input

The user will provide:
- Target criteria (titles, industries, company size, location, etc.)
- A Google Sheet spreadsheet ID (or URL) to write to
- Optionally, the sheet/tab name and number of prospects desired

**Example:** "Find 15 marketing directors at healthcare companies and add to sheet 1BxiMVs..."

## Context

### Search Strategy

1. Search Apollo for organizations matching the industry, size, and location filters
2. Search Apollo for people at those organizations with matching titles and seniority
3. Enrich each person to get verified emails, phone numbers, and LinkedIn URLs
4. Read the existing Google Sheet to check column headers and avoid duplicate entries
5. Append each new prospect as a row with all enriched fields

### Column Structure

Use this standard column order (create headers if the sheet is empty):
- Name
- Title
- Company
- Email
- Email Status
- Phone
- LinkedIn URL
- City
- State
- Country
- Company Size
- Industry
- Date Added

### Quality Controls

- Only add contacts with verified or likely email status
- Check the sheet for existing emails before appending to prevent duplicates
- If the user requests N prospects, keep searching until you hit that number (or exhaust results)
- Sort by email verification status — verified contacts first

## Output

**Search Results:**
- Organizations matching criteria: [count]
- People found: [count]
- Verified emails: [count]
- Added to sheet: [count]

**Spreadsheet Updated:**
Added [X] new prospects to [Sheet Name]. Here's a preview:

| Name | Title | Company | Email Status |
|------|-------|---------|-------------|
| [Name] | [Title] | [Company] | Verified/Likely |

**Skipped:** [count] contacts skipped (duplicates, missing emails, etc.)

**Sheet Link:** [Link to the updated Google Sheet]
```

## Related reading
- [Apollo Lead Generation: How We Build 200-Lead Lists in 15 Minutes](https://cotera.co/articles/apollo-lead-generation-guide.md)
- [ZoomInfo Alternative: What We Switched To](https://cotera.co/articles/zoominfo-alternative-sales-intelligence.md)