To kick things off, make sure you are logged into your Slack account via your browser.
If you’re ready to get started, let’s go through each step in detail. If you don’t, go and check out the Google Apps Script docs first. Note: You’ll need some basic experience of Google Apps Script and/or JavaScript to understand everything in this article. Transform the data into a format understandable by Slack.Fetch data from your spreadsheet using Google Apps Script.How to send Slack Alerts from Google Sheets / Google Apps Script. To do that, we use a few simple Google Apps Script functions, along with the Slack API. As a result, over the past few years, there have been several instances where we needed to get information out of our spreadsheets and into a Slack message.
Slack works perfectly for both our internal communication (extremely useful during the home working/COVID-19 period) and as a way of connecting and sharing information quickly and transparently with our clients. In fact, there are seemingly endless possibilities.Īs a result, we run a lot of things through Google Sheets here at August. They have the ability to integrate with other Google Services, query external services via Add-Ons and APIs, share data between sheets, import data from around the web and much more. It’s fair to say, I’m a pretty big fan of Google Sheets and Apps Script.
0 kommentar(er)
