Creating groups based on a category?

I have a set of data that contains first name, last name, timezone, and email address. I’d like to create automatic groups of 3 based on time zone (each participant needs to have the same timezone per group) and then somehow (hopefully in an automated manner!) communicate the peer groups with their first, last, email to each group. Anyone have any ideas for how this could be done with Airtable? Thanks in advance!

I can see this happening with a combination of a script in the Scripting app and a webhook-triggered automation. The script would do the heavy lifting of matching people and building groups. Once that’s done, it would call the webhook once per group to trigger the automation, which would send an email to the members of each group. For example, if there are 15 people, the script would build five groups of three, then call the webhook five times, each time sending data for a single group’s members to the automation to email those members.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.