# Google Sheets Lead List Builder

> Search Apollo for prospects, enrich with LinkedIn data, and export a clean lead list straight to Google Sheets.

Source: https://cotera.co/solutions/ops/google-sheets-lead-list-builder

---

- **Team:** Operations
- **Tools:** Google Sheets, Apollo, LinkedIn
- **Difficulty:** easy
- **Setup time:** 5 min
- **Time saved:** 2-3 hrs/list

## How it works
1. **Search Prospects** — Find contacts matching your ICP in Apollo
2. **Enrich Contacts** — Pull emails, phones, and LinkedIn URLs for each lead
3. **Company Context** — Get headcount and growth signals from LinkedIn
4. **Export to Sheets** — Append each lead as a formatted row with deduplication

## Example requests
- Find 20 VP Marketing at B2B SaaS companies with 50-500 employees and add them to my sheet
- Build a lead list of CTOs at healthcare startups in New York
- Search for Directors of Sales at Series B fintech companies and export to Google Sheets

## Prompt

```markdown
## Task

Build a targeted lead list by searching Apollo for prospects matching specific criteria, enriching each lead with company context from LinkedIn, and exporting the full list to a Google Sheets spreadsheet. Use @Apollo/Search People to find matching contacts, @Apollo/Enrich Person to get their details, @LinkedIn/Get Company Insights for company-level data, @Google Sheets/Read Range to check for existing entries, and @Google Sheets/Append Row to add each new lead.

**Example:** Find 20 VP-level marketing leaders at B2B SaaS companies with 50-500 employees and export them to my spreadsheet.

## Input

The user will provide:
1. Target persona (title, seniority, department)
2. Company filters (industry, size, location, keywords)
3. Number of leads desired
4. Google Sheets spreadsheet ID for export

**Example:** "Find 25 Directors of Engineering at fintech companies in the US with 100-1000 employees. Export to spreadsheet ID 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms"

## Context

### Search Strategy

1. Use Apollo/Search People with the user's filters to get an initial list
2. For each result, call Apollo/Enrich Person to get full contact details (email, phone, LinkedIn URL)
3. For each unique company, call LinkedIn/Get Company Insights to get employee count, growth trends, and industry
4. Read the existing spreadsheet with Google Sheets/Read Range to avoid adding duplicates
5. Append each new lead as a row using Google Sheets/Append Row

### Column Structure

The spreadsheet should have these columns:
- Full Name
- Title
- Company
- Email
- Phone
- LinkedIn URL
- Company Size
- Industry
- Location
- Employee Growth Signal

### Quality Checks

- Skip leads without a valid email address
- Skip leads who have already been added (check by email)
- Prioritize leads at companies showing growth (headcount increasing)
- Flag any leads where the enrichment data is incomplete

## Output

**Summary:** "[X] leads added to your spreadsheet out of [Y] found."

**Lead Quality Report:**
| Metric | Count |
|--------|-------|
| Total found | X |
| With valid email | X |
| Duplicates skipped | X |
| Added to sheet | X |

**Top Companies Represented:**
| Company | Employees | Growth | Leads Added |
|---------|-----------|--------|-------------|
| [Company 1] | X | Growing/Stable | X |

**Next Steps:**
- Review the spreadsheet and remove any irrelevant leads
- Use the list for outbound campaigns or CRM import
- Re-run with adjusted filters to expand the list
```

## Related reading
- [Airtable Vs Google Sheets Automation](https://cotera.co/articles/airtable-vs-google-sheets-automation.md)
- [AI Lead Enrichment Automation](https://cotera.co/articles/ai-lead-enrichment-automation.md)
- [Automate Google Ads Reporting Ai](https://cotera.co/articles/automate-google-ads-reporting-ai.md)