HubSpot to Google Sheets: Complete Setup Guide (2026)

In this guide

Why connect HubSpot to Google Sheets?
What you need before you start
Step-by-step setup with Autometon
Building your HubSpot dashboard
HubSpot field reference
Common use cases
Frequently asked questions

Why Connect HubSpot to Google Sheets?

HubSpot is the source of truth for your CRM data — but sharing that data with finance, leadership, or external stakeholders means either giving them HubSpot seats (expensive) or exporting CSVs manually (time-consuming and always stale).

Google Sheets solves both problems. When you connect HubSpot to Google Sheets via webhooks using Autometon, your sheet updates the moment HubSpot does — no exports, no scheduling, no manual work. Executives get a live pipeline view. RevOps gets accurate numbers without running reports. Sales managers stop asking for Monday morning updates.

The traditional approach: Export from HubSpot → paste into Sheets → format → share. Repeat every week. Autometon replaces this entire workflow with a one-time 5-minute setup.

What You Need Before You Start

You need three things: a HubSpot account (Professional or Enterprise for webhook access), a Google account with Google Sheets, and a Autometon account (free to start, no credit card required).

You do not need coding skills, API knowledge, or a developer. The entire setup is point-and-click. If you can use a spreadsheet, you can run this integration.

HubSpot plan note: Webhooks are available on Professional and Enterprise plans. If you're on Starter or Free, you can still use HubSpot's native Zapier integration, or upgrade to Professional to access the Webhooks API.

Step-by-Step Setup with Autometon

Step 1: Create your Autometon pipeline

Log in to Autometon and click New Pipeline. Select HubSpot as your source app. Autometon generates a unique webhook URL — copy it.

Step 2: Configure HubSpot webhooks

In HubSpot, go to Settings → Integrations → Webhooks → Create Webhook. Paste your Autometon URL as the endpoint. Subscribe to the events you want to track — common choices: deal.creation, deal.propertyChange, contact.creation, form.submission.

Select the properties to include in the payload: dealname, dealstage, amount, hubspot_owner_id, closedate, hs_analytics_source.

Step 3: Send a test event

Create a test deal or contact in HubSpot to trigger the webhook. Autometon receives the payload and automatically detects every field — you don't need to know the field names in advance.

Step 4: Map HubSpot fields to your sheet columns

Autometon's AI field mapper displays every field from your live HubSpot webhook. It suggests the best match for each field automatically. Review, adjust any mappings, and confirm. This takes about 2 minutes.

Step 5: Connect your Google Sheet and activate

Paste your Google Sheet URL or select from your Drive. Share the sheet with Autometon's service account email (shown in your dashboard). Click Activate Pipeline. From this point, every matching HubSpot event writes a new row to your sheet in under 5 seconds.

Building Your HubSpot Dashboard in Google Sheets

Once data is flowing into your Raw Data tab, add a Dashboard tab and use these formulas:

Pipeline value by stage

Use SUMIF to total deal values per stage:

=SUMIF('Raw Data'!C:C,"Appointment Scheduled",'Raw Data'!D:D)

Repeat for each stage. Turn it into a bar chart for a live pipeline funnel.

Win rate

=COUNTIF('Raw Data'!B:B,"deal.won")/(COUNTIF('Raw Data'!B:B,"deal.won")+COUNTIF('Raw Data'!B:B,"deal.lost"))

Revenue by rep

Insert a pivot table: source = Raw Data, rows = Owner, values = Deal Value (Sum), filter = deal.won. Updates live as new deals close.

Lead source attribution

Map hs_analytics_source to a Source column. Use COUNTIF per source to see which channels drive the most leads — directly in Sheets, updated every time a contact is created.

HubSpot Field Reference

Autometon auto-detects these fields when you send a test event. This table is for reference when planning your sheet column structure.

HubSpot Field	Webhook Property	Recommended Column
Deal Name	`properties.dealname`	Deal Name
Pipeline Stage	`properties.dealstage`	Stage
Deal Amount	`properties.amount`	Deal Value
Owner	`properties.hubspot_owner_id`	Owner
Close Date	`properties.closedate`	Close Date
Lead Source	`properties.hs_analytics_source`	Source
Contact Email	`properties.email`	Email
Company	`properties.company`	Company

Common Use Cases

Real-time pipeline dashboard

Route every deal stage change to Sheets. Build a SUMIF-powered funnel chart your leadership team can view without HubSpot access. Share a view-only link — no seat required.

Lead tracking master sheet

Every new HubSpot contact lands in one master sheet, regardless of source — web forms, ads, manual entry. Use COUNTIF to track lead volume by source and date.

Form submission log

Capture every HubSpot form submission with all field data. Perfect for demo requests, event registrations, or gated content — cross-team visibility without sharing HubSpot access.

Commission calculation

Closed-won events write the deal amount and owner to Sheets automatically. An IF formula calculates commission based on your tier structure. Updates the moment a deal closes.

Agency client reporting

Pull pipeline data for each client into separate sheets. Monthly reports refresh automatically — no manual work, no stale numbers, no Sunday night CSV exports.

Frequently Asked Questions

Use Autometon. Create a pipeline, get your webhook URL, paste it into HubSpot's webhook settings, map fields to your sheet columns, and activate. Setup takes under 5 minutes — no Zapier account, no task limits, no per-sync charges.

You need HubSpot Professional or Enterprise for webhook access. Starter and Free plans don't include the Webhooks API. If you're on a lower plan, you can use HubSpot's native Zapier integration as an alternative, or upgrade to Professional.

In real time. HubSpot fires a webhook within seconds of an event. Autometon receives it and writes to your sheet within 5 seconds. There's no polling delay and no refresh needed — data is always current.

Yes. Include the pipeline_id field in your webhook payload and map it to a Pipeline column. Use separate tabs per pipeline, or a single tab with a Pipeline column you can filter. Autometon handles multiple pipelines on a single webhook URL.

No. Webhook payloads pass through Autometon's infrastructure and land directly in your Google Drive. Autometon never stores your CRM data — it lives in your Google Sheet, under your Google account, controlled entirely by you.

Autometon queues failed events automatically. You get an email or Slack alert instantly. Fix the issue — wrong column name, sheet permissions, or API rate limit — then replay all queued events in order. Nothing gets lost.