Google Sheets Extension issue
Status: Closed · Asked by Troy Coker on · 0 views
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.
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.
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.
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?
Hello @troycoker08,
No, you do not need to do anything else. Let us know the results.
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.
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.