Google Sheets Extension issue

[troycoker08]

Your Task History ID

IjU3NjUwNTZiMDYzNDA0MzI1MjZmNTUzYzUxMzc1MTY1NTQzNzBmMzAi_pc

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]

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]

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]

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]

Hello @troycoker08,

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

 

[troycoker08]

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.

 

[ArshilAhmad]

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.