Enrich Company Data from LinkedIn via Bright Data & Google Sheets

This n8n workflow automates the enrichment of company data by discovering and extracting each company's official LinkedIn profile URL. Starting from a list of company names in Google Sheets, it uses Bright Data's Web Unlocker to perform targeted Google searches (e.g., 'site:linkedin.com [company name]'), then leverages Google Gemini AI to parse the HTML results and identify the most relevant LinkedIn profile.

The process loops over each company individually: generating custom search queries, fetching unlocked web pages via Bright Data, and applying AI for intelligent extraction. Successful matches are collected, while failures can trigger custom logic like retries or notifications. Results are batched for additional enrichment from Bright Data datasets before appending structured data back to Google Sheets.

Ideal for sales, business development, and data research teams, it saves hours of manual LinkedIn prospecting, scales to hundreds of companies, and ensures accurate official profiles for CRM enrichment, outreach campaigns, or database validation. Benefits include high automation reliability with AI handling variations in search results, cost-effective scaling via Bright Data, and seamless Google Sheets integration for non-technical users.

Setup requires API keys for Bright Data and Google Gemini, plus Google Sheets access. Manual trigger allows controlled batch runs, making it perfect for testing and production.