Send Slack Message From Google Sheet via Apps Script
ฝัง
- เผยแพร่เมื่อ 15 ก.ย. 2024
- 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- bit.ly/google-...
Automate internet explorer with VBA- goo.gl/Xmy8Af
Autoit tutorials for beginners- goo.gl/JHB1E2
Selenium Webdriver tutorials for beginners -goo.gl/QqxTrF
***** Contact me *******
Blog: www.amarindaz.c...
FB page: / amarindaz
****** Books written by me *******
Autoit tutorials for beginners: amzn.to/2GjaDbD
Excel VBA for beginners: amzn.to/2nhI067
****** Productivity tool ********
My Favorite TH-cam Tools ➜ goo.gl/MX9Z4p and ➜goo.gl/UW1uRX
****** Gear Used To Shoot This Video *****
_Audio & Microphone
amzn.to/2GibdGu
*******Learning partner*******
Video courses ➜click.linksyne...
Don't forget to subscribe! goo.gl/J2453w
💼 To Hire Me 👉 fwd.cx/WLGgpTi...
Checkout my app 👉 www.myfreshtoo...
You're my hero!! Thanks!!
Thank you very much sir
This is awesome. I'm looking to have it send a message when a row is edited and grab the value in column A as the message. Any suggestions?
did you found maybe any solution to that?
Awesome! Thanks for the useful and easy way by google app script. Is the message with attaching file is also possible?
I wanna know too
Very helpful video. Can you help me on adding gifs to the Slack messages?
thanks for great video. is there any method that can delete sended message....??
@Amarindaz Very informative video.....Can you make a video how to send messages to telegram from google sheet when any of google sheet cell value is updated...like i want track a perticular price movement , whenever price is updated in the cell, trigger a telegram message once a day...please i've searched a lot in youtube but did'nt found similar to my query.....
Can we send to specific users?
Top
Any Costs if we use this in orginazation account
Hello guys, when i fetching the Data, my calender events always in GMT-5 format. Do you guys know how to fetching the data with GMT + 7?
I already check my google account timezone, and its already set up for GMT + 7. Thats why I dont know where to find the bug.
Thank you in advance
Current bug:
Your appointment is coming up on Yay at Wed Feb 09 2022 06:00:00 GMT-0500 (Eastern Standard Time)
Expected result:
Your appointment is coming up on Yay at Wed Feb 09 2022 18:00:00 GMT-0700 (Jakarta Time)
Bro I didn’t understand how to post message from google sheet.
Can you post the changes I need to do
nice, do you have one tut making inverse, write slack messages to google sheet?
following
How to send a text from the Spreadsheet?