Automatic diplomas generation and sending

Generates named diplomas from a template and a GSheets table then sends it to the students. Requires GSheet and GMail API — or similar.

11.03.2021 @ France — @vdElyn

Get your Sheets API Credential JSON file from here
Get your Mail API Credential JSON file and enable the Gmail API from here
Complete config.yaml file with your Sheets and Gmail data and specifications
Edit message_text.html to edit your mail message
Run the python generate_diplomas.py file

Required modules

pyyaml to parse .yaml files
PIL for the image processing
Google Sheets API and gspread to deal with the Sheet
Google Mail API to send e-mails to students

$ pip install gspread pyyaml Pillow
$ pip install --upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib