Hello!
I’m struggling to set up my first workflow, to update contact records on google sheets using the Google Sheet integration.
I’ve set it up so that - in theory - whenever a contact name or last name gets updated on SalesHub, the change is reflected on a google sheet.
In practice I have two issues:
1. I couldn’t find any “whenever property value changed” but only “property value change: value is known”, so it only works once. If a contact gets an update in the name, the workflow doesn’t run, I guess because it goes from “known” to “known” and not “unknown” to "known.
2. Even for contacts with blank Name/Last name, it says on HubSpot that the workflow ran correctly, but the sheet doesn’t actually get updated. What could this be?
Sending screenshots attached.
Thank you in advance! 
Hey @giogiogio
For the second issue, you might consider checking this detailed guide: Add data to Google Sheets with workflows
Kindly go through this and let us know if you have any doubts!
Solved using Colin’s solution
Hey @giogiogio,
regarding the first issue with the Google Sheet native integration: The “is known” trigger actually works exactly as you need it (just make sure re-enrollment is active). If it doesn’t work as expected, switch the trigger type to “filter criteria met” instead of the event-based trigger.
Details here “How re-enrollment triggers work”:
For the second issue:
Could it be, that the “Company Name” is not a unique value, so the Google Sheet Integration can’t figure out which cell to update?
Best
Colin
Hey Colin,
Thank you! I went through the sheet and found a duplicate, I deleted that row, re-ran the automation and now it works.
I also enabled re-enrollments to enable update of already-filled fields.
Thank you so much!
Have you tried using connectors like Superjoin?
You won’t have to go through the trouble of setting up workflows for this. They have auto-sync, so you pull data once, map the columns and the name will get auto-updated when you do it on Sales Hub.
I’ve used this for deal status and worked pretty good.
Setting up dynamic syncs from HubSpot to Google Sheets through native workflows can get a little tricky, especially around triggers and data reliability.
Issue 1: Workflow only runs once (value is known trigger)
The trigger “property value is known” only fires the first time that field gets a value, not when it changes later. To track every update, you need to use the trigger: “Contact property changed”
You might not have seen this because it’s buried a bit deeper in the workflow setup. It will trigger any time the property value is modified, regardless of whether it’s going from blank to filled or filled to updated.
So in your case, set up the workflow to trigger when:
Contact property is updated > First Name OR Last Name
Issue 2: Sheet not updating even though the workflow says it ran
This could be a couple of things:
- Double-check that your Google Sheets action in the workflow is correctly mapped to the right fields (e.g., First Name and Last Name).
- Make sure the Google Sheet still has API permissions connected to your HubSpot account. If there was an expired token or disconnected integration, it might silently fail.
- Also, be sure the row is being matched correctly. To update an existing row, configure a Lookup column and match it to a HubSpot property containing a unique identifier, such as Email or Record ID. Otherwise, the workflow may create a new row.
If You’re Continuing to Hit Friction:
If you’re finding this setup brittle or hard to manage (especially at scale), you might want to try a tool like Coefficient from HubSpot’s marketplace. It syncs HubSpot data live into Google Sheets (2-way sync), so you don’t need to rely on workflows at all. Your Sheet updates automatically whenever HubSpot data changes.
You can even schedule automatic refreshes or filter the data however you like.
Here’s a quick walkthrough if you’re curious:
Hope that helps!
