# Smartsheet App Integration **URL:** \ **Category:** Tips, Tricks & Best Practices\ **Tags:** free\ **Created:** [October 6, 2023, 4:50am UTC](https://community.hubspot.com/t/smartsheet-app-integration/91251 "2023-10-06T04:50:58Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![KristinaD](https://avatars.discourse-cdn.com/v4/letter/k/4af34b/32.png) [@KristinaD](https://community.hubspot.com/u/KristinaD)\ **Post date:** [October 6, 2023, 4:50am UTC](https://community.hubspot.com/t/smartsheet-app-integration/91251/1 "2023-10-06T04:50:58Z")
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 ---
**Author:** ![danmoyle](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmoyle/32/91166_2.png) [@danmoyle](https://community.hubspot.com/u/danmoyle)\ **Post date:** [October 6, 2023, 6:59pm UTC](https://community.hubspot.com/t/smartsheet-app-integration/91251/2 "2023-10-06T18:59:01Z")
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. ---
**Author:** ![KristinaD](https://avatars.discourse-cdn.com/v4/letter/k/4af34b/32.png) [@KristinaD](https://community.hubspot.com/u/KristinaD)\ **Post date:** [October 9, 2023, 5:40am UTC](https://community.hubspot.com/t/smartsheet-app-integration/91251/3 "2023-10-09T05:40:51Z")
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 ---
**Author:** ![AlbertBer](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@AlbertBer](https://community.hubspot.com/u/AlbertBer)\ **Post date:** [August 30, 2025, 4:14pm UTC](https://community.hubspot.com/t/smartsheet-app-integration/91251/4 "2025-08-30T16:14:18Z")
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](https://skyvia.com/data-integration/integrate-hubspot-smartsheet), you can set field-level sync rules (e.g. HubSpot always overwrites Smartsheet) so updates flow consistently. ---
**Author:** ![Berangere](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/berangere/32/220784_2.png) [@Berangere](https://community.hubspot.com/u/Berangere)\ **Post date:** [September 1, 2025, 11:26am UTC](https://community.hubspot.com/t/smartsheet-app-integration/91251/5 "2025-09-01T11:26:27Z")
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](https://ecosystem.hubspot.com/marketplace/apps/smartsheet-data-sync) 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](https://knowledge.hubspot.com/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**](https://ecosystem.hubspot.com/marketplace/apps) **🟠 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**](https://knowledge.hubspot.com/integrations/match-records-in-data-sync) Appreciate the contribution, please keep sharing your solutions! If anyone else has experience with [Smartsheet](https://ecosystem.hubspot.com/marketplace/apps/smartsheet-data-sync), Skyvia, or alternative integration tools, let us know your approach below. Have a great day! Bérangère ---
**Author:** ![AlbertBer](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@AlbertBer](https://community.hubspot.com/u/AlbertBer)\ **Post date:** [September 3, 2025, 12:45pm UTC](https://community.hubspot.com/t/smartsheet-app-integration/91251/6 "2025-09-03T12:45:29Z")
Hi [@BérangèreL](https://community.hubspot.com/t5/user/viewprofilepage/user-id/230185), 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: ![AlbertBer_0-1756903098206.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/8/0/80c43d71c5378a8a337d0168f867278fc15bcf9b.png) You can learn more about Skyvia Import and UPSERT in the documentation: > **[Configuring Import](https://docs.skyvia.com/data-integration/import/configuring-import.html)** > **[How to Perform UPSERT Operation](https://docs.skyvia.com/data-integration/import/how-to-guides/performing-upsert-operation.html)** 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.