Automate company data enrichment with HubSpot, Sona, OpenAI & Google Sheets

Automatically identify ICP matches by enriching basic company records with Sona Enrich data—combining web scraping, AI analysis, and the structured attributes that define your ideal customer.

Import company domains from a Google Sheet, automatically analyze their websites with AI, enrich them with firmographic data via Sona Enrich, and sync the results to HubSpot—so you can quickly discover and target your ideal customers.

How it works

Step 1: Data Input & Web Scraping

- Reads company domains from your Google Sheet - Scrapes each website's content via HTTP requests - Extracts and cleans HTML content - Removes navigation, footers, and noise

Step 2: AI Analysis

- Sends cleaned content to OpenAI Chat Model - Extracts structured company intelligence (industry, positioning, features, personas) - Captures and analyzes pricing, pros/cons, and value propositions - Aggregates all AI results into standardized format - Advanced users: You can modify the data that's generated and then add custom fields to HubSpot

Step 3: HubSpot Preparation