Google Sheets Trigger not activating when new rows are added (manual and api)

[Ken Patrick]

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Hello, this is my workflow, https://connect.pabbly.com/v2/app/workflow/mapping/IjU3NjYwNTY0MDYzNTA0M2Q1MjY5NTUzMzUxMzci_pc. I have been testing the Google Sheets trigger, and it has triggered a few times outside of testing, but not during the actual test. I have successfully sent a test with Google Sheets that Pabbly received, turned on send on event and send on schedule, and tested for 2 hours to check if anything activated the workflow (which it has not). Can I get assistance in ensuring the trigger works?

 

[Preeti Paryani]

Hello @Ken Patrick,

Could you please confirm how the data is getting added to the Google Sheets, manually or via a third party?

To make your automation work, you need to enable 'Send On Event' only if you're manually entering data into your Google Sheets. If the data added to your Google Sheets comes from another API or third-party application, please follow the steps below to add the webhook:

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