How to send emails to multiple email addresses in the BCCs using Gmail?

Questions
, ,
6

If you need a comma-separated string, that’s easier.

As you are aggregating a bundle, your array currently looks like this:

[
  { "2": "LALA@ff.com" }
]

You need a map function to extract the value from the column “2” from each collection in the array, before you can join them.

You can use the built-in functions map and get to access variables within an array.

To do this, you can use the built-in function map —

{{ map(complex array; key; [key for filtering]; [possible values for filtering separated by a comma]) }}

and the built-in function get (or first) —

{{ get(object or array; path) }}

so you get something that looks like this —

{{ first(map(1.array; "value")) }}
{{ first(map(1.array; "value"; "name"; "content-type")) }}

You can also combine map and join to combine the variables within an array into a single text string —

{{ join(array; delimiter) }}

e.g.:

{{ join(map(9.array; "2"); ",") }}

(copy-paste the above into the field, or type it exactly as shown)

For more information, the function’s documentation can be found in the Help Centre and the “Mapping with Arrays” link below. You should also complete the tutorials in the Make Academy, especially Using get() and map() functions.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

— @samliew