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.