🔓 Unlock all 10,000+ workflows & prompts free Join Newsletter →
✅ Full access unlocked — explore all 10,000 AI workflow and prompt templates Browse Templates →
Home › n8n › Workflow
January 22, 2026

HubSpot + Google Sheets: enrich buying groups fast

HubSpot + Google Sheets: enrich buying groups fast - n8n workflow automation template
Lisa Granqvist Partner Workflow Automation Expert
HubSpot + Google Sheets: enrich buying groups fast - n8n workflow automation template
Get a free AI assessment → Get a free AI assessment → ⬇️ Use template

New deal comes in. Everyone’s excited. Then, two weeks later, you realize you’ve been selling to one champion while the real decision-makers never even got a first email. That’s how buying groups quietly kill pipeline.

This is the kind of mess RevOps gets blamed for, but Sales managers and founders feel it too. With HubSpot buying groups automation, you stop guessing who matters and start building complete stakeholder maps the moment a deal appears.

This workflow pulls your buying-group rules from Google Sheets, finds matching people at the company, enriches their details, writes them into HubSpot, and emails your team a clean summary with links. You’ll see what it does, what you need, and how it fits into a real sales motion.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: HubSpot + Google Sheets: enrich buying groups fast

The Problem: Deals Open Without the Full Buying Group

In HubSpot, a deal can look “real” with just one contact attached. That’s the trap. Reps move fast, log the first call, and push the deal forward, but nobody has time to hunt down the VP, the budget owner, the security reviewer, and the day-to-day users across departments. So the deal stalls at procurement, or disappears when an unseen stakeholder vetoes it. Worse, the CRM stays incomplete, which means forecasting and handoffs become a guessing game. Honestly, it’s exhausting doing “detective work” for every opportunity.

The friction compounds. Here’s where it breaks down most often:

  • Reps rely on memory and LinkedIn tabs, so buying group discovery happens inconsistently across the team.
  • Criteria like department, seniority, and country live in someone’s head instead of a shared, editable system.
  • Contact enrichment gets skipped because it’s a separate task, which means follow-ups go out with missing phone numbers or no verified email.
  • By the time you realize key stakeholders are missing, the deal has already lost momentum.

The Solution: Auto-Discover and Enrich Stakeholders on Deal Creation

This workflow starts the moment a new HubSpot deal is created. It looks up the company (or companies) associated with that deal, extracts the company domain, and combines it with buying group rules you maintain in Google Sheets. Those rules can include departments, seniorities, ISO country codes, and job title keywords. With the domain plus your criteria, the workflow searches for matching people through Surfe’s People Search API, submits a bulk enrichment job, then checks progress until results are ready. Once the data is back, it filters out unusable records (so you don’t pollute HubSpot with empty contacts), upserts the good contacts into HubSpot, and emails your team a tidy summary table with direct HubSpot links.

The workflow begins with the HubSpot deal trigger and pulls the company context. Then it reads and cleans your criteria in Google Sheets, searches and enriches contacts through Surfe, and finally updates HubSpot plus sends a Gmail notification your team can act on immediately.

What You Get: Automation vs. Results

Example: What This Looks Like

Say your team opens 10 new HubSpot deals a week. Manually, a rep might spend about 30 minutes per deal searching LinkedIn, finding likely stakeholders, and copying details into HubSpot, which is roughly 5 hours weekly (and that’s on a “good” week). With this workflow, the rep does nothing beyond creating the deal; enrichment runs in the background, typically taking a few minutes plus waiting for the bulk job to complete. The result is an inbox-ready table of stakeholders with direct HubSpot links, and you just got most of that 5 hours back.

What You’ll Need

  • n8n instance (try n8n Cloud free)
  • Self-hosting option if you prefer (Hostinger works well)
  • HubSpot to trigger deals and upsert contacts.
  • Google Sheets to store buying group criteria rules.
  • Surfe API key (get it from your Surfe dashboard).
  • Gmail to send the stakeholder summary email.

Skill level: Intermediate. You’ll connect credentials, paste a Google Sheet URL, and confirm HubSpot permissions.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

A new HubSpot deal is created. The HubSpot deal trigger kicks off the automation, then pulls the deal record so the workflow has the right company context.

Company details and your rules get combined. The workflow fetches associated companies, extracts the company domain, and reads your “Your Buying Group Criterias” tab in Google Sheets. Departments, seniorities, countries, and job title keywords are cleaned up so the search payload is consistent.

Surfe finds people, then enriches them. n8n submits a people search request, builds a bulk enrichment payload, and waits/polls until the enrichment job is done. If Surfe isn’t ready yet, the workflow pauses briefly and checks again.

HubSpot gets updated and your team gets notified. Only contacts with at least one usable email or phone number are upserted into HubSpot. Then Gmail sends a summary with a one-glance table and direct links, so reps can take action without digging.

You can easily modify the Google Sheets criteria to target different roles or regions based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the HubSpot Deal Trigger

Set the workflow to start when a new HubSpot deal is created and branch into company lookup and deal retrieval.

  1. Add and open HubSpot Deal Trigger.
  2. Set the event to deal.creation (already configured in eventsUi).
  3. Credential Required: Connect your hubspotDeveloperApi credentials.
  4. Confirm parallel flow: HubSpot Deal Trigger outputs to both Fetch Deal Companies and Retrieve Deal Record in parallel.

⚠️ Common Pitfall: If the HubSpot app is not subscribed to “Deal creation” events, the trigger won’t fire.

Step 2: Connect Google Sheets for Buying Group Criteria

Pull buying group criteria from a Google Sheet to guide the people search.

  1. Open Read Criteria Sheet.
  2. Set Document to https://docs.google.com/spreadsheets/d/[YOUR_ID].
  3. Set Sheet Name to gid=0 and confirm the cached name Your Buying Group Criterias.
  4. Credential Required: Connect your googleSheetsOAuth2Api credentials.

⚠️ Common Pitfall: If the sheet has empty columns for departments, job titles, seniorities, or countries, your search payload may be too broad.

Step 3: Set Up Company and Deal Data Retrieval

Retrieve the associated company and deal details, then merge company domains with criteria.

  1. Open Fetch Deal Companies and verify the URL is =https://api.hubapi.com/crm/v3/objects/deals/{{ $json.dealId }}/associations/companies.
  2. Credential Required: Connect your hubspotOAuth2Api credentials in Fetch Deal Companies.
  3. Open Retrieve Company Record and ensure Company ID is ={{ $json.results[0].id }}.
  4. Credential Required: Connect your hubspotAppToken credentials in Retrieve Company Record.
  5. Open Retrieve Deal Record and confirm Deal ID is ={{ $json.dealId }}.
  6. Credential Required: Connect your hubspotAppToken credentials in Retrieve Deal Record.
  7. Keep the parallel branch from Retrieve Company Record to both Read Criteria Sheet and Extract Company Domains (runs simultaneously).

Step 4: Build the Enrichment Search and Payload

Merge criteria and domains, then generate and submit the Surfe search and enrichment payloads.

  1. Ensure Read Criteria Sheet and Extract Company Domains feed into Combine Criteria Streams.
  2. Open Compose People Search Payload and keep the code that deduplicates departments, jobTitles, seniorities, countries, and domains.
  3. Open Find People at Firms and set URL to https://api.surfe.com/v2/people/search with Method POST.
  4. Set JSON Body to ={{ $json }} in Find People at Firms.
  5. Credential Required: Connect your httpBearerAuth credentials in Find People at Firms.
  6. Open Build Enrichment Payload and keep the include options for email, mobile, and jobHistory.
  7. Open Submit Bulk Enrichment and set URL to https://api.surfe.com/v2/people/enrich with JSON Body ={{ $json }}.
  8. Credential Required: Connect your httpBearerAuth credentials in Submit Bulk Enrichment.

Tip: If Surfe returns no results, check that Compose People Search Payload receives both the criteria and companyDomains arrays.

Step 5: Configure Enrichment Status Loop and Contact Filtering

Poll Surfe for enrichment completion, parse the list, and filter for contacts with email or phone.

  1. Open Check Enrichment Progress and set URL to =https://api.surfe.com/v2/people/enrich/{{ $json.enrichmentID }}.
  2. Credential Required: Connect your httpBearerAuth credentials in Check Enrichment Progress.
  3. In Enrichment Done?, keep the condition Left Value ={{ $json.status }} equals COMPLETED.
  4. Ensure the false branch goes to Pause 3 Seconds, and the success branch goes to Parse Enriched People List.
  5. Open Pause 3 Seconds and set Amount to 3.
  6. Verify Filter Phone or Email checks ={{ $json.phone }} OR ={{ $json.email }} with notEmpty operators.

⚠️ Common Pitfall: If Parse Enriched People List outputs empty fields, the filter will block all contacts.

Step 6: Configure HubSpot Upsert and Email Summary

Push enriched contacts into HubSpot, merge with deal details, and send a summary email.

  1. Open HubSpot Upsert Contact and set Email to ={{ $json.email }}.
  2. Map additional fields in HubSpot Upsert Contact (e.g., Job Title to ={{ $json.jobTitle }}, Company Name to ={{ $json.companyName }}).
  3. Credential Required: Connect your hubspotAppToken credentials in HubSpot Upsert Contact.
  4. Ensure HubSpot Upsert Contact and Parse Deal Details merge in Combine Deal and Contacts.
  5. Open Compose Email Summary to confirm the subject is New Enriched Contacts Added to Your HubSpot Deal.
  6. Open Send Gmail Notification and set Send To to [YOUR_EMAIL], Subject to ={{ $json.subject }}, and Message to ={{ $json.message }}.
  7. Credential Required: Connect your gmailOAuth2 credentials in Send Gmail Notification.

Tip: Keep Send Gmail Notification set to execute once to avoid multiple emails per workflow run.

Step 7: Test and Activate Your Workflow

Run a manual test, confirm contacts are enriched and written to HubSpot, then activate the workflow.

  1. Click Execute Workflow and trigger a test deal creation in HubSpot.
  2. Verify the polling loop: Submit Bulk Enrichment → Check Enrichment Progress → Enrichment Done? → Parse Enriched People List.
  3. Check that HubSpot Upsert Contact creates or updates contacts for records that pass Filter Phone or Email.
  4. Confirm you receive the email from Send Gmail Notification with the HTML table summary.
  5. Toggle the workflow to Active to run automatically on new deals.
🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

  • HubSpot credentials can fail because scopes aren’t right for contacts or the trigger app is tied to the wrong account. Check your HubSpot Private App scopes and the n8n credential selection on the HubSpot nodes first.
  • If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
  • Surfe API calls can hit limits or return partial data if your criteria are too broad. Tighten job title keywords in Google Sheets, and confirm your Surfe key is valid in the HTTP Request nodes.

Related Workflows

If your team also needs lead records to stay usable after enrichment, Google Sheets + HubSpot: enriched leads, no cleanup pairs nicely because it focuses on keeping field formatting and CRM hygiene consistent once data starts flowing.

For teams that want a simpler “prospecting list” motion outside the deal trigger, Surfe to HubSpot, clean prospect lists without chaos is a good companion workflow, especially if you enrich lists before the opportunity even exists.

When you’re missing emails and phone numbers on a lot of existing contacts, HubSpot + ExactBuyer: complete contacts, faster follow up can help fill in gaps at scale, even if the record didn’t originate from a fresh deal.

Need your inbound forms to create the same “no missing stakeholders” discipline? Jotform to HubSpot, follow ups never slip is useful when lead capture happens outside HubSpot and you want instant routing and follow-up tasks.

Finally, if you want the buying group summary to trigger action inside your team chat (not just email), HubSpot + Slack: score leads and route the best complements this workflow by pushing the right items to the right people fast.


Quick reference:

Frequently Asked Questions

How long does it take to set up this HubSpot buying groups automation?

About 45 minutes once your HubSpot, Google Sheets, Surfe, and Gmail accounts are ready.

Do I need coding skills to automate HubSpot buying groups?

No. You’ll mostly connect credentials and paste your Google Sheet URL. There are a few code nodes in the template, but you don’t need to edit them to get value.

Is n8n free to use for this HubSpot buying groups workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Surfe API costs based on your search and enrichment usage.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I customize this HubSpot buying groups workflow for different regions or roles?

Yes, and it’s mostly a Google Sheets change. Update countries (ISO Alpha-2 codes), job title keywords, departments, or seniorities in the “Your Buying Group Criterias” tab, and the workflow will pick it up on the next deal. If you want different rules per pipeline or deal stage, you can adjust the HubSpot trigger logic and the criteria parsing code nodes to branch by pipeline, stage, or deal amount.

Why is my HubSpot connection failing in this workflow?

Usually it’s a permissions issue or a credential mismatch. Confirm the HubSpot Private App token has contacts read/write scopes, and that the HubSpot Trigger node is connected to the correct developer/public app credential. Also check that the deal actually has an associated company; without a company domain, the people search will return nothing and it can look like HubSpot is the problem.

How many contacts can this HubSpot buying groups automation handle?

Surfe People Search is limited to 200 people per run in this workflow, and n8n throughput depends on your plan or server.

Is this HubSpot buying groups automation better than using Zapier or Make?

Often, yes, because this flow needs polling, filtering, merging streams, and bulk upserts, and those get clunky (and pricey) in simpler automation tools. n8n handles branching and code-based transformations cleanly, which matters when your criteria sheet evolves and you don’t want to rebuild the whole thing. Another advantage is self-hosting, so you can run higher volume without paying per tiny step. That said, Zapier or Make can be fine if you only need a lightweight alert and a single enrichment call. Talk to an automation expert if you want help picking the right approach.

Once this is running, every new deal starts with a fuller map of who matters. Your CRM stays cleaner, and your reps spend their time on outreach instead of contact scavenger hunts.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Talk to Automation Expert →

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

×

Use template

Get instant access to this n8n workflow Json file

Copy and import json workflow into your n8n workflow

💬
Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.

Get a free quote today!
Get a free quote today!

Tell us what you need and we'll get back to you within one working day.