• 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

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

Why not Google Sheet Deep Integration? Webhook is failing all the time

GauravBR

Member
Your Task History ID
IjU3NjUwNTZmMDYzMDA0M2M1MjZiNTUzYzUxMzY1MTZhNTQzOTBmMzAi_pc This was after updating my response from Gsheet to Webhook.
I have gone through multiple issues where Google sheet record updates were not being triggered (I am an automation expert and I know when I should expect answer from a weebhook) by all the methods mentioned like send on event, send on schedule etc but despite trying all of them, Nothing worked and I always had to send custom data manually to run those automations depending on the Google sheet new / updated raw.
What I found is, Pabbly team is not admitting this issue since long where webhook are not working as intended, I could trace so many complaints related to same and everytime it was told that this was browser cache issue which is beyond my understanding and it was never acknowledged as a serious issue.

What I did to resolve this issue?
I setup Activepieces account since they are offering 1000 tasks free everymonth and they have Google deep integration which means I don't have to rely on webhook extension to work like pabbly.
Now everytime a record is being added / updated, I convert it into json like this
JSON:
{
  "Order": "{{trigger['values']['A']}}",
  "Value": "{{trigger['values']['B']}}",
  "Order Date": "{{trigger['values']['C']}}",
  "Logistics Partner": "{{trigger['values']['D']}}",
  "Courier": "{{trigger['values']['E']}}",
  "Tracking ID": "{{trigger['values']['F']}}",
  "Dispatched Date": "{{trigger['values']['G']}}",
  "Est Delivery Date": "{{trigger['values']['H']}}",
  "Current Status Time": "{{trigger['values']['I']}}",
  "Current Status": "{{trigger['values']['J']}}",
  "Current Activity": "{{trigger['values']['K']}}",
  "Current Location": "{{trigger['values']['L']}}",
  "Remark": "{{trigger['values']['M']}}",
  "Tracking link": "{{trigger['values']['N']}}",
  "First Name": "{{trigger['values']['O']}}",
  "Phone": "{{trigger['values']['P']}}",
  "Item Title": "{{trigger['values']['Q']}}"
}

Please note, Above json structure is as per Google Columns and their respective value. YOu can use GPT to generate yours if Google sheet is failing (My suggestions to fellow friends who are going through the same issue)
Which maintains same format as my used automation values in pabbly to process next steps of automation and it worked. Using this method solved a critical issue where automation with so many steps was able to migrate from Google sheet Webhook from Pabbly to Webhook without requiring additional changes inside any of automation steps.
This could have been avoided if Pabbly team paid attention to so many requests related to webhook failure on GOogle sheet. I seriously wish to have deep integration by Pabbly to ensure it is way easier to use.

Thank you!
 
Top