![]() ![]() Populate your sheet from Jira by going to the menu Add-ons -> Jira Cloud for Sheets -> Open… Get Jira cloud for Google sheets and install it using these instructions: Step 2 ![]() Long story short by connecting Jira cloud for Google sheets and Google Sheets for workflow builder I managed to pull information from a Jira filter and present the result in Slack weekly. We already get messages when a particular watched Jira issue is changed but I was rather looking for aggregated information I could use as metrics and so on. ![]() I wanted to have a weekly notification in our team Slack channel based on the status of our Jira tickets. If, however, you are starting from scratch with your own spreadsheet, the script editor will be empty and you will need to follow the steps below to set things up.How to create a workflow to send messages in Slack based on Google Sheets or Jira content Note: If you copied the template spreadsheet above, all of the required code will already be in place (well, all apart from your webhook URL, which we’ll get to in step 4). Once your spreadsheet is ready, you need to access Google Apps Script. You want to get this data into a Slack alert. The spreadsheet contains a simple table listing fundraising revenue for the past month. Our dummy data is for a fictional charity. For the purposes of this article, I have set up a simple Google spreadsheet with dummy data – feel free to make a copy of this spreadsheet (make sure you are logged into a Google account and then go to File > Make a copy), or alternatively use your own Google spreadsheet (either is fine). Now that you have set up your Slack App, you are ready to send it some data. Step 2: Fetch data from your spreadsheet using Google Apps Script. Happy days! Keep this browser tab open though, you’ll need to come back to it later. Your Slack App is now ready to start receiving data from an external service. Once you are ready to start sending alerts to a shared channel, set up a different webhook for that channel. This allows you to play around with how the Slack alert will appear and fix any presentation issues before you release your alert ‘in the wild’. Tip: While you are testing your Slack alert, I recommend you select a Slack channel that only you have access to. ![]() Toggle ‘Activate Incoming Webhooks’ to on, and then click the ‘Add New Webhook to Workspace’ button:įinally, select the Slack channel that you want the Slack alert to appear in and click ‘Allow’: From the left hand menu, select ‘Incoming Webhooks’: Without going into too much detail, a webhook is a mechanism that allows you to send information from an external service to your Slack App. It doesn’t do anything just yet though… you need to do one more thing to allow Google Apps Script to communicate with your App, and that’s to set up something called a ‘webhook’. Select your company’s development workspace (if you are only a member of one company, there should only be one option here), and hit ‘Create App’: To set up your new custom app, click on ‘Your Apps’ in the main nav:Ī modal will load, where you can provide a name for your App. Everything you need to know about the Slack API is here. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |