This was used for automated paring of PenPal initiative Website Link
- Download the google form response as
.csv
and updateresp.csv
Make sure you have feild heading as'roll', 'name', 'email'
- Run
validate.py
this will make a list of all rolls in resposne and update you about email mismatch and duplicate entries. - Then you'll see
regd.json
. - Now, Run
pair.py
. This will create an emaling list. of ramdomised pair - Use template
template.html
and email using mailmerge, with 5 second gap. - Run
mailinglist.py
to make list of all emails for further broadcast.
In case you face any isuue executing feel free to contact Me (Harshit Raj BT/BS Y20 Senator, Students' Senate).
Other Core Team member:
- Shreya Agarwal and Somya Gupta, BT/BS Y20 Senator, Students' Senate