Pavlo B.
Offer Pavlo work on your next project.
Private message
Offer work
Kyiv,
Ukraine
7 months 19 days back
available for hire
on the service 3 years
Rating
Successful projects
Average rating
Skills and abilities
Programming
Portfolio
-
101 USD Discord BOT
PythonDiscord bot for automating audit management and administration of Discord servers with integration of Google Sheets and an advanced logging system.
Technologies
… Python 3.x
Discord.py — interaction with Discord API
Google Sheets API — data synchronization with spreadsheets
SQLite3 — local storage of logs and data
Asyncio — asynchronous command processing
PyTZ — working with time zones
Core functionality
Access management
- Automatic granting and revocation of access rights to Google Sheets
- Role management on servers (granting/removing)
- User verification system in the database
Monitoring and analytics
- Detailed logging of all interactions with the bot
- Command usage statistics by categories
- Security system with protection against spam attacks and rate limiting
- Security reports and threat detection
Administrative tools
- Mass unassignment of members while preserving privileged roles
- Warning system for administrators
- Auto-cleaning of outdated logs for performance optimization
- User search by nickname/email across multiple servers
Security
- Whitelist of trusted bots
- Protection against rate limiting and flooding
- Detection of mass message deletions
- Logging of unauthorized access attempts
- Caching with TTL to reduce database load
Architectural solutions
Modular structure — separation of logic into classes (BotLogger, SecurityManager)
Database optimization — indexes for fast searching, query caching
Error handling — try-except blocks with detailed logging
Pagination — breaking large data into pages in embed messages
Google OAuth2 — secure authorization via service account
Implementation features
- All commands implemented via Slash Commands (app_commands)
- Support for multiple servers with separate configurations
- Working with timestamps in the Moscow time zone
- Interactive embed messages with detailed information
- Automatic synchronization with Google Sheets upon data changes
Results
The bot processes commands on 7+ Discord servers, manages access to a centralized database, and automates routine administrative tasks, reducing request processing time from several minutes to several seconds.
The project demonstrates skills in working with APIs, asynchronous programming, database design, and creating scalable solutions for automation.