Hi. I run a golf date matching service for single golfers to play the Old Course in St Andrews.
A golfer can register up to 5 date requests to play. I then try to match them with other golfers looking at the same date. If there is a match I email them with details of their match and their fellow golfer details. A max of 4 golfers can be matched to play together and so each email would be sent to up 4 recipients.
As there are up to 5 dates on which they can match, and a max of 4 players per date there would a maximum of 5 emails generated (1 per matched date) each addressed to a maximum of 4 recipients. The minimum would be 1 email generated to a minimum of 2 people (ie. only 1 date found a match and it was with just one other person).
The match information is automatically generated in google sheets. I would like Zapier to use my match data and generate these 1-5 emails for me (or at least create a draft of them for me so I can check before sending).
I can create the underlying google sheet data in a variety of ways depending on how best / simplest to tackle this. For now I have provided this example of one option. I would be very happy to receive any advice if there would be a better underlying spreadsheet layout to work from.
Attached is the current match information I have in my spreadsheet. The field headings for the 7 information columns I would like to use in my email are marked in dark grey. In the example here I would like to generate 4 emails (as per the color coding).
Email 1 would be addressed to person1/2/ & 3@email1.com.
Email 2 would be addressed to person1 & 2 email2.com
Email 3 would be addressed to person1 & 2 email3.com
Email 4 would be addressed to person1 & 2 email4.com
I have also attached an example of the email I would like to send to the golfers who have a date match.
I am a new user of Zapier, killing to give anything a go if pointed in the right direction. I’m not a developer, but happy to learn! I am on the starter plan (up to 20 zaps) Many thanks.