Gogole Drive > create spread sheet > tools > script editor > paste main.js > save > run onOpen
- the name of the spreadsheet, and the google apps script can be whatever you want
- onOpen will be called every time you open the spreadsheet
- onOpen creates
Custom Menuin this script
pbcopy < sample-sheet.txt
and paste to the spreadsheet
- lines below the line begin with
#will be ignored by the script
Custom Menu > check right now
Tools > Script editor... > Resources > Current project's triggers > select healthCheck as a function
- my recommendation is to set the interval to every 5 minutes or later
- trigger will be executed even if you close the spreadsheet
| menu | description |
|---|---|
| health check list | make sure health check list was parsed |
| check right now | start checking according to the list |
| notification settings | such as Slack webhook url, or kind of |
| output settings | limit of response body |
| help | show helps |
| name | default | description |
|---|---|---|
| url | (none) | http:// is not required |
| contentType | application/x-www-form-urlencoded |
it may be application/json; charset=utf-8, or whatever |
| headers | (none) | like { "x-my-header": "foobar" } |
| method | get | it may be post, put, or delete |
| payload | (none) | request body, the format is depend on the contentType |
| validateHttpsCertificate | true | don't try to validate if it's set to false |
| expectResponse | { "status": 200 } |
like, { "status": 200, "body": "pong" } |
| purpose | howto |
|---|---|
| create | https://slack.com/apps > Build > Make a custom integration > Incoming Webhooks |
| check | https://slack.com/apps > Manage > Custom Integrations |