Google Sheets/Slack Integration not working

[chintanbagur]

We need to push the content from Google sheets to a Slack Channels when a new row is added in the Google Sheets. I have created a automation and the test results are fine. But the actual automation is not working.

 

[Arshita]

Hey @chintanbagur

I would like to inform you that if the data is coming from a Google application or entered manually, you can use the "Send on Event" option when setting up Google Sheets.
However, if the data is coming from a third-party or external application, then you need to set up the script in Google Sheets. To get a clearer understanding of this and to set up, please refer to the following threads:

Google Sheets (1 Minute Trigger)

Copy and Paste the entire Apps Script code in your Google Sheets App Script. No need to change anything in the code. Make sure that you copy and paste the entire code as it is. Full Tutorial here...

forum.pabbly.com

Google Sheets (1 Minute Trigger) Send New rows in every 1 minute.

In this tutorial, we will see how can you set up Google sheets trigger "New or Updated Spreadsheet Row" in Google Sheet so that you can capture data every minute. Please note: We also offer a Pabbly Connect Webhooks addon for Google Sheets. The current limitations of the Google Sheets trigger...

forum.pabbly.com

Do let us know if you get stuck in any step, so we can check it for you.

 

[chintanbagur]

Hi @Arshita , app script is not working. I am seeing this error

 

[Arshita]

To resolve the issue, I suggest trying to set the script in the incognito mode of the browser. This can be done by opening an incognito window in the browser and attempting to set the script from there. This should ensure that no browser extensions or cache are interfering with the script setting process.

If the issue persists, please let me know and I will assist you further.

 

[chintanbagur]

Hi @Arshita ,
I opened the sheet in incognito mode and the App Script worked. I pasted the given code as it is, saved it and reloaded the Google Sheets document. But I don't see any new Pabbly menu

 

[Arshita]

I would like to inform you that after closing the app script and refreshing the Google Sheet page, it may take some time for Pabbly Webhooks to appear.

Therefore, I request you to please try the process once again and wait for 1 or 2 minutes for Pabbly Webhooks to appear. This delay is due to the system refreshing and updating the information. So, please be patient and wait for a couple of minutes before checking for the Pabbly Webhooks. Once they appear, you can proceed with the next steps in your workflow.

I request you to please delete the script and try again.