Mail Rocket Docs
Home PageInstall Mail Rocket
  • Home
  • Getting Started
    • Install Mail Rocket
    • Mail Rocket Tutorial
    • Advanced features
      • Email tracking
      • Personalized email templates
      • Preview emails
      • Unsubscribe Link
      • File Attachments
      • Insert Images
      • Add Cc, Bcc and Reply-To
      • Add multiple recipients
      • Personalized link
      • Personalized attachments
      • Filter recipients
      • Max emails per day
      • Delay between emails
      • Schedule campaign
    • Email quota
    • Sending guidelines
  • Help Center
    • FAQs
      • Account & subscription
    • Troubleshoot issues
      • Template mismatch
    • Contact
Powered by GitBook
On this page
  • Use the =HYPERLINK Formula in Google Sheets
  • Adding Personalized Links to Your Email Template

Was this helpful?

  1. Getting Started
  2. Advanced features

Personalized link

PreviousAdd multiple recipientsNextPersonalized attachments

Last updated 1 year ago

Was this helpful?

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")

Replace "https://example.com" with your desired URL and "Visit Example Website" with the text you want to display for the hyperlink.

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.