Now you can easily create a snapshot of a portion of your spreadsheet to share via Gmail, directly from Google Sheets.
The Email Range add-on makes it easy to create a snapshot of a portion of your spreadsheet to share via Gmail, directly from Google Sheets.
Formats in your sheet are retained: Cell dimensions, colours, fonts, number and date formats, plus conditional formatting are faithfully preserved to display properly in common email clients.
You have the option to provide a custom message to introduce your embedded table to email recipients. Markdown is supported for rich formatting of your message.
If you want the raw HTML of a portion of your spreadsheet, click the Get HTML button.