Add different links / URL for each recipient

*** A new version of this article is available on this page ***

Using =HYPERLINK() formula or Google Sheets toolbar button

You can use the =HYPERLINK() function, or simply click on the toolbar button to insert a link in your spreadsheet. We will automatically convert it to an HTML anchor so that your recipients get a clickable link.

Insert a link with your spreadsheet toolbar button:

Insert a link with the =HYPERLINK() formula:

The result in your Gmail box:

Learn more: https://support.google.com/docs/answer/44660?hl=en