Send Slack Message From Google Sheet via Apps Script
In this video, you'll learn how to send a slack message from Google Sheets using Google apps script.
Create a Slack channel where you want to send a message and select the channel for generating a webhook on the slack.
In slack, you can create an app and configure a webhook and get the curl command to send message.
You'll also learn how to convert the curl command to the Google apps script method to send a message to your slack channel.
You can customize this method and send slack messages based on various conditions.
Timestamp
00:11 How to Send Slack Message from google sheets
00:56 Logged into slack with Active Workspace
01:11 Go to slack API website
01:25 Create a custom app by giving an app name
01:35 Select the slack development workspace
01:53 Select the Incoming webhooks
02:08 Activate the slack incoming webhook
02:34 Create a slack channel to receive a slack message
03:10 Click on Add new webhook to workspace
03:23 Select the channel to post a message
03:33 Copy the Webhook URL
03:45 Launch Script Editor
04:24 Conver the curl command to Google apps script method
06:55 Authorize the sheet
07:07 Run the method to send a message from Google sheets
07:35 Verify the response and response code
07:40 Go to slack and verify the message is received
Please do let us know if you have any questions.
********* Tutorial Playlists *********
Google apps script tutorial for beginners- https://bit.ly/google-apps-script-tut...
Automate internet explorer with VBA- https://goo.gl/Xmy8Af
Autoit tutorials for beginners- https://goo.gl/JHB1E2
Selenium Webdriver tutorials for beginners -https://goo.gl/QqxTrF
***** Contact me *******
Blog: http://www.amarindaz.com/contact/
FB page: / amarindaz
****** Books written by me *******
Autoit tutorials for beginners: http://amzn.to/2GjaDbD
Excel VBA for beginners: http://amzn.to/2nhI067
****** Productivity tool ********
My Favorite YouTube Tools ➜ https://goo.gl/MX9Z4p and ➜https://goo.gl/UW1uRX
****** Gear Used To Shoot This Video *****
_Audio & Microphone
http://amzn.to/2GibdGu
*******Learning partner*******
Video courses ➜https://click.linksynergy.com/fs-bin/...
Don't forget to subscribe! https://goo.gl/J2453w
💼 To Hire Me 👉 https://fwd.cx/WLGgpTiZW5HK
Checkout my app 👉 https://www.myfreshtools.com