Stop exporting CSV files. This guide shows you how to build a live CRM dashboard in Google Sheets that updates automatically every time a deal moves, a contact changes, or a sale closes — using Autometon webhooks.
Your CRM is the source of truth for pipeline data — but getting that data into the hands of executives, RevOps, and finance teams often means clunky exports, outdated reports, or expensive BI tool licenses.
Google Sheets solves this elegantly. Everyone already has access. Formulas, pivot tables, and charts are powerful enough for most reporting needs. And when you connect your CRM to Google Sheets with real-time webhooks, your dashboard stops being a snapshot and becomes a live feed.
A CRM dashboard in Google Sheets gives you:
The traditional approach: Export CSV from CRM → clean data in Excel → paste into Google Sheets → update charts manually. This takes 30–60 minutes per report and the data is stale the moment you finish. Autometon eliminates all of it.
You need three things: a Google account with Google Sheets access, a CRM that supports webhooks (HubSpot, Salesforce, Pipedrive, Zoho, Close, and most others do), and a Autometon account (free to start, no credit card required).
You don't need coding skills, API keys, or a developer. The setup takes about 5 minutes.
Before connecting your CRM, set up your destination sheet with the right column structure. Autometon will write one row per CRM event — a deal update, contact change, or new lead — so your sheet becomes a running log of every CRM activity.
For a sales pipeline dashboard, we recommend these columns as a starting point:
Put this in a sheet tab called Raw Data. Your dashboard charts and pivot tables will live on a separate tab called Dashboard, pulling from Raw Data. This separation means your dashboard never breaks when new rows come in.
Here's how to connect your CRM to the Google Sheet using Autometon:
Log in to Autometon and click New Pipeline. Select your CRM from the source list (HubSpot, Salesforce, Pipedrive, etc.). Autometon generates a unique webhook URL for your pipeline.
Paste your Autometon webhook URL into your CRM's webhook settings. In HubSpot, this is under Settings → Integrations → Webhooks. In Salesforce, use Outbound Messages or a Flow. In Pipedrive, go to Tools → Webhooks. Select the events you want to track (deal updates, contact changes, etc.).
Trigger an event in your CRM — update a deal, add a contact, or use the "Send test" button in your CRM's webhook settings. Autometon receives it and auto-detects all available fields.
Autometon's visual field mapper shows every field in the incoming webhook payload. Drag each one to the column in your Google Sheet where it should land. Autometon's AI suggests the best match automatically — you just confirm or adjust.
Share your Google Sheet with Autometon's service account email (shown in your dashboard). Click Activate Pipeline. From this point, every matching CRM event automatically writes a new row to your sheet in real time.
Once data is flowing into your Raw Data tab, the dashboard tab builds itself with standard Google Sheets features.
Use SUMIF to total deal values by pipeline stage:
=SUMIF('Raw Data'!D:D,"Proposal",'Raw Data'!E:E)
Create a row for each stage (Qualified, Demo, Proposal, Negotiation, Closed Won) and turn it into a bar chart. This is your pipeline funnel — it updates the moment a deal moves stages.
=COUNTIF('Raw Data'!B:B,"deal.won")/COUNTIF('Raw Data'!B:B,"deal.*")
Use a pivot table: Insert → Pivot Table → source range is your Raw Data tab. Rows = Owner, Values = Deal Value (Sum). Refresh and it recalculates. Or use SUMIF for a formula-based version that updates live.
Add a MONTH() column in your Raw Data tab (hidden if you prefer), then pivot by month to show revenue or deal count trending over time.
Pro tip: Use Google Sheets' Conditional Formatting on the Stage column to color-code deal stages. At a glance, executives can see pipeline health without reading a single number.
Each CRM sends slightly different webhook field names. Here's what to expect when mapping fields in Autometon for the most popular CRMs:
| CRM | Deal field | Stage field | Value field | Owner field |
|---|---|---|---|---|
| HubSpot | properties.dealname | properties.dealstage | properties.amount | properties.hubspot_owner_id |
| Salesforce | Name | StageName | Amount | Owner.Name |
| Pipedrive | current.title | current.stage_id | current.value | current.user_id.name |
| Zoho CRM | Deal_Name | Stage | Amount | Owner |
| Close | lead_name | status_label | value | assigned_to_name |
Autometon auto-detects these field names when you send a test event and suggests the right mappings. You don't need to look these up manually — the table above is just for reference if you're pre-planning your sheet columns.
Set up a live CRM dashboard in under 5 minutes. No code, no CSV exports, no manual updates.
Get Started Free