What This Update Actually Is
HubSpot has added Google Sheets and Microsoft Office 365 Excel as supported data sources in its data layer. That data layer sits underneath the CRM. It's where external data lives in its original structure before any CRM mapping happens.
Here's what that means in plain English: you connect a spreadsheet once. HubSpot shows you a live preview of the data before you commit. Once you confirm, that sheet is saved as a recognized source in HubSpot's data layer and can sync with your CRM records.
Right now, in private beta, the functionality is scoped to syncing those data sources with the CRM. HubSpot has confirmed that segments, reports, and workflow triggers based on these sources are coming as a fast follow. That's worth keeping in mind before you redesign your entire data strategy around it.
This is a private beta. Submitting a request doesn't guarantee access. HubSpot reviews requests based on available capacity.
Why HubSpot Shipped This
Spreadsheets aren't going away. Account lists, market segments, enrichment data, campaign inputs built outside HubSpot, territory breakdowns, financial snapshots from the CFO's team: all of it lives in sheets. That's not a bad habit. It's just how teams actually work.
The old path was painful. Export from one tool, reformat the columns, import into HubSpot, match fields, discover three things didn't map, fix them, import again, then find out the data still wasn't where you needed it. Humans doing that work over and over aren't adding value. They're just moving data.
HubSpot's answer is to let the sheet connect directly and live in the data layer without forcing you to decide upfront how every column fits your CRM schema. That removes a gatekeeping step that slowed down data ops work across the board.
This fits a larger pattern in how HubSpot is evolving its data infrastructure. If you want more context on where this is headed, our breakdown of HubSpot Data Studio and the new data management home explains the layer this Sheets integration is being built on top of.
How to Use It Step by Step
- Go to the HubSpot App Marketplace from inside your portal.
- Search for "Google Sheets Data Ingestion" or "Microsoft Office 365 Excel Data Ingestion" depending on which tool your team uses.
- Install the integration and connect it to your HubSpot account by following the on-screen steps.
- Select the specific file and the sheet tab you want to bring in as a data source.
- Review the live data preview HubSpot shows you before you commit.
- Confirm the connection. Your sheet is now saved as a source in HubSpot's data layer.
- Proceed to sync that data source with your CRM records, which is the current scope of the beta.
That's it. No custom field mapping required before you can even see the data. The preview step is genuinely useful because it lets you catch formatting issues before they reach your CRM.
What It Touches in Your HubSpot Strategy
Even in beta form, this update has real implications for how you think about data in your portal. Let's break down what it actually touches.
CRM Records and Contact Data
The immediate use case is syncing spreadsheet data to CRM records. Think enrichment lists, territory assignments, account tier classifications, or intent data your team maintains outside HubSpot. These can now flow into your CRM without a manual import cycle every time the sheet changes.
Key Takeaway
You don't have to pre-map your spreadsheet to CRM schema before connecting it. The data layer holds it in its original structure, which means you can connect first and decide how to use it after.
Operations Hub and Data Management
This is fundamentally an Operations Hub story. The data layer this integration writes to is where HubSpot is building its external data infrastructure. Rev ops leaders who've been managing messy import workflows will feel this the most.
Once segments, reports, and workflows unlock in the fast follow, this becomes a much bigger deal. Imagine segmenting contacts based on a column in your account scoring sheet without ever importing that data as a custom property. That's the direction this is heading.
Key Takeaway
The real power isn't the beta feature itself. It's what comes next. Segments and workflows built on live spreadsheet data will change how rev ops teams build automation without recreating data that already exists.
What's Not Touched Yet
Be clear-eyed here. You can't build reports off these sources yet. You can't trigger workflows from them yet. You can't create list segments from them yet. Those are coming, but don't build a process that depends on them before they ship.
The humans running RevOps for growing companies often have data in five different places, none of them talking to each other cleanly. This is a step toward fixing that. For a broader look at why clean, connected data matters so much right now, read our piece on what it actually means for B2B customers to feel known.
Who Should Care Most
This update will resonate differently depending on your role. Here's who should be paying attention right now.
- Rev ops and marketing ops leaders who manage recurring data imports will save significant time by replacing manual workflows with a live connected source.
- HubSpot admins at companies that use spreadsheets as the source of truth for enrichment, territory, or account data will find the CRM sync immediately useful.
- Growing companies with lean data teams who can't afford to rebuild their spreadsheet-based processes inside HubSpot from scratch will benefit most from the schema-free connection model.
- Sales ops leaders managing territory lists, account tier assignments, or partner data in Excel should consider requesting beta access now so they're first in line when segmentation and workflow features drop.
This is available to all hubs and tiers, so there's no seat at the table you need to earn. If you work with spreadsheet data and HubSpot, this is relevant to you.
George's Take
I've been inside a lot of portals where the biggest bottleneck wasn't strategy, it was data access. Humans on the team knew exactly what they wanted to do with their account data or enrichment lists, but getting that data into HubSpot cleanly took so long that some teams just stopped trying. They'd run campaigns off the spreadsheet instead. This update doesn't solve everything yet, but it removes the friction that caused that workaround in the first place. The schema-free data layer approach is smart. It meets teams where they actually are instead of demanding they restructure their data before HubSpot will even look at it. Watch this one closely. When segments and workflows unlock, the teams that already have their sheets connected will move fast.
“The teams that already have their sheets connected will be first to build when segments and workflows unlock. Don't wait until that feature ships to start getting familiar with the connection process.”
If your portal is sitting on spreadsheet data you've been meaning to integrate, now is a good time to get ahead of it. We'd love to help you map out exactly which data sources to connect first and what your strategy should look like once workflow support arrives. Book a strategy call with the Sidekick team and let's build the plan together.
Frequently Asked Questions
What spreadsheet tools can I connect to HubSpot as a data source?
Right now, HubSpot supports Google Sheets and Microsoft Office 365 Excel as data sources. You install the integration from the App Marketplace, search for the specific integration by name, and connect your file and sheet tab. HubSpot shows a live preview before you finalize the connection.
Do I need to map my spreadsheet columns to HubSpot CRM fields before connecting?
No. That's one of the key differences with this integration. Your spreadsheet data lives in HubSpot's data layer in its original structure. You don't have to decide upfront how it fits your CRM schema. Mapping decisions come later, after the data is already connected and syncing.
Can I build reports or workflows from my connected spreadsheet data yet?
Not yet. In the current private beta, functionality is limited to syncing the connected data source with your CRM. HubSpot has confirmed that segments, reports, and workflow triggers based on sheet data are coming as a fast follow update. Plan for that, but don't build processes that depend on it today.
Who can access the Google Sheets and Excel data source integration?
The integration is available across all HubSpot hubs and tiers. However, it's currently in private beta. You can submit a request for access from the App Marketplace, but access isn't guaranteed. HubSpot reviews requests based on available capacity.
What's the difference between this integration and a regular HubSpot import?
A regular import is a one-time file upload that requires you to map columns to CRM properties before the data is usable. This integration connects a live sheet as a persistent data source in HubSpot's data layer. The sheet stays connected, and you don't lose the data when HubSpot updates it through syncing.
What HubSpot hub does the Sheets data source integration belong to?
This is primarily an Operations Hub capability. It writes to HubSpot's data layer, which sits underneath the CRM. Although all hubs and tiers can access it, rev ops and operations teams managing external data sources will find the most immediate value in connecting and syncing their spreadsheets.
