Dynamically add an email to Brevo based on a product

[TheDailyPackers]

What is your goal?

I want that at the end of my shop automation, the client’s email is added a Brevo’s list based on the type of product that has been purchased.

What is the problem?

There are 2 problems:

1. I don’t know how to create that dynamically, so that the Brevo module add the email to the right list
2. If the email is already in the list, it create an error. So, a customer rebuying a product wouldn’t be added to the list

What have you tried so far?

I tried to create a manual solution where a router goes to various Brevo connections (1 for each product), but that isn’t scalable for the future.

Screenshots: scenario setup, module configuration, errors

[samliew]

Welcome to the Make community!

How are these modules set up, and how are they different from each other?

We’d love to help, however, we require more information that demonstrates the problem to help us reproduce the scenario and any issues and errors.

To allow others to assist you, please provide the following:

1. All Relevant Screenshots

We need to see what you’re working with to give you the best advice. Screenshots are important because Make is a visual editor — a picture provides us with more context.

It would help us identify the issue by having screenshots of:

• relevant module fields (showing how you’ve used any built-in functions, and how you’ve mapped the variables),
• relevant filters between modules (showing which operators and any built-in functions you’ve used, and how you’ve mapped the variables),
• relevant module input/output bubbles,
• if applicable, any error messages,
• and if applicable, any external services (spreadsheet headers/ sample data/ regex101.com/ etc. to show the item/ record exists, and is set up correctly).

Need help❓View instructions ◀

We would appreciate it if you could directly upload screenshots here instead of linking to them outside of this forum. This allows us to zoom in on the image when clicked, and also having improved privacy from third-party sources.

Taking Screenshots

• Microsoft Windows: Take screenshots using the “Windows Snipping Tool”, by pressing either PrtSc or WinShiftS keys on your keyboard.
• MacOS: Take screenshots by pressing CommandShift4 keys on your keyboard.

Uploading Attachments

• Drag image files directly into the rich-text editor, or
• Click on the upload button in the editor toolbar to select files:
  

2. Scenario Blueprint

Providing your scenario will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return. This would benefit you in implementing our suggestions as you can view screenshots of the changes or paste corrected modules back into your scenario.

Need help❓View instructions ◀

A. Export Blueprint

In the scenario editor, click the three dots at the top-right, then select “Export blueprint”.

• You can upload files and images to this forum by clicking on the upload button:
  

  Uploading an attachment here will look like this:
  blueprint.json (12.3 KB)

B. Create Public Share Link

In the scenario editor, click on the Share button:

Read more about the scenario sharing feature in the Help Centre.

3. Module Output Bundles

Please provide the output bundles (input bundles are not so crucial) of each of the relevant modules by running the scenario, or get output bundles from a previous scenario run from the “History” tab.

Providing the output bundles will allow others to replicate what is going on in the scenario, especially if there are complex data structures (nested arrays and collections), especially if external services are involved, and help you with mapping the raw property names from collections.

Need help❓View instructions ◀

Click on the white speech bubbles on the top-right of each module and select “Download output bundles”.

A. Upload a Text File

Save each bundle contents in a plain text editor as a bundle.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.

• You can upload files and images to this forum by clicking on the upload button:
  

  Uploading an attachment here will look like this:
  output-bundle.txt (12.3 KB)

B. Insert a Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly.

_{Formatting IS Important!}

Here are some ways to provide text content in a way that it won’t be modified by the forum.

• Method 1: Type code fence manually —
  Manually type three backticks ``` in a separate line before and after the content, like this,

  ```
  text goes here
  ```
  

• Method 2: Highlight the pasted content, then click the preformatted text/code button —
  

• Method 3: Upload your file elsewhere and share the public link —
  This method is only advised for large files exceeding the forum upload limit.

Sharing these details will make it easier for others to assist you, so that you can get better answers, faster.

Hope this helps! If you are still having trouble, please provide more details.

— @samliew
_{P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!}

[TheDailyPackers]

Thank you for your answer, and sorry for not being more precise right away.

All those modules are filtered by the product that a client can purchase in order to have them added to the correct Brevo list.

I added a bunch of screenshots of the complete automation and the details of the Brevo steps. And made a copy of the automation public ( Shop automation - Main (copy) - Make.com Automation Scenario )

The complete automation is made to give access to my client to my product (Google Maps hosted on Google Drive). And at the end, I want to add them to Brevo list based on what they purchased to start an emailing automation on Brevo.

[samliew]

@TheDailyPackers

It appears that you can simply use a Switch module, switch function, or chain multiple inline if functions.

Then, you will end up with just one variable that you can map into the “List” field.

For more information, see

• switch — General functions
• Switch module — Tools

Example

Here is an example of how your scenario could look like:

This is just an example. Your final solution may or may not look like this depending on your requirements and actual data.

Hope this helps! If you are still having trouble, please provide more details.

— @samliew

[TheDailyPackers]

Awesome, thank you very much

I found my way around it, and the automation now works.

[samliew]

No problem, glad I could help with "Dynamically add an email to Brevo based on a product"!

1. Which was the most helpful post in this thread?

The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep this forum organised.

This marks the topic as solved, so that others can:

• save time when browsing the latest activity on the forum, and
• quickly jump to the solution in this topic

To do this, simply click the checkbox at the bottom of the post that is the most helpful in answering your question.

Here’s a magic link to a list of your other “unsolved” topics: status:unsolved

2. Have you learnt something new?

Do bookmark this topic so you can easily find and return to this topic in future.

Here’s a magic link to a list of your bookmarks /my/activity/bookmarks

3. Have a different/follow-up question? Start a new topic.

Creating a new topic for each question makes it easier for others with the same problem to search for answers. You are also more likely to receive help sooner as new topics are displayed first on the forum’s “new” page!

Hope this helps! If you are still having trouble, please start a new thread.

— @samliew