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?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.