Google sheet to Discord is not working

[uv2michelle]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjYwNTY1MDYzZjA0Mzc1MjY1NTUzMTUxMzMi_pc

Consent to Access & Modify

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

Im successful set up google sheet to discord but when new row in google sheet thats not automatic update to my discord.

 

[uv2michelle]

Hi, This is second connect.
Im already successful connect google sheet to Discord, but not automation when add new row

 

[Preeti Paryani]

Hello @uv2michelle,

Could you please confirm how the data is getting added to your Google Sheets?

To make your automation work, you need to enable 'Send On Event' 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. Follow the steps below to set 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.

 

[uv2michelle]

Thanks got it!

 

[ArshilAhmad]

We're glad we were able to help.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support

 

[ArabellaDavenport]

Hello @uv2michelle,

Could you please confirm how the data is getting added to your Google Sheets?

To make your automation work, you need to enable 'Send On Event' 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. Follow the steps below to set 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.

Thank you, you made my day.