Gmail

On this page you will find:

How to add multiple calendar attendees as recipients to a draft email

How to create dynamic greetings from calendar attendees in a Gmail draft

How to add multiple calendar attendees as recipients to a draft email

This guide explains how to automatically add all event attendees to the 'To' field of a Gmail draft in Make - while excluding a specific email such as yours or the clients.

Variations:
- This could apply to a 'Send an Email'' Gmail Module

After your Google Calendar Module, you will need to add:

Step 1:

Add a new module → Flow Control → Iterator

Set Array to:

Attendees[] (Map from Google Cal module)

This loops through each attendee individually.

Step 2:

Add a new module → Tools → Text aggregator

Select show advanced settings

Set Source Module to:
Iterator (Select from drop down)

Set Row separator to:
Other

Set Separator to:
,
Please note the above is a comma and then a space

Set text to:
Email (Map from Iterator previous step)

Step 3:

Add a filter between modules from Step 1 and 2 to exclude a specific attendee(s)

Label: Remove unwanted email (this is just a name for the filter)

Configure the filter:

Condition: Email (map from the Iterator output)

Text Operators: Not equal to

Bottom field: admin@cewh.org (Type the email address)

Skip this step if there are no email addresses you wish to not include. To add another email address, repeat this filter by selecting 'add AND rule''

Step 4:

Setting up the 'to' field in the gmail draft.

Turn Map on
Click in the 'To' field and search for 'Split'. Click and drag this to the 'to' field.
Search text from the text aggregator module and click and drag and place between ( ;

How to create dynamic greetings from calendar attendees in a Gmail draft

This guide explains how to automatically create a greeting in a Gmail draft based on the first names of Google Calendar attendees.

The greeting will automatically format as:

Hi Briar, (one person)
Hi Briar and Ashley, (two people)
Hi all, (three or more people)

Variations:

This could apply to a 'send email' Module
You can switch out any of the greetings to Hello/Good morning etc
Instead of Google Contacts, you could pull names from a CRM, Spreadsheet or similar

Important: Google Contacts Requirement

For this workflow to function correctly, attendees must be saved in Google Contacts. The scenario uses the attendee email address to look up the contact in Google Contacts and retrieve the first name.

If a contact is not saved, the automation cannot reliably extract a name.

For example, email addresses like:

accounts@company.com
bluwhale784@gmail.com
bookings@organisation.org

do not reliably contain a usable name.

Because of this, I do not recommend trying to produce a name from the email address itself. If attendees are not saved in Google Contacts, it is better practice to keep the greeting general, such as:

Kia ora / Kia ora kōrua / Kia ora kotou
Hi there,
Hello,

Important: If a Google Contact contains multiple email addresses and more than one of those addresses appears in the meeting invite, the automation may return the same name twice. This happens because the scenario looks up the contact for each attendee email individually. To avoid duplicate names appearing in the greeting, it is best practice to ensure contacts only have one active email address saved where possible, or be aware that duplicates may occur in these cases. The email address must be saved as the primary/main email.

Step 1

Add a new module → Flow Control → Iterator

Map Array to:

Attendees[ ] (map from the Google Calendar module)

This loops through each attendee individually.

Step 2

Add a new module → Google Contacts → Search Contacts

Connect your Google Account

Set Query Search to:

Email (map from the Iterator)

Set Limit to max amount of attendees

This searches Google Contacts to find the contact associated with the attendee email address.

Step 3

Add a new module → Tools → Text Aggregator

Select Show advanced settings

Set Source Module to:

Iterator (from Step 1)

Set Row separator to:

Other

Set Separator to:

(comma followed by a space)

Set Text to:

Given Name (map from the Google Contacts module)

This combines all first names into one string such as:

Briar
Briar, Ashley
Briar, Ashley, Michelle

Step 4

Add the greeting to the Gmail Draft module.

In the Body text field, add the greeting formula:

Hi {{if(length(trim(ifempty(11.text; ""))) = 0; "all"; if(contains(replace(trim(11.text); ", "; ","); ","); if(length(split(replace(trim(11.text); ", "; ","); ",")) = 2; join(split(replace(trim(11.text); ", "; ","); ","); " and "); "all"); trim(11.text)))}},

Make sure it maps like the image example.

This will automatically produce:

Hi Briar,
Hi Briar and Ashley,
Hi all,

Google Sites

Report abuse