Building the emailEach gradebook row's SIS Login ID plus the domain becomes that student's email. A login that already contains @ is used as-is.
Header rowsHeader rows are found by looking for Preferred Email and SIS Login ID — no renaming of sheets or tabs needed.
DuplicatesRepeat registrations from the same address collapse to one person; the registration count is kept.