🧐 Slack Chat Catcher

Automate aggregating number of messages and reduce workload

🔥 Motivation

Reduce workload for staffs aggregating posted messages.

This app will:

• Enter the Slack Channel ID, Google Spread Sheet ID and set period of time. Then run the application, it will automatically update Google Spreadsheet with results.

🛫 Getting Started

Before running any scripts, you'll need additional setups. After 2 steps, you should run the next command.

$ pip install-r requirements.txt
$ python app.py

Steps:

1. Setup API key and environment variables

🔑 1. Setup API Key for GCP

1. Visit Google Developer Console and create a new project.

• Enable Google Sheets API
• Create service account
• Create OAuth 2.0 client ID
• Download JSON files (Name the file as client_secret.json from service account and credentials.json from 0Auth 2.0 client ID), set files in root directory.

🔑 2. Setup Token for Slack

1. Acces Slack API and create a new app

• Set permission. The permisson should cover :
  • conversations.history, conversations.replies and users.info
• Issue a token

After creating all necessary keys, run next command and paste appropriate values. Please modefy the SECRET_KEY.

$ cp .env.example .env

_Note: To develop this app with Pyhon, making virtual environment is recommended.

🛠 How To Use

Enter the Slack Channel ID, Google Spread Sheet ID and set period of time. Then click the submit button to get messages and update Google Spreadsheet.

🚧 Warning

This app is:

• Expected to be a temporary solution
• Not designed to be scalable
• Not designed for mobile or with accessability (some are included in UI library)

⛓ Reference

• Create a Google Cloud project
• Google Sheets API
• Create the OAuth web client ID
• Slackの特定チャンネルのメッセージをクロールする方法
• conversations.history
• conversations.replies
• users.info
• SlackのチャンネルIDを調べる方法