Update lead status on google sheet when change is made on hubspot
Hi everyone!
I tried to create a workflow so that when the lead status on Hubspot is changed, the lead status will automatically change on Google Sheet, but it doesn't work. When I change the lead status on Hubspot, the status won't change in the sheet. How can I create a functioning workflow for this?
Thanks for sharing those screenshots. I have a follow up question:
Is the contact being successfully enrolled in the workflow, but their status isn't being updated in the Google Sheet? Or are they not being enrolled in the workflow at all?
Here's how this workflow reads to me:
Anyone who has a campaign source of ppc_gartner and was created between 1/3/23 and 3/3/23 OR anyone who has a source of Paid search and was created between 1/3/23 and 3/3/23 will be enrolled in a workflow to push their lead status over to Google Sheets.
Nothing in the current setup suggests to me that that if you change the lead status of someone that they will then be enrolled and/or re-enrolled in the workflow - is that what you're hoping to have happen?
Whitney Hathcock HubSpot Community Champion ✅ Found my comment helpful? Great! Please mark it as a solution to help other community users.
Update lead status on google sheet when change is made on hubspot
Yes, the contacts have been successfully enrolled in the workflow, but their status isn't being updated in the Google Sheet whenever a change happens on Hubspot. What I'm trying to achieve is for the contacts' lead status on Google Sheet's corresponding column to change whenever the status is changed on Hubspot.
For example, contact X has been enrolled in the workflow with lead status "NEW". So, on the google sheet I can see on the column "Lead Status", on contact X's row, that their status is "NEW". When I change contact X's status on Hubspot from "NEW" to "OPEN_DEAL", I would also like for the status to automatically change on Google Sheet, so that the Lead Status column will now display the status "OPEN_DEAL", but that doesn't happen. The status remains "NEW" on Google Sheet, even though the status is now different on Hubspot. I hope I was clear in my explanation. If not, please let me know!
I'm not sure how to set up a proper functioning workflow for what I'm trying to achieve
Update lead status on google sheet when change is made on hubspot
Thanks for explaining - that was super helpful!
Right now the workflow is only set up to execute actions once. You'll want to adjust your starting criteria (and re-enrollment criteria) to trigger the workflow every time a lead's status is updated.
I'd suggest trying to add the following filter to each of your OR triggers:
AND
Contact Property: Lead Status: Is Known
and then adjust your re-enrollment criteria to re-enroll contacts when lead status is known.
I think this will accomplish what you're trying to do, but definitely suggest testing it out in your own portal!
Whitney Hathcock HubSpot Community Champion ✅ Found my comment helpful? Great! Please mark it as a solution to help other community users.
Thanks for your reply! I tried to use "Contact Property: Lead Status: Is Known" as re-enrollment criteria, and the re-enrollment works. The only problem is that it won't update the existing contact's lead status column in the sheet, but will just create another row of the same contact with the a new lead status. Is there a way to make it update the existing contact? Because otherwise I will have many contact duplicates in the sheet.
Update lead status on google sheet when change is made on hubspot
There is no re-enrollment on your workflow currently other than manual. Add entry criteria that the Lead Status is known and use that for re-enrollment and it will trigger whenever that field is updated.
Thanks for your reply! I tried to use "Contact Property: Lead Status: Is Known" as re-enrollment criteria, and the re-enrollment works. The only problem is that it won't update the existing contact's lead status column in the sheet, but will just create another row of the same contact with the a new lead status. Is there a way to make it update the existing contact? Because otherwise I will have many contact duplicates in the sheet.
Update lead status on google sheet when change is made on hubspot
You will likely need to build this into 2 separate workflows because you cannot do an if/else on google sheets. So the initial workflow criteria should be insert, and the second workflow would be an update one with criteria to only enter and continue to update if they have been through the initial workflow.