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.
1.2. Personalize the raw URLs by adding the real product name (optional)
Instead of displaying the bare URLs to your recipients in your emails, you can add the product name on each link so that they look cleaner.
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 in the Text field and click Apply.
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
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 send your personalized links to your recipients!
Here's what they will receive in their inbox.
Comments
8 comments
Small nuance, Make sure not to lock the column as the link does not work if locked.
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 !
Hello everyone !
Clement, did you find any solution to your problem ? Same here - impossible to track "custom" links ... :/
Thx
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
NOTE: the YAMM didn't work if you need to use a formula to create a link.
I wanted to do: =HYPERLINK(CONCATENATE("https://theconversation.com/profiles/",A4,"/newsletters?utm_source=TCUS&utm_medium=email&utm_campaign=author-yamm"),"Your newsletter page")
To make it work, I created a separate cell with the formula in B4 =CONCATENATE("https://theconversation.com/profiles/",A4,"/newsletters?utm_source=TCUS&utm_medium=email&utm_campaign=author-yamm")
And then I did =HYPERLINK(B4,"Your newsletter page")
Delphine Leroy I am trying to use this feature to NOT have YAMM wrap my URLS in a tracking link. I want to track email opens, but don't want to change the URLs in the email. Is that possible?
BTW I am also finding that using the hyperlink formula is actually not working in YAMM. In the email, I just get the cleaned text, unlinked
Hi Joel,
Thank you for adding that information. It's true that you shouldn't have nested formulas under the =HYPERLINK() formula. You will need to have a separate column.
Many thanks,
Omiros - YAMM support team
Hi Neil Patel,
I'm afraid that YAMM needs to wrap the URLs.
As for the issue you are experiencing with the formula not working, could you please reach out to us by heading at the bottom of our website, click on contact us and submit a request there?
Many thanks,
Omiros - YAMM support team
Please sign in to leave a comment.