{"product_id":"apollo-people-search-lead-scoring-google-sheets-enrichment","title":"Apollo People Search Lead Scoring + Google Sheets Enrichment","description":"\u003ch3\u003eTurn Apollo People Search into ready-to-prospect leads—scored, deduplicated, and appended to Google Sheets\u003c\/h3\u003e\n\u003cp\u003eThe \u003cstrong\u003eApollo People Search Lead Scoring + Google Sheets Enrichment\u003c\/strong\u003e n8n workflow runs on demand to find B2B prospects with the \u003cstrong\u003eApollo Official API\u003c\/strong\u003e, automatically \u003cstrong\u003escores and shortlists\u003c\/strong\u003e people, optionally \u003cstrong\u003eenriches top candidates\u003c\/strong\u003e, and then \u003cstrong\u003eappends deduplicated leads\u003c\/strong\u003e into your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for outreach and pipeline building.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManually starts\u003c\/strong\u003e via a manual trigger to run Apollo People Search using your configured \u003cem\u003etitles\u003c\/em\u003e, \u003cem\u003elocations\u003c\/em\u003e, and \u003cem\u003epaging\u003c\/em\u003e settings.\u003c\/li\u003e\n  \u003cli\u003eSends a \u003cstrong\u003ePOST\u003c\/strong\u003e request to the \u003cstrong\u003eApollo Official API People Search endpoint\u003c\/strong\u003e and retrieves matching people.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScores each prospect\u003c\/strong\u003e using signals such as \u003cem\u003etitle fit\u003c\/em\u003e, \u003cem\u003eseniority signals\u003c\/em\u003e, \u003cem\u003eemail availability\u003c\/em\u003e, and \u003cem\u003ecompany data\u003c\/em\u003e. It filters out \u003cstrong\u003eblocked companies\u003c\/strong\u003e and \u003cstrong\u003elow-scoring leads\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCreates a \u003cstrong\u003epreview-only\u003c\/strong\u003e list of qualified, scored results so you can review outcomes \u003cstrong\u003ewithout using enrichment credits\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eIf enrichment is enabled, it selects only the \u003cstrong\u003etop candidates\u003c\/strong\u003e (up to \u003cem\u003emax_enrichments\u003c\/em\u003e) and calls the \u003cstrong\u003eApollo Official API People Enrichment endpoint\u003c\/strong\u003e—while \u003cstrong\u003enot revealing personal email addresses or phone numbers\u003c\/strong\u003e in the enrichment step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes\u003c\/strong\u003e enrichment responses into a consistent lead schema, \u003cstrong\u003eremoves duplicates\u003c\/strong\u003e across previous workflow executions, and \u003cstrong\u003eappends new leads to Google Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGenerate weekly lead batches from Apollo based on job titles and geographic targeting, then land results directly in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003eRun an internal “who should we contact?” shortlist using automated title\/seniority scoring before enrichment.\u003c\/li\u003e\n  \u003cli\u003eBuild and maintain a deduplicated prospect database for SaaS sales outreach and SDR workflows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Manual Trigger\u003c\/strong\u003e, \u003cstrong\u003eSet\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eSticky Note\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHTTP Request\u003c\/strong\u003e to Apollo Official API (People Search + People Enrichment endpoints)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e append step (configure spreadsheet ID + sheet name; ensure sheet columns match appended fields)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSEO keywords:\u003c\/strong\u003e Apollo People Search, lead scoring, Apollo enrichment, Google Sheets lead management, n8n workflow marketplace.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45950155817139,"sku":"N8N-19146","price":55.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/zjrcnGzULcbVBpdgP_gcc_Opah8j0F.png?v=1788513670","url":"https:\/\/buyflowscripts.com\/products\/apollo-people-search-lead-scoring-google-sheets-enrichment","provider":"N8N Commerce","version":"1.0","type":"link"}