Google Sheet webhook problem

[kellymann]

Consent to Access & Modify

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

After i submit send test or submit, it says "waiting for webhook response" for 1 hour and its not connecting

 

[Preeti Paryani]

Hello @kellymann,

Could you please confirm whether column A contains both the header and the data in the rows? Additionally, have you tried clicking the "Send test" button, and if so, did you receive any errors?

If you could share a screencast of the test, it would be very helpful for us to understand the problem better.

 

[kellymann]

yes column A contains both the header and data in the rows. Also when i click sent test, i dont receive any errors, nothing happens

 

[kellymann]

as you can see here, the send test button is unclickable after i click it and it shows no errors

 

[kellymann]

this keeps on turning around

 

[Preeti Paryani]

Hello @kellymann,

Could you please join us for a quick Google Meet so we can look into the issue and assist you with it?

 

[kellymann]

yes send link to email thanks

 

[Preeti Paryani]

Hello @kellymann,

Please join us using the following meeting link - https://meet.google.com/pac-ugvy-kyi

 

[Preeti Paryani]

Hello @kellymann,

Thanks for joining the meet. As the reported issue has been resolved, we’d appreciate it if you could share quick feedback on the support received:
https://forms.gle/GAjS4wdPYKuhnEYV9.

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.

 

[kellymann]

Ok thanks, I think i figured out the google sheets problem. But now i am having a problem when i try to set it up on webinarkit. Here is what im looking to do:

Once a new row is updated in my google sheets, it registers it as a new webinar registration on webinarkit. However, nothing is happening. For example:

This is my contacts master list, which is then dripped to the next sheet successfully. However, no registration in webinarkit happens.