Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...

  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
  6. Click Create New Rule
  7. The Email Spreadsheet sidebar will open.  Click the continue button at the bottom of the window.
  8. 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
    .   The attachment file will be generated and emailed.  You may check your sent folder in GMail to confirm the file has been sent.
    1. to email the sheet.

      Image Added