Google Sheets - Emailing a Copy of a Sheet

About

Is some instances, end users may wish to email a copy of a Google sheet rather than sharing  the sheet.  Examples include:

1. Sending a pdf version to prevent editing
2. Sending an Excel version for non Google Sheets users
3. Sending a .csv version for data export purposes.

The easiest method is to install the Google sheets add-on Email Spreadsheet which automates much of the process.

 Get the Add-on

1. Open any Google sheet
2. Click the menu item Add-ons
   
   
   
    
3. Click Get Add-ons
   
   
   
    
4. The Google Add-ons window will open.
    
5. Enter "email google sheet" in the search box and hit enter.
   
   
   
    
6. From the list of add-ons, locate  Email Spreadsheet.  Click the Free button.
   
   
   
    
7. On the Request for Permission screen, scroll down and click Allow. 
   
   
   
    
8. The add-on will be installed into Google Sheets.

 Emailing the Copy of the Google Sheet

1. Open Google Drive
2. Navigate to and open the desired Google sheet.
3. Fill the Google sheet with the desired data.
4. Click the menu item Add-ons.
   
   
   
   
5. Click Email Spreadsheet from the drop down list, then click Create New Rule.
   
   
   
   
6. The Email Spreadsheet sidebar will open.  Click the Continue button at the bottom of the window.
   
   
   
   
7. Compete the Email Spreadsheet specs sidebar by settings the following fields
   1. Accept the setting as is
   2. Use Microsoft Excel as the file format
   3. Advanced options:  check Include the Document Title and Include Sheet Names
   4. Always bgregory@knox.edu
   5. Always Custodial Supply Order
   6. Always Excel reports are attached.
   7. Click Send Now to email the sheet.
      
      
      
      
      
   8. Once sent, a copy of the message will be stored in your sent mail.