AttendanceBot
Discord bot that will track reactions on messages and update Google Sheets spreadsheet with corresponding information.
Install / Use
/learn @Zwivee/AttendanceBotREADME
AttendanceBot
Discord bot that tracks reactions to message and adds it to Google Sheet worksheet. Allows the ability to cap reactions on Google Sheets.
Table of contents
General Info
The need arose where tracking attendance for node wars in (Black Desert Online) BDO for certain node sizes. The bot will track what the reaction of ✅.
Where ✅ means the an individual has the intention to show up for node war on given day.
Technologies
Bot is created with:
- Python version: 3.8.5
- Python-dotenv version: 0.15.0
- Discord.py version: 1.5.1
- Google-api-python-client version: 2.1.0
- Gspread version: 3.6.0
- Schedule version: 1.1.0
Setup
To run this bot, install these packages locally using pip:
$ pip install -r requirements.pip
Copy link https://discord.com/api/oauth2/authorize?client_id=747298773130149948&permissions=525440&scope=bot
Select your server and invite the bot.
DON'T FORGET TO RESTRICT BOT TO THE CHANNEL YOU WANT TO KEEP ATTENDANCE
Features
List of current features in v2.2.0.0
- Keep track of ✅ reactions on discord only.
- Record reactions on Google Sheet using Google API v4.
- Command !cap changes the cap on the amount of reactions accepted by the bot.
- Members past cap will be added to waitlist.
- On cap being raised, all members on waitlist will be added to sheet.
- Custom help command
Contact
Created by @Zwivix - feel free to contact me!
Related Skills
node-connect
349.9kDiagnose OpenClaw node connection and pairing failures for Android, iOS, and macOS companion apps
frontend-design
109.8kCreate distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, or applications. Generates creative, polished code that avoids generic AI aesthetics.
openai-whisper-api
349.9kTranscribe audio via OpenAI Audio Transcriptions API (Whisper).
qqbot-media
349.9kQQBot 富媒体收发能力。使用 <qqmedia> 标签,系统根据文件扩展名自动识别类型(图片/语音/视频/文件)。
