...
The easiest method is to install a the Google sheets add-onEmail Spreadsheet which automates much of the process.
...
- Open Google Drive
- Navigate to and open the desired Google sheet.
- Fill the Google sheet with the desired data.
- Click the menu item Add-ons.
- Click Email Spreadsheet from the drop down list
- Click Create New Rule
- The Email Spreadsheet sidebar will open. Click the continue button at the bottom of the window.
- Compete the Email Spreadsheet specs sidebar by settings the following fields
- Accept the setting as is
- Use Microsoft Excel as the file format
- Advanced options: check Include the Document Title and Include Sheet Names
- Always bgregory@knox.edu
- Always Custodial Supply Order
- Always Excel reports are attached.
- Click Send Now
- to email the sheet.