Research and summarize B2B leads from Google Sheets to Airtable with BrowserAct

Automate B2B lead research from Google Sheets to Airtable With BrowserAct

This workflow automates the time-consuming process of B2B market research. It takes a list of company website URLs from a Google Sheet, uses BrowserAct to scrape their profiles and news sections, analyzes the data using AI to determine strategic focus and key activities, and saves a comprehensive executive summary into an Airtable database.

Target Audience

Sales operations managers, SDRs (Sales Development Representatives), market researchers, and venture capital analysts who need to process large volumes of company data efficiently.

How it works

1. Ingest Data: The workflow retrieves a list of target company URLs from a Google Sheet. 2. Scrape Content: It loops through each URL and triggers BrowserAct (using the "B2B Contact Research" template) to scrape company profiles, about pages, and news sections. 3. Analyze & Stage: An AI Agent (using OpenRouter/GPT-5) processes the raw scraped text to identify whether it is news or profile data, extracting key insights like strategic focus and recent updates. This raw analysis is staged back into the Google Sheet. 4. Synthesize: The workflow retrieves the staged data and aggregates it. 5. Final Summary: A second AI Agent compiles all data points into a cohesive "Research Record," writing a high-impact executive summary and formatting notes with Markdown. 6. Database Entry: The final structured data (Name, Notes, Strategic Focus) is created as a new record in Airtable.

How to set up

1. Configure Credentials: Connect your BrowserAct, Google Sheets, Airtable, and OpenRouter accounts in n8n. 2. BrowserAct Template: Ensure you have the B2B Contact Research template saved in your BrowserAct account. 3. Prepare Google Sheet: Create a Google Sheet with a tab named "DataBase". Add the headers listed below. Populate the Page URL column with the companies you want to research. 4. Configure Nodes: Open the Google Sheets nodes and select your file. Open the Airtable node and select your Base and Table.