Issue triggering with Pabbly Connect Webhook Extension in Google Sheet

[troycoker08]

Hi, I have a two column sheet and am using column B as trigger. Column A is JSON body text. I can manually trigger the webook by cut and paste into the two columns but when I populate the columns using backend Google Sheet script and information appears the webhook does not flow. I have "Auton Send on Schedule" set. Is there a particular way to trouble shoot this issue?

 

[Pabblymember11]

Hey @troycoker08

Could you please tell us if your data is coming from another application or you are manually feeding it? So if you getting data from a third-party application, in that case, you need to check both the options of "Send On Event" and "Auto Send on Schedule" and by enabling both the options then the data can be forwarded in 1hr. That is something associated with Google API and we cannot change or manipulate it from our end.

Kindly make sure that you have opted for both options as per your use case. Other than that we have also checked your workflow and its history logs it is working fine.

 

[troycoker08]

Coming from another application as a non-Simple response (JSON array in Column A) and alphanumeric in column B. column B is the trigger column and with a new/fresh Sheet trigger OK when the blob of information comes in at once (100's of rows sometimes). Unfortunately even with the suggested settings above, the next blob of data (the script clears the Sheet and syncs to a clean Sheet) does not trigger. any ideas as to why this may be the case?

 

[PabblyMember3]

Just to inform you that the app script operations for triggering column may not work properly as the extension itself is running with the app script so, try to make triggering column work on manual input or from other source. It will solve your problem.

 

[troycoker08]

doing this manually defeats the purpose of scripting though doesn't it? I want to automate this. I now have the triggering happening as I am loading the row of data with trigger column/cell one by one. The issue now is that the previous data that is cleared (say 10 rows) is filled with say 100 rows of new data and triggered but only rows 11 to 100 are fired. Any light that can be shed on this would be helpful.

 

[PabblyMember3]

doing this manually defeats the purpose of scripting though doesn't it? I want to automate this. I now have the triggering happening as I am loading the row of data with trigger column/cell one by one. The issue now is that the previous data that is cleared (say 10 rows) is filled with say 100 rows of new data and triggered but only rows 11 to 100 are fired. Any light that can be shed on this would be helpful.

Since, the extension keeps the last added row index for processing the next rows, it is not possible to get the rows that has been already fired.

 

[troycoker08]

ok further testing suggests that the Google Sheet extension is very flakey and not reliable. I'll stay with Pabbly for other workflows but Google Sheet as a trigger via Pabbly Connect Extension returns variable results. I will take this workflow to a competitor for now. Just sayin'