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.

1. Create a new Build Personalized Link column.
2. 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.
    

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.

1. Create a new Clickable text column.
2. 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.