This n8n workflow automates the process of gathering LinkedIn profiles for a list of companies stored in Google Sheets. Starting with a manual trigger, it reads company names from Google Sheets, constructs Google search URLs to find LinkedIn profiles, and uses the Bright Data API to perform web scraping of search results. The workflow then polls Bright Data’s dataset progress, retrieves the search data, and parses it using AI-powered language models (like Google Gemini). The parsed data is checked for valid LinkedIn URLs, which are then stored back into Google Sheets, ensuring each company has an associated LinkedIn profile URL or a placeholder if not found. Practical use cases include market research, lead generation, or updating CRM records with social media profiles.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.chainLlm, @n8n/n8n-nodes-langchain.lmChatGoogleGemini, @n8n/n8n-nodes-langchain.outputParserStructured, code, googleSheets, httpRequest, if, manualTrigger, merge, set, splitInBatches, stickyNote, wait