Scrape LinkedIn CEOs By Sector

Daily LinkedIn CEO Scraper — By Sector

This workflow automatically scrapes LinkedIn profiles of CEOs within a specified sector and country, using the Google Custom Search API. It runs daily and records key details like CEO name, job title, company, LinkedIn URL, and more into a Google Sheet for easy tracking.

What It Does

1. Starts on a daily schedule (7:00 AM IST) to trigger the scraping process.
2. Configures search parameters — sector, country, and maximum pages to scrape.
3. Loops through multiple pages of Google Custom Search results querying LinkedIn profiles matching the criteria.
4. Parses and enriches the search results, extracting CEO details and profile images.
5. Appends each CEO's information as a new row in a pre-configured Google Sheet.

What You Need

• Google Cloud Project with:
  • An API Key for accessing the Google Custom Search API.
  • The Custom Search API enabled.
• Google Custom Search Engine (CSE) configured to search the entire web.
• Google Sheet prepared to receive output data.

The Google Sheet should have these column headers in Row 1:

You also need the following variables configured in the workflow:

How the Flow Works

Output

At the end of each run, you get a Google Sheet populated with up to 100 LinkedIn CEO profiles (based on the pagination limit), including:

• CEO name
• Job title
• Company name
• Industry sector
• Country
• LinkedIn profile URL
• A short snippet from the LinkedIn profile or search result
• Profile thumbnail image URL
• Date the data was scraped

This makes it easy to track CEOs by sector and country daily, helping with lead generation or market research.

One-Time Setup

1. Create a Google API Key — Go to Google Cloud Console → APIs & Services → Credentials → Create API Key. Add it as the GOOGLE_API_KEY variable in the workflow.
2. Enable Custom Search API — Visit the Custom Search API page and enable it for your project.
3. Create a Custom Search Engine — Go to Programmable Search Engine, create a new engine set to search the whole web, copy the CX ID, and set it as the GOOGLE_CX variable.
4. Prepare your Google Sheet — Create a sheet with the column headers listed above. Copy the Sheet ID from the URL and set it as the SPREADSHEET_ID variable.
5. Set Sector & Country — Edit the Scraper Configuration code node to change the SECTOR and COUNTRY constants to target your desired market.

Notes

• The Google Custom Search free tier allows about 100 queries per day. Adjust the MAX_PAGES value accordingly to stay within quota.
• The scraper relies on Google's indexing and LinkedIn's public profile data — some results may be incomplete or missing images.
• Customize the SECTOR and COUNTRY constants in the configuration node to target different markets or industries.
• If the workflow encounters API errors, it logs them and stops further scraping to avoid redundant requests.
• Keep your API keys secure and monitor usage to avoid unexpected costs.