App Icon
Email Google Sheets, charts and dashboards on a recurring schedule in PDF, CSV or Excel format. Send individual sheets, entire workbook or email a specific range of cells and charts.
Listing updated:September 23, 2022
Works with:
977,573
Overview
With Email Spreadsheets add-on for Google Sheets, you can schedule and automatically send spreadsheets as PDF, Excel (xlsx) or CSV files to your clients and customers. You can email the entire spreadsheet, dashboards, charts, specific sheets of the workbook, a fixed range inside any sheet (like A4:E25) or even a single cell (like B9).

If your work requires you to manually pull the same information from certain spreadsheets and email it to colleagues every day (or week or month or year), the Spreadsheet mailer add-on will do it all for you, automatically. It converts the Google Sheet and sends the exported file as an email attachment.

You can also embed one or more dynamic charts from Google Sheets into the email body and they'll be sent as inline PNG images.

The add-on is completely secure and private. No part of your spreadsheet data is read, shared or uploaded anywhere. And because it works in the Google Cloud, your scheduled spreadsheets reports will be delivered even if you are offline or on vacation.

The add-on is developed by Amit Agarwal, Google Developer Expert and Google Cloud Champion for Google Workspace.

👉🏻 Here are some use cases:

1. Email PDF reports for requirements to your vendors daily around 6 PM.
2. Submit expense reports to your boss on the last weekday of the month.
3. Send your weekly timesheets as CSV files automatically on Friday evening.
4. Email the executive summary dashboard on the first day of the month to the management.
5. Email the weekly sales report to your sales manager every Monday around noon.
6. Schedule and send clients reports in Excel format for AdWords, Search Console, CRM or Google Analytics for decision making.

The subject and the body of the email message can be customized to include dynamic cell values from one or more sheets using the A1 notation. For instance, if you wish to include the value of Cell A5 of Sheet 1 in the subject, add {{Sheet 1!A5}} into the subject line.

The exported PDF files can be further customised per report. You can show gridlines, change print margins to fit more content on one page, change paper size, show page numbers, show sheet names and more.

Dynamic cell values can be added in the TO, CC and BCC fields of the message as well. If you wish to specify multiple email recipients in the email field, remember to separate them with a comma. Google email quota limits apply and it is recommended that you keep the recipient count below 10 per email.

🚀 Here are some examples of specifying the print area using A1 notation:

1. {{Sheet1!A1:B2}} inserts the first two cells in the top two rows of Sheet1.
2. {{Sheet1!A:A}} refers to all the cells in the first column of Sheet1.
3. {{Sheet1!1:2}} refers to the all the cells in the first two rows of Sheet1.
4. {{Sheet1!A5:A}} refers to all the cells of the first column of Sheet 1, from row 5 onward.
5. {{Charts:Sheet1!2}} inserts the second charts on sheet named "Sheet 1" into the email body.

The Sheet Ranges are inserted inline into the email body and all the cell formatting, column widths, number formatting, colours and embedded images are retained. This option is useful if you wish to email a portion of the sheet with recipients without sharing the entire sheet.

The Sheet Name should always match the name as in your Google Spreadsheet. Also, always surround the sheet name and range with double curly braces.

You can use HTML tags to format your email body. For instance, use the <img> tag to include your company’s logo in the email. Or use the <a> tag to include hyperlinks (URLs). The h1 and h2 tags can be used for adding headings.

Email Spreadsheet is free for basic usage. You can email sheets and ranges to your email address manually.

The add-on comes with a 7-day unlimited use trial (no credit card is required).

✅ The following features are unlocked after you purchase a license.

1. Setup unlimited email reports for any spreadsheet.
2. Schedule daily, hourly, weekly, monthly or yearly reports on a recurring schedule.
3. Specify multiple recipients in the TO, CC or BCC fields.
4. No add-on branding is included in emails.
5. Complimentary tech support.
6. Merge all sheets in a single PDF file for exporting
7. Access to advanced options like show gridlines, page numbers, etc.
8. Export specific range of cells in the PDF file
9. Embed charts from Google Spreadsheets in the email body.
10. Use HTML tags like a, br, h1, etc. to format your email body.
11. Pull dynamic set of email addresses from cells for emailing.

Go to https://digitalinspiration.com/buy?sku=GA11 to upgrade to premium.

If you have any questions or feedback, please email us at support@digitalinspiration.com
Additional information
PricingPaid with a free trial
Developer
Privacy policy
Terms of service
Email Spreadsheets will ask for the permissions shown below. Learn more
Email Spreadsheets will need access to your Google account
This will allow Email Spreadsheets to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of Email Spreadsheets
October 3, 2019
Add on works well. When sending a small table embedded in email body It does not support cell border formating (ie only uses cell standard gridlines) so table is lacking that aspect of formatting. Would be useful if it would resolve named ranges eg {{sheetname!rangename}} like {{sheetname!A1:B4}} in text body as there are advantages to using named ranges for readability.
Is this review helpful?
Yes
No
Profile Picture
Ilya Kerig
July 26, 2021
I bought a paid version. Turns out there's a limit to how many emails this add-on allows you to send. I don't know how many, but 70 was too much for it. I had asked support many times to clarify but got no response. I've requested a refund, still no response. Amit Agarwal, please respond.
Is this review helpful?
Yes
No
Profile Picture
Avani Mistry
June 27, 2022
In the description it says it is free for the basic usage. I was using the free version and now it is asking me to buy a license. We use email spreadsheet for max 10 emails a day. How do I keep using a free version for the basic usage?
Is this review helpful?
Yes
No
Profile Picture
Julie Bowes
February 12, 2021
I cannot seem to get a response from the support team. I am looking into the upgrade and need to now how many emails per day I can send with the standard upgrade.
Is this review helpful?
Yes
No
Profile Picture
Santosh Nilkanthe
October 7, 2020
Very useful add on
Is this review helpful?
Yes
No
Profile Picture
Andriy Bandriy
October 22, 2020
Useful app easy to use
Is this review helpful?
Yes
No
Profile Picture
Fitaba
September 9, 2020
Very useful add on but as for me the select range is not working for me when I preview it it show only the select area but when I send the email it doesn’t it only send the full pdf file
Is this review helpful?
Yes
No
Profile Picture
pc prince
July 19, 2020
Superb addon, automates almost everything related to Google sheets.
Is this review helpful?
Yes
No
Profile Picture
A User of Email Spreadsheets
May 31, 2020
Email not being sent at scheduled time .....only works when we click send email......... scheduler not working
Is this review helpful?
Yes
No
Profile Picture
A User of Email Spreadsheets
February 24, 2020
Very good add-on. How can I use customize fonts other than Times New Roman? for Example: Arial Narrow or PT Sans Narrow is better to make a narrower column?
Is this review helpful?
Yes
No
1-10 of 78
Search
Clear search
Close search
Google apps
Main menu