)
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’s CSV import treats each row as a complete record update, not an append operation. When you import duplicate rows hoping to add checkbox selections, HubSpot replaces the entire property value instead of merging selections.
Here’s how to preserve existing checkbox values while adding new selections through intelligent data management in your spreadsheet.
Merge checkbox values before syncing using Coefficient
CoefficientHubSpotHubSpotsolves this problem by letting you pull existing data, merge values in your spreadsheet, then push the complete dataset back toand. This ensures all checkbox values remain intact while adding new selections.
How to make it work
Step 1. Import contacts with their current checkbox values.
Use Coefficient to pull existing contact records showing current checkbox selections. For example, you might see “Product Interest: Widget A, Widget B” in your spreadsheet.
Step 2. Add new selections in adjacent columns.
Create a new column for additional checkbox values you want to add. Enter the new selections like “Widget C” in the appropriate rows.
Step 3. Use formulas to combine existing and new values.
Create a formula to merge the values: =CONCATENATE(B2,”, “,C2). This results in “Widget A, Widget B, Widget C” with all selections preserved.
Step 4. Export the merged data using Coefficient’s UPDATE action.
Push the complete checkbox selections back to HubSpot. The export process properly formats multiple values for HubSpot’s API, avoiding the overwrite behavior entirely.
Keep all your checkbox data intact
Start preservingCoefficient’s bi-directional sync ensures you’re always working with current data and can append new checkbox selections without losing existing ones. Ready to stop losing checkbox data?your selections today.
