gas-slack2notion

gas-slack2notion is a starter kit to post messages via Google Sheets from Slack to Notion.

Check out this article when you use this template.

👉 How to build a knowledge system with Slack and Notion

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

• Google Sheets
• Google Apps Script
• Clasp
• Webpack
• TypeScript
• ESLint
• Jest
• Yarn

Prerequisites

• Node.js v16+ (v16.13.0)
• Clasp

Install Clasp at the first if you haven't done it yet.

npm install -g @google/clasp

Login google account

npx clasp login

How to use

Clone this repository and install dependencies.

yarn install

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 token and database id.

NOTION_TOKEN=<YOUR_NOTION_TOKEN>
DATABASE_ID=<YOUR_DATABASE_ID>

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