> For the complete documentation index, see [llms.txt](https://docs.mailrocket.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.mailrocket.io/getting-started/advanced-features/personalized-link.md).
# 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 %}
### **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**
* 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.