)
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.”
CoefficientHubSpotfully supportscustom properties sync, addressing the significant limitation of basic export functionality that requires manual field mapping and loses custom property relationships.
Here’s how to import all custom property types with automatic field mapping and preserved data relationships.
Import HubSpot custom properties with automatic field mapping
All custom property types are supported including text, number, dropdown, date, checkbox, and calculation properties from both standard and custom objects. Custom properties appear as selectable columns with friendly field names preserved.
How to make it work
Step 1. Access the import wizard and connect to HubSpot.
Open Coefficient’s sidebar and select your HubSpot connection. Choose the object type (contacts, deals, companies, etc.) that contains your custom properties.
Step 2. Browse and select custom properties.
All custom properties appear in the field selection alongside standard fields. Choose which custom properties to include as Google Sheets columns – you’ll see friendly field names rather than internal API names.
Step 3. Configure data type preservation and formatting.
Numbers, dates, and text maintain proper formatting in sheets automatically. Dropdown values, checkboxes, and calculation properties display correctly without additional formatting needed.
Step 4. Set up conditional filtering with custom properties.
Apply filters using custom property values (like “Lead Score” > 50) or reference sheet cells for dynamic custom property criteria that change based on your analysis needs.
Step 5. Enable historical tracking for custom property changes.
Use snapshots to preserve custom property value changes over time, allowing you to analyze lead scoring progressions, custom lifecycle stage movements, or industry-specific property trends.
Analyze your custom data without manual mapping
Start syncingThis eliminates manual mapping and data transformation while maintaining data relationships and enabling automated updates for all your custom HubSpot fields.your custom properties with Coefficient today.
