Replace {{First name}} with a personalized first name in a message

How To
1

:us: Hello,

I have a Google Sheet with a list of people and template messages to send depending on their journey on WhatsApp. I use Wbiztool.

I want to modify → “Hello {{FirstName}} :seedling: First week of your follow-up. How did you experience these first few days?” This is one message, but there are several others, all different, always with the same variable {{FirstName}}. I want to replace {{FirstName}} with the actual first name from one of the columns in the sheet. I can’t manage to do it — I tried with Tools and an iterator replace, but it doesn’t work. Can you help me? My problem seems so simple.

Thank you,

Bonjour,

J’ai un googlesheet avec une liste de personne et des messages type à envoyer selon leur parcours sur whatapps. J’utilise Wbiztool.

Je souhaite modifier –>” Bonjour {{Prénom}}:seedling: Première semaine de votre suivi. Comment avez-vous vécu ces premiers jours ?” c’est un message mais il y en a plusieurs tous différents avec toujours la même variable {{Prénom}}. Je souhaite remplacer le {{Prénom}} par le vrai prénom associé dans l’une de mes colonnes du sheet en question. Je n’y arrive pas, j’ai essayé avec Tools et un iterator replace mais ca ne marche pas. Pouvez-vous m’aider ? mon problème à l’air si simple.

Merci à vous,

3

Hi and welcome to the Community!

This is a really good question. Yes, you can most definitely do this!

The app you’re looking for goes by the unusual name of Mustache. It’s so named because the {{field}} syntax is known as “mustache templating”, as the {{ looks a little like a sideways mustache.

You can read all about it in the help here!

4

:us_outlying_islands: Hello, I just tried using Mustache. However, I have lots of standard messages in a sheet. I don’t have a single template. I have to use wbiztool to send the message on WhatsApp, and it will retrieve the message. So, to summarize, I have a source sheet module and a wbiztool module where it will retrieve the message from the corresponding sheet and then send it to the people on a list in a different sheet of the same document. Unfortunately, Mustache does not work for me.

Bonjour, je viens d’essayer avec mustache. cependant j’ai plein de messages types dans un sheet. Je n’ai pas une template unique. Je dois passer par wbiztool pour envoyer le message sur whatsapp et il va chercher le message donc pour résumer j’ai un module sheet source et un module wbiztool ou il va chercher le message dans le sheet qui correspond et ensuite il va l’envoyer aux personnes qui sont dans une liste dans le une feuille différente du même document. Mustache ne fonctionne pas pour mon cas malheureusement

image
image1616×336 35.4 KB

image
image623×652 34.2 KB

5

Welcome to the Make community!

You should be able to use a simple built-in function “replace” in the Message field.

For further assistance with your scenario, please provide the following:

2. Scenario Blueprint

Please export the scenario blueprint. Providing your scenario blueprint file 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 greatly benefit you in implementing our suggestions as you can simply paste module exports back into your scenario editor!

To export your scenario blueprint, click the three dots at the bottom of the editor then choose ‘Export Blueprint’.

3. Module Output Bundles

Please provide the output bundles of each of the relevant modules by running the scenario (you can also get this without re-running your scenario from the History tab).

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

490×338 23.5 KB

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

B. Insert as Formatted Code Block

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

To provide code/text using Markdown format, you can type a code fence.
Add three backticks ``` in a separate line before and after the content, like this,

```
text goes here
```

Alternatively, you can upload your file and share the public link** —
(this method is only recommended for large files exceeding the forum upload limit)

Providing the input/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) or if external services are involved, and help you with mapping the raw property names from collections.

Sharing these details will make it easier for others to assist you.

6

Hello, ok If i followed right i give you 2 paths that I tried. with differents module
3 mois- Message whatsapp de suivi hebdomadaire client.blueprint.json (45.7 KB)
bundle.tkt - mustache and tools.txt (2.2 KB)
bundle.tkt - text parser.txt (1.9 KB)
I hope you can help me :slight_smile: