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.
Reviews of Email Range - Google Sheets add-on platform_app