Extract employee emails from company domains with BrowserAct and Google Sheets

Extract employee emails from company domains using Human-in-the-Loop scraping using BrowserAct

This workflow automates the process of enriching company data by scraping employee emails and positions from company websites. It processes a list of URLs from a Google Sheet, handles anti-bot measures (CAPTCHAs) by alerting you via Telegram to solve them manually before resuming, and saves the verified data back to your sheet.

Target Audience

Sales development representatives (SDRs), lead generation agencies, and recruiters needing verified contact info.

How it works

1. Read List: The workflow reads a list of company URLs from a Google Sheet. 2. Scrape Data: It loops through each URL and triggers BrowserAct to scrape the site for team pages or contact info. 3. Check Status: Finished: If scraping is successful, it parses the data (Name, Email, Position). Paused: If a CAPTCHA is detected, the workflow sends a Telegram alert. It pauses execution until you verify the CAPTCHA in the browser, then resumes automatically. Failed: If scraping fails, it logs an error.

4. Save Data: Extracted emails and names are appended to a new tab in the Google Sheet specific to that company. 5. Notify: Once a company is processed, a Slack notification is sent.

How to set up