In this article:

How to Link an Email in Google Sheets (Easiest Way 2024)

Click here to Send an Email From a Lido Spreadsheet

In this article we will show how to make an email link in google sheets in just a few simple steps using the HYPERLINK function. Simply follow the steps below:

Hyperlink an Email Address in Google Sheets

1. Set a Column for Hyperlink

For our example, we have the following sheet containing names and emails.

google sheets email link

The emails are stored under the email column header in B1, so the cells containing the emails are B2, B3, etc. We want to insert a link in Column C. We will add a column header called Contact User to cell C1. 

how do i make an email link in google sheets‍

2. Use =HYPERLINK(“mailto:”&cell, link_label)

To convert the email into a clickable link that lets you send an email to the user, use the HYPERLINK function. It converts a URL stored as a string into a hyperlink. For the emails, use the following syntax:

=HYPERLINK(“mailto:”&email_address, link_label)

Where email_address is the reference to the cell where the email is stored.

link_label is what the label of the link will be.

The  formula inserts mailto: at the front of the email address, and then converts it to a clickable URL. Next, it gives the URL a cover label which is what will be visible in Google Sheets as the clickable text. 

In our example the formula will add the anchor text “Email Name” to the hyperlink. The name beside the first email value in row 2 is Ann Aribaud so the anchor text for the hyperlink will be “Email Ann Aribaud”

=HYPERLINK(“mailto:”&B2, “Email ”&A2)

how to hyperlink an email address in google sheets

3. Press Enter

The hyperlink will appear in C2.

how to link an email in google sheets‍

If you hover your cursor over the link, you will see a pop-up message saying Send to mailto:emailaddress.

Hovering over the message itself will show a contact card containing the email address. If you have saved the email address as a contact, Google Sheets will detect that contact and show the name.

make a hyperlink to email someone in google sheets‍

Once you click the link, the default app you set for sending emails on your computer will be loaded with the email in the link set as the recipient.

4. Apply Formula to Entire Column

To convert all the email addresses to links in the column there are two methods you can follow: 

Click on the cell and double-click the round blue dot to autofill the column with the formula.

convert email into link google sheets

Click on the cell and Click-drag the round blue dot in the lower-right corner of the cell.

how to hyperlink an email address google sheets

Either way, the results will be the same:

Email address links added to google sheets


How do you Make the Link Display Only the First Name?

We simply need to modify the formula a bit:

=HYPERLINK("mailto:"&email_address, "Email "&LEFT(whole_name,FIND(" ",whole_name)-1))

Where email_address is the cell containing the email and whole_name is the reference to the cell containing the whole name.

This additionally inputs the whole name and outputs Email First Name as the label for the link.

Make sure that the cell containing the whole name does have the whole name with the First Name appearing first. The result can be seen below:

google sheets email link

Email link google sheets but displays only first name of recipient

How to Link an Email in Google Sheets

The easiest way to make an email link in google sheets is to simply right click on text in a cell, choose Link from the menu and enter Once you click enter the link will open your email client and compose a message to the linked email address. It's that simple!

If you enjoyed this article, check out some of our other articles:

Export Email from Google Sheets to Gmail

Google Sheets Email Validation

Send Email From Google Sheets [Easiest Method]

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Adds an object to Hubspot
Create a Slack channel, and optionally add a topic or members
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
Makes any HTTP request and returns the response
Inserts given array below defined values in given worksheet
Sends an email using your Google account
Sends an email using your Microsoft Outlook account
Sends a Slack message
Sends an SMS message using your Twilio account
Updates cells with given values
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started