• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Can't Get Pabbly Webhook to Hear When A GSheets Row is Updated


Pabbly's Gsheet Plugin:

If the row is being updated by another action script command and not manually typed into, the trigger won't activate because it only triggers when cells are manually edited by a user.

In this case, I got ChatGTP to write an Appsscript for the OnChange option to detect changes made by scripts or formulas. The script works but still only manual edits. Pabbly still doesn't hear the trigger.

function onChange(e) {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var editedRange = spreadsheet.getActiveRange();

if (editedRange) {
var sheet = editedRange.getSheet();

// Check if the edited range is in column G
if (editedRange.getColumn() == 6) {
var editedValue = editedRange.getValue();

// Trigger the webhook if the value is not empty
if (editedValue !== "N/A") {
var headers = sheet.getRange(1, 1, 1, sheet.getLastColumn()).getValues()[0];

// Get the row index of the edited range
var rowIndex = editedRange.getRow();
var rowData = sheet.getRange(rowIndex, 1, 1, sheet.getLastColumn()).getValues()[0];

// Create an object to hold the column headers and values
var payload = {
"rowData": {}
for (var i = 0; i < headers.length; i++) {
payload.rowData[headers] = rowData;

// Add the edited column and value to the payload
payload["editedRange"] = editedRange.getA1Notation();
payload["editedValue"] = editedValue;

// Trigger the webhook
var url = "Your Webhook Here";
var options = {
"method": "POST",
"contentType": "application/json",
"payload": JSON.stringify(payload)
UrlFetchApp.fetch(url, options);

How do I get Pabbly to hear changes being made to cells from Gsheets scripts?


Well-known member
Staff member
Hey @Anistatik

If you are utilizing Formula and Appscript in Google Sheets and find that they are not functioning properly to automatically forward data to the workflow, we advise our users to consider using the "Auto Send on Schedule" option when passing data from a 3rd party.

Alternatively, if data is being passed manually, it is recommended to choose the "Send On Event" option.



Thanks for the reply. I"ve tried your solution a few different ways. I've tried with the Pabbly plugin only with Auto Send on Schedule checked.


I have the plugin setup to trigger when column G receives new data.

The issue still remains that it only activates Pabbly webhook when the cell is manually typed in.

However, I need Pabbly to reconiize when my client dashboard links are being generated in column G. This generation automatically occurs from a Google script.


Is there another workaround? Perhaps a simulation of typing in the cell? I'm unsure.


Well-known member
Staff member
The issue still remains that it only activates Pabbly webhook when the cell is manually typed in.
If you manually update the trigger columns, it will function as expected. However, if you attempt to update the trigger columns from a third-party application, it will not work.