Secret Santa Bot

This bot matches people for a Secret Santa by taking their infos from a Google Sheet (which you can create through a form) and DMing them automatically on Discord.

Sheet format

Column B (starting at B2) should contain participants' usernames and discriminants (xyzxyz#1234)

Column C (starting at C2) should contain their address

Column D (starting at D2) should contain an (optional) message from giftees to their Santa

How to use it?

1-Install dependencies pip install -r requirements.txt.

2-Create a project on Google Cloud.

3-Go to "API and Services", then browse the library and add the Google Sheet API.

4-Add a service account, and generate a json key for that account. Put that json in the same file as the script.

5-Copy the sheet's id into the code (the link should look like docs.google.com/spreadsheets/d/xxxxxxxxxxxxxxxxxxxxxxxxxxxx/edit[...], just copy the part in bold). Make sure you give at least read access to people with the link to your sheet.

6-Go to the Discord Developer Portal and create a new application.

7-Configure all the variables in a configuration file (cp config.py.sample config.py and edit this config.py file).

8-Invite the bot to a server with all the participants.

9-Run the bot with python main.py