Apollo People Search Lead Scoring + Google Sheets Enrichment

Turn Apollo People Search into ready-to-prospect leads—scored, deduplicated, and appended to Google Sheets

The Apollo People Search Lead Scoring + Google Sheets Enrichment n8n workflow runs on demand to find B2B prospects with the Apollo Official API, automatically scores and shortlists people, optionally enriches top candidates, and then appends deduplicated leads into your Google Sheets for outreach and pipeline building.

What this workflow does

• Manually starts via a manual trigger to run Apollo People Search using your configured titles, locations, and paging settings.
• Sends a POST request to the Apollo Official API People Search endpoint and retrieves matching people.
• Scores each prospect using signals such as title fit, seniority signals, email availability, and company data. It filters out blocked companies and low-scoring leads.
• Creates a preview-only list of qualified, scored results so you can review outcomes without using enrichment credits.
• If enrichment is enabled, it selects only the top candidates (up to max_enrichments) and calls the Apollo Official API People Enrichment endpoint—while not revealing personal email addresses or phone numbers in the enrichment step.
• Normalizes enrichment responses into a consistent lead schema, removes duplicates across previous workflow executions, and appends new leads to Google Sheets.

Use cases

• Generate weekly lead batches from Apollo based on job titles and geographic targeting, then land results directly in Google Sheets.
• Run an internal “who should we contact?” shortlist using automated title/seniority scoring before enrichment.
• Build and maintain a deduplicated prospect database for SaaS sales outreach and SDR workflows.

Technical details

• n8n Manual Trigger, Set, Code, Sticky Note
• HTTP Request to Apollo Official API (People Search + People Enrichment endpoints)
• Google Sheets append step (configure spreadsheet ID + sheet name; ensure sheet columns match appended fields)

SEO keywords: Apollo People Search, lead scoring, Apollo enrichment, Google Sheets lead management, n8n workflow marketplace.