Create an automation for adding event attendees to matrix rooms

Summary

In order to address issue #15 (closed) in a more permanent/automatic/sustainable way (for future release parties or other fedora events) the creation of a matrix bot, similar to zodbot as used by fedora for meetings, was suggested.

Background

Most of the specific ideas so far were introduced in the comments of #15 (closed) under the label of "Phase 2".

Essentially "phase 1" consists of manually exporting data from pretix.eu (the event ticketing platform used for this release party). The process looks something like this:

1. manually exporting order position data from pretix.eu in either csv or xlsx format
2. look through the sheet and sort the matrix ids manually into valid and invalid groups (i.e. those that are complete with username and domain and those that are not). Using google docs to collaborate between people and a VLOOKUP formula to help allow new people signing up last minute to be incorporated into the signup sheet without missing or double-processing anyone.
3. for users with complete matrix ids, they are bulk-invited to the event channel them using a fedora admin account
4. for users with incomplete matrix id's they were sent an email using the data from the spreadsheet to ask them for their matrix ID

This is a very manual process and could likely be automated fairly easily by patterning off of existing resources both in the previous issue and other resources used within fedora (like existing matrix bots). Flowcharts to sketch out ideas are also present in that issue.

Details/Outcome

ideal outcome: a less manual process for online events hosted through matrix that can be applied to future events