gas-sheets2slack

gas-sheets2slack is a starter kit to post messages from Google sheets to slack.

Check out this article when you use this template.

👉 How to make a reminder posts messages from Google Sheets to Slack

Status

Features

• Just deploy this project code without development
• Develop Locally with TypeScript and Clasp
• Bundle your files with Webpack
• Lint your code with ESLint
• Format your code with prettier
• Built-in test runner with Jest

Main dependencies

• Clasp
• Webpack
• TypeScript
• ESLint
• Jest
• Yarn

Prerequisites

• Node.js v16+ (v16.13.0)
• Clasp
• slack
• Google Sheets

Note: Create an app in slack and get the webhook URL from the dashboard.

How to use

Clone this repository and install dependencies.

yarn install

Login google account

yarn clasp login

Connect to your exiting project

Create a .clasp.json at the root, and then Add these settings. Open App script from your spreadsheet and check out a script Id at the setting page.

{
  "scriptId": "<SCRIPT_ID>",
  "rootDir": "./dist"
}

Create a .env file

Create a .env at the root, and then add your SLACK_WEBHOOK_URL.

SLACK_WEBHOOK_URL=<SLACK_WEBHOOK_URL>

Upload a script project

Deploy your code to the existing project.

yarn deploy

Available Commands

Build your project.

yarn build

Build your project files and force writes all local files to script.google.com.

yarn deploy

Open the current directory's clasp project on script.google.com.

yarn open

Test project's code

yarn test

yarn test:watch

License

MIT