To create a link on an email in Google Sheets, select the cell containing the email address and then click on the Insert menu. Then select the Link option. Alternatively, you can press the Ctrl + K key combination. Now in the text box area, type 'mailto:' and click on the Apply button.