Send different hyperlinks / URL to each recipient – Documentation - Yet Another Mail Merge Support

This article will show you how to add different and personalized links for each recipient of your spreadsheet.

1. Prepare your Google Sheets with the personalized links

In our example, we are sending purchase confirmations that contain the personalized links of the related product information pages.

1.1. List all raw URLs in a column of your Google Sheet

Open a spreadsheet, then add a new column header, for example 'Product link'.

List the whole URLs of each product information page under this column, as shown below:

warning Make sure to insert the whole URLs, and not only the variable inside them (like the product ID), otherwise the marker field will not work (see Section 2.1.)

1.2. Personalize the raw URLs by adding the real product name (optional)

Instead of displaying the raw URLs to your recipients in your emails, you can add the product name on each link so that they look cleaner.

Simply click on a link from your spreadsheet, then use the =HYPERLINK() formula or click the toolbar button to insert a link (learn more about hyperlinks):

Then add the product name on the 'Text' field:

Here's how all our URLs look like in the end in our spreadsheet:

If you have many links, you can also add the URLs and the product names under two separate columns, then use =HYPERLINK() formula to refer to those cells:

2. Send your campaign with personalized links to each recipient

2.1. Add a marker in your Gmail draft for the different links

info Learn more about personalizing your mail merge: 'Personalize your email content with markers'

In your Gmail draft, add the marker {{Product link}} that matches the same column header from your Google Sheets:

2.2. Send your mail merge using YAMM

Your spreadsheet and Gmail draft are now ready and you can now send your personalized links to your recipients!

Here's what they will receive in their inbox:

Comments

4 comments

Fperei2 January 17, 2019 18:00

Small nuance, Make sure not to lock the column as the link does not work if locked.

1

Comment actions Permalink
Clement Fradet Normand August 27, 2019 21:43

Bug report : Links generated this way are not tracked by YAMM, i mean YAMM doesn't generate the https://myapp-dot-yamm-track.appspot.com/... prefix for the link generated in google sheet.

Do you have a solution for that ? Thanks !

0

Comment actions Permalink
Florian LEGRIS January 22, 2020 11:42

Hello everyone !
Clement, did you find any solution to your problem ? Same here - impossible to track "custom" links ... :/
Thx

0

Comment actions Permalink
Delphine Leroy February 06, 2020 10:34

Hi Florian LEGRIS

If you still have this issue, can you please contact our support team at support@yet-another-mail-merge.com?

Feel free to send screenshots and more information about your issue, this will help them to investigate. Thank you

0

Comment actions Permalink