• 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

Anistatik

Member
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?
 
P

Pabblymember11

Guest
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.
 

Anistatik

Member
Hello,

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.

1712151927859.png


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


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.

1712152125404.png


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

Pabblymember11

Guest
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.
 
P

Pabblymember11

Guest
Hi, check this out please. let me know if you need help in this, (https://github.com/MuaazBinAamir/Go...main/PabblyWebhookSendOnChange1minuteInterval)

this script is modified version of this one (https://forum.pabbly.com/threads/google-sheets-1-minute-trigger.12927/)

it is currently configured to check for changes (automatic or manual both changes) after every 10 seconds
That's great! Could you also let us know if it will trigger the row regardless of only passing data in the trigger column?
 

Muaaz

Member
That's great! Could you also let us know if it will trigger the row regardless of only passing data in the trigger column?
It will detect any change in table, as it is storing the state of whole table after each check, so any change in table data will get detected
 
Top