Certificate-Generator

This application will automatically create & mail the certificates using the Certificate image and the recipients details in an Excel sheet

Getting Started

Prerequisites

You need to have Python installed on your PC. If you do not have you can install from here

Installation

1. Clone the repo

   git clone https://github.com/githubcrce/Certificate-Generator.git

2. Install the Requirements

   pip install -r requirements.txt

3. Create a credentials.json file

   {
    "email" : "YOUR EMAILID",
    "password" : "YOUR EMAILID PASSWORD",
    "smtp_server" : "smtp.gmail.com",
    "smtp_port" : 587,
    "email_subject" : "YOUR EMAILID SUBJECT",
    "email_body" : "YOUR EMAILID BODY",
    "students_sheet" : "students.xls",
    "picture_certificate_template" : "sample-template.png",
    "path_to_folder": "",
    "path_to_font":"YOUR FONT ttf file"
   }

4. Run the Certificate Generator

   python certificate_generator.py