Hi. I’m in charge of a mentorship program at a university and I am look to automate the pairing of students with alumni (currently in Google Sheets) based on keywords. Once paired, I would like an email (gmail) to be sent notifying the paired people. Does anyone know how I could set up something this up?
Page 1 / 1
Hi
Good question.
You’ll need to further define the pairing logic involved and provide specific examples in order for us to have enough context.
Questions to consider:
- Are the keywords exactly the same?
- What happens if there are multiple keywords?
- What happens if there are multiple matches based on keywords? (first, last, all, most recently modified, oldest modified, etc.)
- What happens if there are no matches based on keywords?
- Can students be matched to more than 1 alumni?
- Can alumni be matched to more than 1 student?
- Can matches be unmatched?
Ultimately, you may be better served using a relational database app such as Airtable instead of GSheets.
Records can be linked: https://support.airtable.com/docs/linking-records-in-airtable
Airtable has internal automations that might be useful: https://support.airtable.com/docs/automations-overview
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.