How to Connect HubSpot, Gmail, and Google Sheets Into One Dashboard

If you sell B2B, your data lives in three places: deals in HubSpot, communication in Gmail, and the real numbers in a Google Sheet you maintain yourself because the CRM reports never quite match reality.

You probably switch between these three tools dozens of times a day. Here's how to stop doing that.

Why These Three Tools Don't Talk to Each Other

HubSpot, Gmail, and Google Sheets each have integrations with each other, but they're surface-level:

• HubSpot + Gmail: Logs emails to deal records, but doesn't give you send counts, reply rates, or cadence visibility at the dashboard level
• HubSpot + Google Sheets: Requires Zapier or a third-party connector, syncs slowly, and breaks when field names change
• Gmail + Google Sheets: No native connection at all without scripting

The integrations that exist are one-directional and fragile. What you actually need is a unified read layer that pulls from all three and presents a single picture.

The Architecture

Here's how to connect all three into one dashboard:

Gmail API

The Gmail API gives you access to:

• Emails sent today and this week (filtered by label or recipient domain)
• Reply counts and response times
• Draft counts (how much outreach is queued up)
• Thread data for calculating cadence position

You'll need OAuth credentials and a service account. Google's API documentation walks through setup. The key endpoints are messages.list and messages.get with query filters.

HubSpot API

HubSpot's CRM API provides:

• Active deals with stage, value, and owner
• Contact and company records
• Deal stage history for pipeline movement tracking
• Activity timeline for last-touch data

The free CRM API tier covers everything most small teams need. Use the deals endpoint with property filters to pull exactly what you want.

Google Sheets API

The Sheets API reads from your existing spreadsheets:

• Pipeline data you track manually
• Custom metrics or forecasts you maintain outside the CRM
• Historical data that predates your CRM setup

This is the "source of truth" layer — the spreadsheet numbers that reflect reality when the CRM and the spreadsheet disagree.

Bringing It Together

A data script (Python works great) runs on a schedule and:

1. Authenticates with all three APIs
2. Pulls the relevant data from each
3. Normalizes it into a consistent format
4. Writes JSON files that your dashboard frontend reads

The dashboard loads the JSON on page load and renders the unified view. No real-time API calls from the browser, which means faster load times and no rate-limit issues.

Run the script every 1-2 hours and your data stays fresh without complexity.

What the Unified View Looks Like

On one screen, you see:

• Email activity panel: Sends, replies, drafts, and response times from Gmail
• Pipeline panel: Deal stages, values, and movement from HubSpot
• Numbers panel: Your spreadsheet metrics — the actuals you trust
• Discrepancy highlights: Where HubSpot and your spreadsheet disagree, so you can reconcile quickly

No tab switching. No mental merging of data from three sources. One screen, one picture.

The Zapier Alternative (and Why It Falls Short)

You could connect these tools through Zapier. Many people do. But Zapier introduces:

• Latency: Zaps run on triggers with delays, not on a reliable schedule
• Fragility: Field name changes, API updates, or auth token expirations break Zaps silently
• Cost: Complex multi-step Zaps eat through your task quota fast, pushing you to $50-100/month plans
• Limited transformation: Zapier is good at moving data, not at shaping it into a useful view

A direct API integration is more reliable, more flexible, and has zero ongoing cost after the build.

Getting Started

If you're comfortable with APIs, start with the Gmail API — it's the most immediately useful and the authentication flow teaches you the OAuth pattern you'll reuse for Sheets. Add HubSpot next (simpler auth, just an API key for private apps). Sheets comes last since it's the most straightforward.

If you'd rather have someone build the entire integrated dashboard for you, that's our bread and butter at Contriboot. We connect the tools you already use into a single view you own.