• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Google Sheets automation not executing

ghalitzka

Member
I've had a problem a few times where one of my employees fills out a row in Google Sheets which is supposed to trigger Pabbly automations...but for no reason I can discern, the automations do not trigger. There's no error message and nothing in the Pabbly log...it's simply that nothing happens, as though the webhook event never occurred. If I go into the relevant row in Google Sheets and delete then refill the contents of the trigger column, everything executes just fine on the second try. Do you have any idea what might be causing this problem? The workflow URL is where the problem most recently occurred. (I can't provide a task history ID because none was generated...as I said, there's nothing at all in the Pabbly log.) Thank you!
 
P

Pabblymember11

Guest
Hey @ghalitzka

You can only use "Send On Event" when setting up Google Sheets if the data is coming from a Google application or if you manually enter it. If the data is coming from a third-party application, however, you may need to choose "Auto Send On Schedule" or "Send on Schedule," which will forward the data in exactly one hour.

Additionally, make sure the data was filled up to your trigger column.

1684755790661.png


Moreover, for a better understanding of the trigger event of Google Sheets and the initial setup, you can check the following video lesson.

 

ghalitzka

Member
I'm afraid your response doesn't address my concern. The workflow typically executes just fine. The problem is that on rare occasions, it does not execute at all. But when that happens, there is no error logged or any other indication that the trigger was received into the workflow. Nonetheless, the trigger column was completed in Google Sheets, and there's no visible reason why the workflow did not execute. Can you offer any insights on that problem? Thank you!
 
P

Pabblymember11

Guest
The workflow typically executes just fine. The problem is that on rare occasions, it does not execute at all. But when that happens, there is no error logged or any other indication that the trigger was received into the workflow.
We need more information on when and in what condition it is not getting triggered.

Also, please share the task history ID from your workflow where you have noticed the same.
 

ghalitzka

Member
Unfortunately, I don't know in what conditions it's not being triggered--it seems to be random. There is no task history ID from the workflow when it doesn't trigger (I wish there was because I realize it would make troubleshooting easier), but when this problem occurs, it's as though Pabbly simply never received a webhook. But it's clear that the trigger column in our spreadsheet has been completed and therefore should have started the workflow.

The error occurred in this Google Sheet: https://docs.google.com/spreadsheet...LEncMUQ-3nxGfnT9skMI2Cu_U/edit#gid=1738955149 in row 18. An employee filled in the whole row, including marking an X in trigger column AZ, but the workflow did not execute. When I deleted the employee's entry in column AZ and marked an X again the next day, it executed just fine. The workflow in Pabbly is https://connect.pabbly.com/workflow/mapping/IjU3NmMwNTZmMDYzNTA0MzU1MjZlNTUzNiI_3D_pc

Thanks for any insights you can provide!
 
P

Pabblymember11

Guest
Can you please tell us that are you getting the data in the Google Sheets from a third-party application or adding manually?
 
P

Pabblymember11

Guest
In that case, it is not possible to trace the problem from the Google Sheets.

We can suggest you use a new Google Sheets or capture the webhook response again. Since the Google Sheets trigger event is working fine at our end as it is processing the Google Sheets data accordingly.
 
P

Pabblymember11

Guest
Are you feeding the data to your main Google Sheets manually or getting it with the help of Formula or Appscript?
 
Top