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

[GauravBR]

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

{
  "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!

 

[ArshilAhmad]

Hi @GauravBR,

Thanks for your suggestion! We've forwarded it to our technical team.