This comprehensive n8n workflow automates the entire lead generation, enrichment, and data update process for engaging prospects on LinkedIn and Google Sheets. Starting from a form submission, it generates leads via Apollo.io based on specified job titles and locations, then populates a Google Sheet with pending lead data. It proceeds through multiple enrichment stages: fetching LinkedIn profile summaries, recent posts, validating emails, and extracting LinkedIn usernames using APIs like RapidAPI, OpenAI, and Google Sheets. The workflow is designed to reattempt failed scrapes automatically, ensuring data accuracy and completeness. Key nodes include webhooks, API requests, data cleaning, language models for summarization, and scheduled triggers for periodic data refreshes, making it ideal for sales teams aiming to build a high-quality, enriched leads database with minimal manual input.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.openAi, code, formTrigger, googleSheets, googleSheetsTrigger, httpRequest, if, limit, scheduleTrigger, set, splitOut, stickyNote