I am in an organization with around 250 members with different roles. For this example we can use 4 rolls Roll A,B,C,D.
I have a google sheet that has the individual's name, email address, and role in the organization.
Every Tuesday and Thursday we send out announcements, sometimes up to 17 at a time, and often only A or B needs the information and sometimes only C or D need the information. Is there anything I could do that would automatically prioritize what the individual would need in the email?
I looked into using the YAMM extension with Gmail which looks nice cause you can see when they open the email, but would like a way to show those who need specific information first.
(also trying to find the best system to store this announcement for searching up later, so if you have any recommendations for that let me know)