Google Sheet Webhook with spreadsheets filled in by scripts

[olegshevlyagin]

hey guys,

i am using pabbly for a while now and it works perfect for my need.

My process is triggered by new row appearing in the google spreadsheet, which can be created by a google form and action script (that copies it from other google spreadsheet). I noticed the webhook doesnt work when the action script adds a row (meaning that, a row appears in the google doc but pabbly cant seem to be triggered with this event). Is there anything i can do about it?

 

[Supreme]

Hey @olegshevlyagin

In your script that allows you to trigger the data when you manually edit the triggering column.

You must have used a Time-Driven trigger event in your script or something similar to get that work.

Alternatively, you can use our own Google Sheets Addon - Pabbly Connect Webhooks that you can use in your sheet.

Check the following reference videos:

Pabbly Connect Webhooks provide you following options:
Send On Event
This option allows sending a specific row of data immediately as soon as the data is added to the trigger column of the row.

Auto Send on Schedule
This option allows sending data being added from an external source to Google Sheet with a time interval of 1 hr. Open the sheet from where you want to send data, and then enable this option.

Send Custom Data
This option allows sending data within a specific range of rows. Example- A2: B6.

Send All Data
This option allows for sending whole data from the sheet.
Try this addon once in your Google Sheet, I hope that will solve the problem.

 

[olegshevlyagin]

i actually do use the google chrome pabbly extension. is this the same with Google Sheets Addon - Pabbly Connect Webhooks ?

 

[Supreme]

Hey @olegshevlyagin

As we can see from your workflow, your workflow has correctly executed the whole process successfully.

Kindly cross-check again and let us know if you are having any further issues.

Moreover, the "Auto Send on Schedule " ad on option will allow sending data being added from an external source to Google Sheet with a time interval of 1 hr. Open the sheet from where you want to send data, and then enable this option.