Google Sheet webhook problem

[Preeti Paryani]

Hello @kellymann,

Could you please try adding the webhook as per these steps? Let us know how it goes.

Also, since you're adding the data via an app script, kindly follow the steps below to add a webhook to the Google Sheets.

• Log in to a single Google Sheets account.
• Open the spreadsheet from where you wish to send data. Make sure your sheet has a header column and at least one row of data in it.
• Navigate to "Extensions" in the Sheets menu and click on "Apps Script" to open the Apps Script editor.
• Remove any existing Apps Script code visible in the Code.gs file. Paste the entire App Script code from this link: Webhook Custom App Script. Save the project and close the Apps Script page.
• Reload the spreadsheet. A new menu called "Pabbly Webhooks" will appear in the menu bar. Click on "Pabbly Webhooks" and select "Send rows every minute".
• Authorize the script when prompted by Google. Once authorization is complete, navigate again to "Pabbly Webhooks" and click "Send rows every minute".
• Enter your Pabbly Connect webhook URL in the dialog box that appears. You can also add the webhook URL and trigger column name, separated by a comma. Click "Yes" to confirm the setup.

Please feel free to reach out to us, if you face any issues in the future.

If this does not help, we will connect over a Google Meet.