This article will show you how to personalize links for each recipient in Google Sheets.
Prerequisites
- Use a Google sheet that contains data.
- Make sure to include a link in a column in each row.
Personalize the links for each recipient
If you want to send personalized links, we recommend using the ENCODEURL function. It will ensure the links work correctly.
- Create a new Build Personalized Link column.
- Create the personalized links for each row under the Build Personalized Link column:
-
- If you want to personalize the links using data from one cell, use the formula: =HYPERLINK("<URL>" & ENCODEURL(<cell>))
info You must keep the double quotes before and after the <URL> text part.In our example, we add the data from the Full Name column. In the first row, we use the formula: =HYPERLINK("https://yamm.com/" & ENCODEURL(C2)).
-
If you want to personalize the links using data from multiple cells, use the formula: =HYPERLINK("<URL>" & ENCODEURL(<cell>) & ENCODEURL(<cell>)).
In our example, we add the data from the Full Name, Product Code, and Zip Code columns. In the first row, we use the formula: =HYPERLINK("https://yamm.com/" & ENCODEURL(C2) & ENCODEURL(D2) & ENCODEURL(E2)).
Once the links are personalized for each recipient, you can send your mail merge with YAMM.
- If you want to personalize the links using data from one cell, use the formula: =HYPERLINK("<URL>" & ENCODEURL(<cell>))
Result
Each recipient receives an email with a personalized link.
Create clickable text
If you don’t want your links to appear as links but want to link text instead, you can create clickable text links.
- Create a new Clickable text column.
- Add the formula for each row: =HYPERLINK(<cell>, “<clickable text>”)
info You must keep the double quotes before and after the clickable text part.In our example, we use the Full Name column to create a clickable text for each link. In the first row, we use the formula: =HYPERLINK(G2), "Alice")
Result
Each recipient receives an email with a personalized link.