Mistakes happen—whether it’s a misconfigured workflow or an internal change that unintentionally updates property values in HubSpot. Unfortunately, HubSpot doesn’t have a native function to revert all property changes made by a workflow. However, there’s a workaround! By leveraging HubSpot’s property history export and import tools, you can revert property values to their previous state with minimal hassle.
This hack will guide you through the process of exporting property history, identifying the correct values, and re-importing them to restore your data.
Go to Settings > Properties in HubSpot.
Use the Filter dropdown to select the object type (e.g., Company, Contact, Deal, or Ticket).
Search for the property you want to revert.
Hover over the property and click More > Export property history.
Open the exported file in Excel or Google Sheets.
Apply Filters to Row 1 (the header row) of your spreadsheet.
Locate Column D (or the column with the most recent property values).
Filter the data to the date when the incorrect property values were changed by your workflow.
Open a new spreadsheet.
Copy the filtered property values you want to restore into the new spreadsheet.
Include a column that identifies the record, such as Company ID or Contact ID.
Update the header row to match the property names in HubSpot.
Go to your HubSpot Imports page:
Select Start an Import > File from computer > One file > One object.
Choose the object type (e.g., Contact, Company, Deal).
Check the box for updating existing objects exported from HubSpot to avoid creating duplicates.
If you’re trying to revert a property value that was previously blank, you may encounter errors during the import. Here’s how to handle it:
Mistakes in workflows or property updates can be stressful, but HubSpot’s historical data export feature provides a reliable way to revert changes. By following this guide, you can restore your data to its previous state and avoid hours of manual corrections.
Whether it’s a misstep in workflow enrolment triggers or unexpected internal changes, this hack ensures you can always reference and restore historical property values.
Save time, reduce stress, and keep your HubSpot data clean and accurate!