Slack to Notion Template

slack_to_notion

Github

slack_to_notion

Owner

hkob

Updated

Jul 28, 2022

1. Prepare a database

1. Please copy the following database to your favorite page (append workspace_name select property from ver 0.3)

2. Create integration key and save the token

1. Visit my-integrations page, and create an integration key.
Notion - The all-in-one workspace for your notes, tasks, wikis, and databases.
A new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team

https://www.notion.so/my-integrations

2. In this description, I use input_tasks integration key.

3. Copy internal integration token and write it.

3. Invite the integration and obtain database_id

1. Open the Slack Stock DB database, and invite the above integration.

2. Obtain the page URL. The red text in the URL is the database id.

https://www.notion.so/hkob/771391e755c245b2a31290f40f187ab9?v=19b6c58912764cc2900e8af0afe204e3

3. Copy the database_id from the URL and write it.

4. Prepare Google Apps Script

1. Open a new Google Spreadsheet and open Apps Script.

2. Copy a scripts from github repository and paste to the script editor.
github.com
https://github.com/hkob/slack_to_notion/raw/main/code.js
Slack2NotionScript

3. Set the integration token saved at 2.3 to MY_NOTION_TOKEN in line 4.

4. Set the database_id saved at 3.3 to DATABASE_ID in line 5.

5. Select storeTokenAndIds and execute it.

6. At the first time, OAuth client verification is required. Please allow this Google Apps Script like as the following link.
OAuth Client Verification | Apps Script | Google Developers
Verification is Note: not required for Apps Script projects whose owner and users belong to the same Google Workspace domain or customer. If you don't verify your script project's OAuth client, users outside your domain see an unverified app screen when they try to authorize your script.

https://developers.google.com/apps-script/guides/client-verification

7. If storeTokenAndIds can be executed, you can see the above two parameters in execution log.

8. Select testCreateNotionPage and execute it in order to verify that the above token is correct. If successful, the test data is registered in the database.

9. Deploy the first version using New deployment.

10. Write Description and select Anyone as “Who has access”

11. Copy Web app’s URL and write it

5. Create Slack App

1. Open Slack API page
Slack API: Applications | Slack

https://api.slack.com/apps?new_app=1

2. Click Create an App

3. Select From scratch

4. Set App Name and pick a workspace

5. Click Event Subscriptions

6. Turn on Enable Events

7. Set Web app’s URL saved at 4.8 to Request URL . If the deployment is correct, it should be Verified.

8. Push Add Bot User Event in Subscribe to bot events and choose rection_added.

9. Click OAuth & Permissions in the left menu.

10. Click Add an OAuth Scope in Bot Token Scopes and add the following scopes
1. channels:history
2. channels:read
3. reactions:read
4. team:read (from ver 0.3)
5. users:read

11. Click Install App tab and click Install to Workspace. Grant permissions when the dialog appears. After successful installation, you will be redirected to the OAuth Tokens for Your Workspace page.

12. Copy Bot User OAuth Permissions and write it.

13. Click Basic Information and Copy Verification Token in App Credentials and write it.

6. Add Slack tokens to Google Apps Script

1. Set the verification token saved at 5.13 to the left-hand side of the ":” in line 11.

2. Set the Bot User OAuth Token saved at 5.12 to the right-hand side of the “:” in line 11.

3. If you have another workspace, append the corresponding verification token and Bot User OAuth token pair.

4. Select storeTokenAndIds and execute it. You can see the above parameters in execution log.

5. You can see these parameters at Script Properties in Project Setting. If you set VERIFICATION_TOKEN and BOT_USER_OAUTH_TOKEN in the previous version, please delete them.

7. Add the created app to channels

1. Select a target channel and click View channel details

2. Select Integrations tab and click Add an App.

3. Click Add button for the SlackToNotion

8. Setup is complete

• Please add a 📌 reaction  to any message.

9. Other implementations

9.1 Property only version

• Append “link” properties (url) and “whole_message” properties (text)

• Replace the code with the one below
raw.githubusercontent.com
https://raw.githubusercontent.com/hkob/slack_to_notion/main/code_only_properties.js

• Redeploy Web App in GAS, and copy new Web app’s URL

• Open Event Subscription page in Slack api, and Change Request URL

10. Update from Ver 0.2

1. Add team:read to OAuth Scope of Slack App (see 5.10) Click Add an OAuth Scope in Bot Token Scopes and add the following scopes

2. Obtain the new sciprt from Github and replace your Google Apps script. (see 4.2) Copy a scripts from github repository and paste to the script editor.

3. Set your verifycation token at the left hand of : (see 6.1) Set the verification token saved at 5.13 to the left-hand side of the ":” in line 11.

4. Set your Bot User OAuth Token at the right hand of : (see 6.2). If you are installing in multiple Slack workspaces, add the Slack App token created in each workspace in the same way. Set the Bot User OAuth Token saved at 5.12 to the right-hand side of the “:” in line 11.

5. Try running testCreateNotionPage and verify that the workspace name is registered in the database. (see 4.8) Select testCreateNotionPage and execute it in order to verify that the above token is correct. If successful, the test data is registered in the database.

6. Deploy the modified source according to steps 4.9-11. Record the generated new URL. (see 4.9-11) Deploy the first version using New deployment.

7. Register the recorded URL by pressing Change in the Event Subsctipt. (see 5.7) Set Web app’s URL saved at 4.8 to Request URL . If the deployment is correct, it should be Verified.