Switch the PINs to email adresses in this example
Edited it slightly to better suit your needs
Create 2 columns in Airtable (email and group) add all email/group combinations.
Switch the PINs to email adresses in this example
Edited it slightly to better suit your needs