About
Is some instances, end users may wish to email a copy of a Google sheet rather than sharing the sheet. Examples include:
- Sending a pdf version to prevent editing
- Sending an Excel version for non Google Sheets users
- Sending a .csv version for data export purposes.
The easiest method is to install a Google sheets add-on which automates much of the process.
Get the Add-on
- Open any Google sheet
- Click the menu item Add-ons
- Click Get Add-on
- Enter "email google sheet" in the search box and hit enter
- From the list of add-ons, select Email Spreadsheet.
- Click the Free button.
- On the Request for Permission screen, scroll down and click Allow.
- The add-on will be installed into Google Sheets.
Emailing the Copy of the Google Sheet
- 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:
- 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.