How do you get HubSpot deals into Google Sheets without paying for a full connector?

Curious what people actually run in production for pipeline → Google Sheets.

Context I’m seeing:

  • Official HubSpot Sheets add-on seems aimed at pushing contacts into HubSpot
  • Native workflow → Sheets looks Pro-hub gated
  • Coefficient / Superjoin work but scheduled refresh gets spendy fast
  • Otherwise it’s CSV exports or Zapier that drifts when deals update

If you keep a deal/pipeline Sheet updated:

  1. What do you use?
  2. Rough cost?
  3. What’s still annoying (associations, stage history, seats, formulas getting wiped, row limits)?

Not selling anything — genuinely trying to understand the current “least bad” path for a small team. Roast my assumptions if they’re wrong.

Hey @preflightchecklist, welcome to the HubSpot Community, and thanks for asking!

Did you check our APIs, these might help!

Also, I’d love to hear from our Top Experts: Hi @Josh, @rebeccatravels and @alyssamwilie do you have suggestions to help @preflightchecklist n please?

Thanks so much and wishing you a lovely day!
Bérangère