Skip to content
No description, website, or topics provided.
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
images
.claspignore
.gitignore
README.md
index.js
package-lock.json
package.json

README.md

gas-kpt-bot

HOW TO USE

1. Clone & Init

$ git clone git@github.com:zuckeyM-17/gas-kpt-bot.git
$ npm install
$ npm run login

2. Create Google Spreadsheet

Create Google Spreadsheet and you get it's URL like below.

https://docs.google.com/spreadsheets/d/【Google Spreadsheet ID】/edit#gid=0

3. Create Google Apps Script linked with this Spreadsheet

$ npx clasp create "slack kpt bot" "【Google Spreadsheet ID】"

4. Get Slack Incoming Webhook URL and modify index.js

ref: https://api.slack.com/incoming-webhooks

update index.js line 1

5. Deploy

npm run deploy

6. Open Google Apps Script Console and Publish this script

Introduction as web application

Introduction as web application

Setting Setting

Get URL for POST Get URL for POST

7. Set Outbound Webhook at Slack

ref: https://api.slack.com/custom-integrations/outgoing-webhooks

Triger words is below.

K,P,T,k,p,t,start,end

Ref

https://blog.zuckey17.org/entry/2018/05/06/183500
https://blog.zuckey17.org/entry/2018/04/29/235946
http://blog.zuckey17.org/entry/2018/06/09/153731
http://blog.zuckey17.org/entry/2018/06/10/220034

You can’t perform that action at this time.