I’m not sure whether Shortcuts or Scriptable (or both?) could handle going into a spreadsheet like I need for this task, so I didn’t drop it in either sub-forum.
I’m a teacher, and when I receive an email from a student, I like to follow my school’s guidelines of CC’ing their parents. This is fine on my Mac, because I just pop open the spreadsheet and grab their parents’ emails. On my iPhone, this task feels much more arduous. Is there a way to use Shortcuts, Scriptable, or any other tool to take the “from” email address, search for it in a spreadsheet, and grab the other associated items in that row?