A Discord BOT that uses Google Sheets for storing the roles and permissions of a discord server.

Overview

Discord Role Manager Bot

Role Manager is a discord BOT that utilizes Google Sheets for the organization of a server's hierarchy and permissions.

Details

This BOT allows for you to export and organize your roles in a Google Sheet in a very user friendly way.

Three requests are made per usage of !export. One for clearing the spreadsheet, one for updating the roles/permission titles and one for the permission values themselves, making it extremely light and difficult for it to hit the Google Docs quota limit.

Installation - Add the BOT to your server

Paste this on your browser to invite the BOT to a server you manage. The BOT requires the Administrator permission.

https://discord.com/api/oauth2/authorize?client_id=823014411945377824&permissions=8&scope=bot

Usage - BOT Commands

!setuphelp # Instructions on how to set up the BOT for your server.

!configure # Add your server to the BOT's database, along with your Google Sheet.

!export # Export your server's roles and their permissions to your Google Sheet.

Requirements (for Developers)

# Regular Module Imports
from os import path, sys
# Discord API Imports
import discord
from discord.ext import commands
# Google Docs/Sheets API Imports
import gspread
from oauth2client.service_account import ServiceAccountCredentials
from googleapiclient.discovery import build

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

License

MIT

You might also like...
Discord bot that manages expiration of roles with subscriptions!

Discord bot that manages expiration of roles with subscriptions!

A discord Server Bot made with Python, This bot helps people feel better by inspiring them with motivational quotes or by responding with a great message, also the users of the server can create custom messages by telling the bot with Commands.
A discord Server Bot made with Python, This bot helps people feel better by inspiring them with motivational quotes or by responding with a great message, also the users of the server can create custom messages by telling the bot with Commands.

A discord Server Bot made with Python, This bot helps people feel better by inspiring them with motivational quotes or by responding with a great message, also the users of the server can create custom messages by telling the bot with Commands.

First Party data integration solution built for marketing teams to enable audience and conversion onboarding into Google Marketing products (Google Ads, Campaign Manager, Google Analytics).

Megalista Sample integration code for onboarding offline/CRM data from BigQuery as custom audiences or offline conversions in Google Ads, Google Analy

A Fork of Gitlab's Permifrost tool for managing Snowflake Permissions

permifrost-fork This is a fork of the GitLab permifrost project. As the GitLab team is not currently maintaining the project, we've taken on maintenac

Create a Neo4J graph of users and roles trust policies within an AWS Organization.
Create a Neo4J graph of users and roles trust policies within an AWS Organization.

AWS_ORG_MAPPER This tool uses sso-oidc to authenticate to the AWS organization. Once authenticated the tool will attempt to enumerate all users and ro

AWSXenos will list all the trust relationships in all the IAM roles and S3 buckets
AWSXenos will list all the trust relationships in all the IAM roles and S3 buckets

AWS External Account Scanner Xenos, is Greek for stranger. AWSXenos will list all the trust relationships in all the IAM roles, and S3 buckets, in an

Unauthenticated enumeration of services, roles, and users in an AWS account or in every AWS account in existence.

Quiet Riot 🎢 C'mon, Feel The Noise 🎢 An enumeration tool for scalable, unauthenticated validation of AWS principals; including AWS Acccount IDs, roo

Compares and analyzes GCP IAM roles.

gcp-iam-analyzer I wrote this to help in my day to day working in GCP. A lot of the time I am doing role comparisons to see which role has more permis

Image-Bot-Discord - This Is a discord bot that shows the specific image you search from Google
Image-Bot-Discord - This Is a discord bot that shows the specific image you search from Google

Advanced Discord.py Image Bot CREDITS Made by RLX and Mathiscool README by Milrato Installation Guide in .env Adjust the TOKEN python main.py to start

Comments
  • Bot doesn't respond on !configure

    Bot doesn't respond on !configure

    The bot linked in the "installation" section does not respond if provided with a valid spreadsheet ID in the "!configure" step. The reason might be an exception thrown when trying to create or edit a server file in the database - there's no further exception handling inside the FileNotFoundError catch block.

    (Also, it might be preferable to join the "serverdata" directory as an additional parameter instead of using a hard coded backslash for the file paths, to make the code more platform-independent.)

    opened by Tofuraven 2
  • Unable to authorize

    Unable to authorize

    When trying to add the both to a server, i get a red message in the dialog about it being unverified. Because of that im unable to add the bot to my server.

    The bot can't join more servers as it has not been verified or is requesting gateway intends it has not been verified for. Ask the bot's developer about https://dis.gd/bot-verification so you can add it to your server!

    opened by TriMoon 0
Releases(v1.0)
Owner
Dion Rigatos
Undergraduate @ AUEB I.T. Dept
Dion Rigatos
A discord bot written in discord.py to manage custom roles assigned to boosters of your server.

BBotty A discord bot written in discord.py to manage custom roles assigned to boosters of your server. v0.0.1-alpha released! This version is incomple

Oui002 1 Nov 27, 2021
A discord bot that utilizes Google's Rest API for Calendar, Drive, and Sheets

Bott This is a discord bot that utilizes Google's Rest API for Calendar, Drive, and Sheets. The bot first takes the sheet from the schedule manager in

null 1 Dec 4, 2021
This Server Cloner can clone the server you want with all the perms of roles in every particular channel.

Server-Cloner-with-perms ?? This Server Cloner can clone the server you want with all the perms of roles in every particular channel. Features Clone C

Gripz 0 Feb 17, 2022
It is a temporary project to study discord interactions. You can set permissions conveniently when you invite a particular disk code bot.

Permission Bot λ””μŠ€μ½”λ“œ 내에 μžˆλŠ” message-components λ₯Ό μ—°κ΅¬ν•˜κΈ° μœ„ν•˜μ—¬ μ œμž‘λœ λ΄‡μž…λ‹ˆλ‹€. Setup /config/config_example.ini νŒŒμΌμ„ /config/config.ini으둜 λ³€ν™˜ν•©λ‹ˆλ‹€. config 파일의 κΈ°λ³Έ 양식은 μ•„

gunyu1019 4 Mar 7, 2022
Autodrive is designed to make it as easy as possible to interact with the Google Drive and Sheets APIs via Python

Autodrive Autodrive is designed to make it as easy as possible to interact with the Google Drive and Sheets APIs via Python. It is especially designed

Chris Larabee 1 Oct 2, 2021
Google Sheets Python API

Google Spreadsheets Python API v4 Simple interface for working with Google Sheets. Features: Open a spreadsheet by title, key or url. Read, write, and

Anton Burnashev 6.2k Dec 30, 2022
Google Sheets Python API v4

pygsheets - Google Spreadsheets Python API v4 A simple, intuitive library for google sheets which gets your work done. Features: Open, create, delete

Nithin Murali 1.4k Jan 8, 2023
Fairstructure - Structure your data in a FAIR way using google sheets or TSVs

Fairstructure - Structure your data in a FAIR way using google sheets or TSVs. These are then converted to LinkML, and from there other formats

Linked data Modeling Language 23 Dec 1, 2022
A minimalistic, modern Discord bot for roles and polls using dropdowns

DropBot A minimalistic, modern Discord bot for roles and polls using dropdowns Made by ThatOneCalculator Technologies used Instructions Type /, and na

ModernBots 1 Jun 27, 2022
Discovery is an open-source Discord Bot with the main features Tickets, Moderation, Giveaways and Reaction roles.

Discovery is an open-source Discord Bot with the main features Tickets, Moderation, Giveaways and Reaction roles.

null 1 Dec 29, 2021