How do i extract email from different bundles and send them a email?

Hi,

I just learned how to filter my Airtable and extract the values i am after. In my case i just got 7 different results, all of these results contain a unique email aswell. Look at screenshot below:

My ideal goal is to send a email to each of these emails we just found in the list, can somebody please help me achieve this?

I would like to get all of these emails and put them inside here:

blueprint (6).json (58.2 KB)

You can use the built-in function map to pick a key out of an array of collections.

e.g.:

{{ map(14.array; "Epost") }}

If you need further assistance, please provide the following:

Please provide the input and output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.
Screenshot_2023-10-06_141025

A.

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

Uploading them here will look like this:

module-1-input-bundle.txt (12.3 KB)
module-1-output-bundle.txt (12.3 KB)

B.

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles in this manner:

  • Either add three backticks ``` before and after the code, like this:

    ```
    input/output bundle content goes here
    ```

  • Or use the format code button in the editor:
    Screenshot_2023-10-02_191027

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

For more information on map, see

samliewrequest private consultation

Join the Make unofficial Discord server!

1 Like

Dear @samliew thank you for assisting me today, really!

Attached is the files
output-bundles.txt (1.8 KB)
input-bundles.txt (1.5 KB)

In your array aggregator module,

Can you select the Target Structure Type field to select the email module Recipients field?

We are trying to do this:

The Array Aggregator module also allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.

Here is an example of using the “Target structure type” of an Array Aggregator module:

As you can see, the “Map” toggle on fields are used when you have an array. You can easily build an array variable to map to a field, by using an Array Aggregator module and select the “Target Structure Type” as the future field you want to map the array into.

Once you have this, you should be able to map each email address (and name) in the aggregator fields.

1 Like

Dear Sam,

I dont see email module Recipients field inside the target structure type field.

@samliew i tried this:

“{{ map(14.array; “Epost”) }}” but no luck.

Not sure how to process here…

Hi again Sam,

I ran the {{map(14.array; “Epost”)}} inside a text aggregator. And yes i got all the emails like “mail1,mail2,mail3,mail4,mail5” etc… And then i tired to put them inside the Mailjet with (split) formula.

image

Still cant get this work, tried like 3 hours now

Sorry, I don’t use Mailjet, and the two methods you’ve tried should have worked for Gmail.

Could you try one more thing and report what the input and output bundle looks like?

Unmap recipients field, and manually add two email addresses, and run just that module.

1 Like

Hi @Tobias_Hansen

Did you try putting the emails in mailjet without splitting??

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel

2 Likes