)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
HubSpot exports dates as long numbers like 1620710374103 because it stores dates internally as Unix timestamps (milliseconds since January 1, 1970). When using HubSpot’s native Google Sheets workflow integration, these timestamps aren’t automatically converted to readable formats.
Here’s why this happens and how to get properly formatted dates in your Google Sheets integrations.
The technical reason behind HubSpot’s timestamp exports
HubSpot’s API returns dates in Unix timestamp format for system consistency across different platforms and integrations. Google Sheets doesn’t automatically recognize these 13-digit numbers as dates without conversion, and HubSpot’s native workflow integrations don’t include automatic date formatting.
This creates a fundamental gap where date data exports as incomprehensible numbers instead of usable dates for analysis and reporting.
Fix the integration limitation using Coefficient
CoefficientHubSpotsolves this integration problem by providing intelligent data type recognition duringimports. The tool automatically detects timestamp fields and converts them to proper date formats, eliminating the confusion of number strings in your spreadsheet.
How to make it work
Step 1. Replace native HubSpot workflows with Coefficient imports.
Instead of relying on HubSpot’s workflow-based Google Sheets integration, install Coefficient and connect your HubSpot account directly through the sidebar’s “Connected Sources” menu.
Step 2. Select your HubSpot objects and date properties.
Choose the HubSpot objects you need (contacts, deals, companies) and select the date properties that would normally export as timestamps. Coefficient displays these fields clearly in the import interface.
Step 3. Import with automatic timestamp conversion.
Click “Import” and watch as Coefficient automatically converts all timestamp fields into readable dates. This includes creation dates, last modified dates, deal close dates, and custom date fields.
Step 4. Set up scheduled imports for ongoing data.
Configure automatic imports to run at your preferred intervals (hourly, daily, weekly). Each import maintains proper date formatting without the limitations of HubSpot’s native workflow integration.
Get usable date data from HubSpot integrations
Start usingHubSpot’s timestamp export format creates unnecessary complexity for spreadsheet analysis. Coefficient bridges this gap with automatic date conversion, ensuring your HubSpot data imports in an immediately usable format.Coefficient for better HubSpot-Google Sheets integration.
