The Email Spreadsheet add-on can convert and email Google Spreadsheets as PDF, Microsoft Excel XLSX or CSV files to one or more email recipients. It can send entire spreadsheet, individual sheets or even a selected range of cells inside a sheet.

We've released a new and better version of the Email Spreadsheet add-on that replaces this addon. Please install the new addon from https://digitalinspiration.com/get/GA11

The version would be retired soon.