1. Home
  2. Google Sheets
  3. Campaigns
  4. Customizing a campaign

Personalized links

Mailmeteor lets you customize both the text of the hyperlink and the URL it directs to. This way, you can send your campaign with personalized links to each recipient.

Once you have created your hyperlinks in Google Sheets, you can insert the link right into your email template. Let’s see how to do it:

  1. Create your mailing list in Google Sheets. Then add a new column and name it link.
  2. Open Mailmeteor in Google Sheets.
  3. Create a new template. Or edit an existing one.
  4. In the toolbar, click Insert variable and select the variable link. This variable will only appear if you have a column named link in your spreadsheet.
Insert the link variable
  1. Use the preview mode to check that everything looks correct.

Google Sheets lets you add hyperlinks to your spreadsheets using the =HYPERLINK formula.

To use the =HYPERLINK function in Google Sheets:

  1. Create a column for your links. Name it link, for example.
  2. Enter the formula: =HYPERLINK("https://mailmeteor.com","Mailmeteor").
  3. Make sure to replace the URL and the text with your own values.

Hyperlink function example