# Personalized link

Mail Rocket allows you to include personalized hyperlinks in your email campaigns, directing each recipient to a unique URL. Follow these steps to create and integrate personalized links seamlessly:

### **Use the =HYPERLINK Formula in Google Sheets**

Create or open your Google Sheets document containing your recipient list.

* Insert a new "**link**" column to your contact list
* Use the `=HYPERLINK` Formula
* For Example, `=HYPERLINK("https://example.com", "Visit Example Website")`

{% hint style="warning" %}
Replace `"https://example.com"` with your desired URL and `"Visit Example Website"` with the text you want to display for the hyperlink.
{% endhint %}

<figure><img src="https://2708547714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQ2Oq7wXz6MEOz8Y4u8DP%2Fuploads%2F8u68gdNFpudNwLGucoG8%2FScreenshot%202024-05-05%20at%201.20.53%20AM.png?alt=media&#x26;token=f0c375aa-4ed4-4feb-8785-5693f7865b63" alt=""><figcaption></figcaption></figure>

### **Adding Personalized Links to Your Email Template**

Open Mail Rocket and create a new email template or edit an existing template.

* Go to **extensions -> Mail Rocket: Mail Merge For Gmail -> Create Mail Merge**

<figure><img src="https://2708547714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQ2Oq7wXz6MEOz8Y4u8DP%2Fuploads%2FuCaeXwX4zYcFdvVuRncr%2FScreenshot%202024-04-28%20at%205.58.41%20PM.png?alt=media&#x26;token=745e0a5a-2a93-450a-982f-c6e31f18fc42" alt=""><figcaption></figcaption></figure>

* In the email template editor, click on "**Insert variable**" in the toolbar.
* Choose the "**Personalized links**" variable from the dropdown list. This variable will appear only if you have a corresponding "**link**" column in your spreadsheet.

<figure><img src="https://2708547714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQ2Oq7wXz6MEOz8Y4u8DP%2Fuploads%2FrbluYxgEtnfXODu9ey2T%2FScreenshot%202024-05-05%20at%201.22.12%20AM.png?alt=media&#x26;token=0f86d75c-8f5c-46ab-a8fe-ab97ec0f86f5" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2708547714-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FQ2Oq7wXz6MEOz8Y4u8DP%2Fuploads%2F2vPXeiHJuQcoKJBziCX7%2FScreenshot%202024-05-05%20at%201.23.18%20AM.png?alt=media&#x26;token=58763c4d-16fe-45e1-ab19-4dd64afccbea" alt=""><figcaption></figcaption></figure>
