cotera

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.

List buildingProspect exportTeam collaborationOutreach planning

The Challenge

Building a prospect list means searching Apollo, filtering results, copying data into a spreadsheet, and cleaning it up so your team can actually use it. You end up with a dozen browser tabs open and a half-formatted sheet that still needs work. The whole process should take minutes, not hours.

What This Prompt Does

Search by ICP

Find companies and people matching your exact criteria

Enrich Contacts

Get verified emails, phones, and LinkedIn profiles

Deduplicate

Check the sheet for existing entries before adding

Export to Sheets

Append clean, structured rows to your Google Sheet

The Prompt

The Prompt

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]

Example Usage

Try asking:

  • →"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"