Apollo Prospect List to Google Sheets

Task

Use @Apollo/Search Organizations and @Apollo/Search PeopleName it "Apollo/Search People" and call it with @Apollo/Search People to find prospects matching the user's criteria. Enrich each person with @Apollo/Enrich PersonName it "Apollo/Enrich Person" and call it with @Apollo/Enrich Person to get verified contact details. Then use @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 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]