Automatically updates pipeline stage in GHL whenever leads status in google sheet changes
Status: Closed · Asked by Omni Digital on · 0 views
So I have a google sheets full of leads data with one leads status column. If I change the leads status column from unresponsive to success, the pipeline stage in GHL won't changed. I have a workflow which I automatically send new leads to GHL contact and opportunity depends on the leads status.
Hi,
Thanks for reaching out. The behavior you're seeing — changing the lead status column in Google Sheets not triggering the update to your GHL pipeline stage — is almost always related to how the value is entered in the trigger column rather than the workflow itself. Pabbly Connect's Google Sheets trigger only fires when the sheet registers a committed cell update on the configured trigger column.
Please check the following:
1. Commit the value with Enter — If your status column uses a dropdown (data validation), you must select the value AND press Enter (or Tab / click away) so Google Sheets registers the change. Simply clicking the dropdown option is sometimes not enough to push the update to Pabbly.
2. Avoid dropdowns, formulas, and data validation in the trigger column when possible. Formula-generated values especially do not reliably fire the trigger because Google Sheets does not treat a formula recalculation as a user edit. A plain text/value column works most reliably.
3. Confirm the trigger column is correct — In the Pabbly Connect add-on (Extensions -> Pabbly Connect Webhooks -> Initial Setup), verify the configured Trigger Column letter matches the status column you are actually updating.
4. Make sure the add-on is installed, and the trigger is active in that specific sheet. Initial Setup is complete, and Send on Event (if the data is added manually) or Auto Send on Schedule (if added via third party) is enabled.
To test: manually type a value in the status column, and press Enter. If the workflow fires, the issue was with how the value was being entered (dropdown/formula) rather than the workflow configuration.
Once the trigger fires reliably, your existing action steps that send data to GHL contact/opportunity based on lead status will run as expected.
If it still doesn't trigger after this, please share your workflow details and a sample of the sheet, and we'll investigate further.
Hi, thanks. I'm gonna try this now. But I have one more issue. So I experimented this:
I updated the leads status data on an existing row for example from unresponsive to success
I checked on GHL, yes the leads status for that contact changes from unresponsive to success
The pipeline stage don't move. It stays at Junk leads (unresponsive goes to junk leads), not Closed (Success leads goes to closed)
Can you help me fix this? Thanks
Pabbly Support:
Hi,Thanks for reaching out. The behavior you're seeing — changing the lead status column in Google Sheets not triggering the update to your GHL pipeline stage — is almost always related to how the value is entered in the trigger column rather than the workflow itself. Pabbly Connect's Google Sheets
Also if I changed the leads status, will it fires in an instant or is there a delay time? And what if I use "Auto send on schedule" instead of "send on event"?
Omni Digital:
Hi, thanks. I'm gonna try this now. But I have one more issue. So I experimented this:I updated the leads status data on an existing row for example from unresponsive to successI checked on GHL, yes the leads status for that contact changes from unresponsive to successThe pipeline stage don't move.
my workflo https://connect.pabbly.com/v2/app/workflow/mapping/IjU3NjcwNTY4MDYzNzA0MzA1MjY1NTUzZDUxMzYi_pc
Hello,
Thank you for sharing the details.
To address all your questions regarding the workflow, including the current issue with the workflow, the trigger behavior/delay, the difference between “Send on Event” and “Auto Send on Schedule,” and how you can resolve the pipeline stage issue, we have recorded a detailed video explaining everything.
Kindly refer to the video here:
https://www.awesomescreenshot.com/video/56048967?key=1c15a46d7c9f51b49474d779aa4a5523
We have also explained the steps you can follow to resolve the current issue with your workflow, so you can make the required changes yourself.
If you have any further questions or need any clarification, please feel free to let us know.
Hi. Thanks
Anyway, I tried changing the phone number by typing it directly on the Google sheets, but the automation didn't trigger.
The contact number on GHL stays the same. I use trigger on event already
Hello,
Thank you for the update.
To help you further and investigate why the automation is not triggering when the phone number is changed directly in Google Sheets, it would be better to connect over a Google Meet.
Kindly book a convenient slot using the link below:
https://calendly.com/d/dz6k-k7j-yby
Once the meeting is booked, we can discuss the issue and check the workflow with you in detail.
Hello,
Thank you for connecting with us over the Google Meet.
Glad to know that your concern has now been resolved. We will proceed with closing this ticket within the next two days.
We would really appreciate it if you could take a moment to share your feedback about the support you received:
https://www.trustpilot.com/review/www.pabbly.com
Thank you for your time and continued support.