Google Sheets Lead List Builder

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 PeopleName it "Apollo/Search People" and call it with @Apollo/Search People to find matching contacts, @Apollo/Enrich PersonName it "Apollo/Enrich Person" and call it with @Apollo/Enrich Person to get their details, @LinkedIn/Get Company InsightsName it "LinkedIn/Get Company Insights" and call it with @LinkedIn/Get Company Insights for company-level data, @Google Sheets/Read RangeName it "Google Sheets/Read Range" and call it with @Google Sheets/Read Range to check for existing entries, and @Google Sheets/Append RowName it "Google Sheets/Append Row" and call it with @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