HubSpot Pipeline Tracking in Google Sheets

What you'll build: A Google Sheet that receives every HubSpot deal stage change, creation, and close event in real time. A Dashboard tab shows pipeline value by stage, win rate, and revenue by rep — recalculating automatically as new data arrives.

Why Track HubSpot Pipeline in Google Sheets?

HubSpot's built-in reports are good for operational use — but they're locked behind CRM access, can't be easily shared with finance or executives, and don't blend well with data from other sources. Google Sheets solves all three problems.

With Autometon connecting HubSpot to Google Sheets via webhooks, your pipeline data updates the moment a deal moves — not on a daily export schedule. The result is a live dashboard anyone on the team can view, built with formulas they already understand.

Setting Up HubSpot Pipeline Tracking

Create a Autometon pipeline

Configure HubSpot webhooks

In HubSpot: Settings → Integrations → Webhooks → Create Webhook. Paste your Autometon URL. Subscribe to: deal.creation, deal.propertyChange (for stage changes), deal.deletion. Select the deal properties to include: dealname, dealstage, amount, hubspot_owner_id, closedate.

Send a test event

Update a test deal in HubSpot to trigger the webhook. Autometon receives it and auto-detects all available fields.

Map HubSpot fields to sheet columns

Map dealname → Deal Name, dealstage → Stage, amount → Deal Value, hubspot_owner_id → Owner. Autometon's AI suggests the right match.

Share your sheet and activate

Share your Google Sheet with Autometon's service account email. Click Activate. Pipeline events now flow in real time.

Building the Pipeline Dashboard

Pipeline value by stage

On your Dashboard tab, list each pipeline stage and use SUMIF to total deal values:

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

Repeat for each stage. Insert 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 = Event Type is deal.won. Updates automatically as new deals close.

HubSpot Field Reference

HubSpot Field	Webhook Property	Recommended Sheet Column
Deal Name	properties.dealname	Deal Name
Pipeline Stage	properties.dealstage	Stage
Deal Amount	properties.amount	Deal Value
Owner ID	properties.hubspot_owner_id	Owner
Close Date	properties.closedate	Close Date
Lead Source	properties.hs_analytics_source	Source

Autometon auto-detects these from the webhook payload when you send a test event — you don't need to type them manually.

FAQ

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

Any event HubSpot supports webhooks for: deal.creation, deal.propertyChange (stage changes, amount updates, owner changes), deal.deletion, contact.creation, contact.propertyChange, form submission events, and more. You select which events to subscribe to when configuring the HubSpot webhook.

HubSpot webhooks are available on Professional and Enterprise plans. If you're on Starter or Free, use HubSpot's native Zapier integration or data export — or upgrade to Professional to access the Webhooks API.

Yes. Include the pipeline_id field in your webhook payload and map it to a Pipeline column in your sheet. Use SUMIF with both stage and pipeline_id to separate reporting by pipeline.

HubSpot Pipeline Tracking in Google Sheets: Real-Time, No Code