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

by Sona Labs ✓ · 105 views · created 2025-12-19 · Lead Generation, AI Summarization

What this workflow does

This AI workflow has 18 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, Google Sheets and HubSpot. It also calls api.hubapi.com and api2.sonalabs.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Get Company List from Sheet (Google Sheets): uses Google Sheets
2. Scrape Website Content (HTTP Request): calls an HTTP API
3. Extract HTML Content (HTML): parses or builds HTML
4. Clean & Format Text (Code): runs custom JavaScript code
5. Analyze with AI (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
6. Collect AI Results (Aggregate): combines items into one
7. Create Custom HubSpot Fields (HTTP Request): calls api.hubapi.com (POST)
8. Prepare Data for Loop (Edit Fields (Set)): sets 1 field: output
9. Split Companies and AI Output into Items (Split Out): splits a list into separate items
10. Loop Through Companies (Loop Over Items (Split in Batches)): loops over the items in batches

…plus 4 more steps. See the full node list below.

Services it uses

OpenAI Chat ModelGoogle SheetsHubSpot

HTTP calls to: api.hubapi.com, api2.sonalabs.com

Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).

Before you upgrade to n8n 3.0

Nodes used (14)

• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• HTTP Requestn8n-nodes-base.httpRequest
• No Operation, do nothingn8n-nodes-base.noOp
• Manual Triggern8n-nodes-base.manualTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• HTMLn8n-nodes-base.html
• Coden8n-nodes-base.code
• AI Agent@n8n/n8n-nodes-langchain.agent
• Aggregaten8n-nodes-base.aggregate
• Edit Fields (Set)n8n-nodes-base.set
• Split Outn8n-nodes-base.splitOut
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HubSpotn8n-nodes-base.hubspot

From the author

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…

View the original on n8n.io → Check your own copy