Google Sheets Extension issue

Status: Closed · Asked by Troy Coker on · 0 views

troycoker08 — Question ·

I have been using Pabbly Sheets extension quite successfully for some time. Rows are filled from a 3rd party app and the extension triggers the webook payload to be sent to the endpoint. The job has recently been stopping midway however. Has a timeout or threshold been introduced that I'm not aware of? I have included the task history of the row that the job stopped on overnioght still with 50 or more rows to complete.

Preeti Paryani — Reply ·

Hello @troycoker08,

Please follow the steps below to set the webhook, and let us know if you can capture the rows correctly:

  • Log in to a 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.

troycoker08 — Reply ·
Hello @troycoker08,

Please follow the steps below to set the webhook, and let us know if you can capture the rows correctly:

  • Log in to a 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.

Thank you . I have done this. I will monitor and get back to you. Regards.
troycoker08 — Reply ·
Thank you . I have done this. I will monitor and get back to you. Regards.

quick question. do I disable or delete the previous extension?
Preeti Paryani — Reply ·

Hello @troycoker08,

No, you do not need to do anything else. Let us know the results.

troycoker08 — Reply ·
Hello @troycoker08,

No, you do not need to do anything else. Let us know the results.


Everything functioning now as per expectations. I deleted the other 2 tabs as well, created a new sheet, applied the code and all good. Thank you for your assistance.
Arshil Ahmad — Reply ·

Thank you for the update. Glad we were able to help.

We’d appreciate it if you could also share quick feedback on the support received - https://forms.gle/GAjS4wdPYKuhnEYV9

Thank you for your time.

Back to all forum threads · Log in to reply