Hi community.
We are syncing HubSpot with Smartsheet but having quite a few issues with data sync. The main issue being name changes / company merges in HubSpot not over-writing Smartsheet and causing errors with the sync.
Does anyone have experience with this feature?
Thanks, Kristina
Hi @KristinaD and welcome to the Community!
So are you seeing issues in Smartsheets from HubSpot data? From the reviews I’ve read, it seems Smartsheet isn’t the greatest tool, so I’d guess you’re seeing some limits on that side. I’d start with the integration settings to see if it needs to be bidirectional and what you can do to manage the data. Then I’d look at Smartsheet to see how to keep the data clean.
In HubSpot, objects like Company are identified by their website (aka company domain name), so HubSpot’s going to try and keep things clean that way. I’m not sure how Smartsheet does that, so that’s where I’d start.
Hi Dan, Thanks for your reply!
We have a one way sync - HubSpot company names and some other properties sync to a sheet in Smartsheet. The sync settings are set so HubSpot data will be used to over-write Smartsheet data. When a company name in HubSpot is changed (as sometimes necessary) or companies are merged, we get this error:
[1130] One of cell.value or objectValue may be set, but not both.
I can’t find any reference to this error code anywhere in HubSpot help. We do not change Smartsheet company names. I’ve tried changing the sync setting to a 2-way sync but that didn’t resolve the issue either.
Thanks, Kristina
Native Smartsheet HubSpot syncs don’t give you much control over how updates are handled, which is why you see issues with name changes or company merges not carrying over. With a tool like Skyvia, you can set field-level sync rules (e.g. HubSpot always overwrites Smartsheet) so updates flow consistently.
Hi @AlbertBer,
Thanks for sharing the Skyvia integration!
Could you please share some screenshots from Skyvia showing how the field-level sync works to help @KristinaD and other Community Members, please?
Also, how exactly would the Skyvia integration help with names changes and company merges, please?
For anyone else navigating HubSpot integrations, whether with Smartsheet or other platforms, here are some helpful HubSpot resources and guides that dig into integration best practices, syncing data accurately, and troubleshooting common issues:
HubSpot Knowledge Base: Integrating Third-Party Apps
Explore detailed articles on setting up and managing integrations:
Connect and use HubSpot data sync
HubSpot Community: App Marketplace Discussions
Join ongoing discussions and see real-world examples of how other users are handling integrations (including Smartsheet, Skyvia, Zapier, and more):
HubSpot App Marketplace Community
HubSpot Blog: Best Practices for Data Sync and Automation
Get tips for planning your integrations and how to make your automation more robust:
Match records in data sync
Appreciate the contribution, please keep sharing your solutions! If anyone else has experience with Smartsheet, Skyvia, or alternative integration tools, let us know your approach below.
Have a great day!
Bérangère
Hi @BérangèreL, sure here is more detailed information about this integration:
With Skyvia Import and the UPSERT operation, you can configure your scenario by replacing the mapping of the Company Name column with a Lookup to other fields.
In your Import integration, you need to select the UPSERT operation and set up Lookup mapping for Company Name using other unique and stable columns (for example Email, Domain, Website, etc.) that can act as identifiers instead of Company Name. This way, even if the Company Name changes in HubSpot, the correct record will still be found and updated.
For example:
You can learn more about Skyvia Import and UPSERT in the documentation:
It is not clear from your description what objects you use, so I can’t provide exact instructions at this moment.
By the way, you can write to support after you create the connectors. They respond quite quickly and help with the setup if something is not clear. When I set it up for the first time, the support helped me with some technical settings.
