App Icon
Digital Inspiration
•  
343,064
Overview
Email Google Sheets and dashboards on a recurring schedule in PDF, CSV or Excel format. Send individual sheets, or the entire workbook or embed a specific range of cells inside the email body and send automatically.
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, dashboard, specific sheets of the workbook, a specific range inside any sheet or even a single cell.

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 Email Google Sheets add-on will do it all for you, automatically. It converts the Google Sheet and sends the exported file as an email attachment.

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.

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.

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.

The Premium Advantage:

Email Spreadsheet is free for basic usage but if you upgrade to premium, all features are unlocked.

1. Setup unlimited email reports for any spreadsheet.
2. Schedule  weekly, monthly or yearly reports on a recurring schedule.
3. Specify recipients in 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 portion of sheets in the PDF file

Go to https://digitalinspiration.com/buy to upgrade to premium.

Your 5-day trial is automatically activated when you install the addon and all the premium features are available during trial.

If you have any questions or feedback, email the developer at amit@labnol.org or tweet us at https://twitter.com/labnol. Our other popular Google add-ons include Document Studio and Mail Merge with Attachments.
Reviews
Language:
Sort by:
Profile Picture
Natesan V
April 22, 2021
Working good!!!. Im using this for daily report and the data will be dynamic on daily basis. how can i provide range for this scenario. anyone please help out on this.
Is this review helpful?
Yes
No
Profile Pciture
Sonabh Bubna
May 30, 2021
I am also facing the same issue
Profile Picture
Jennifer Cunningham
April 13, 2021
Was working really great! In the last 2 weeks it's arriving much later than the set time. I know it says within 30 minutes, but it's a lot late. :(
Is this review helpful?
Yes
No
Profile Picture
Kevin Swindle
April 3, 2021
is not emailing and doesn't tell am or pm when scheduling
Is this review helpful?
Yes
No
Profile Picture
ILYAS KHAN
March 12, 2021
best
Is this review helpful?
Yes
No
Profile Picture
Jatinder Singh
March 12, 2021
Great one
Is this review helpful?
Yes
No
Profile Picture
Michal Hadi
March 1, 2021
Great but goes to spam....
Is this review helpful?
Yes
No
Profile Picture
Harsh Mathur
February 25, 2021
love this feature
Is this review helpful?
Yes
No
Profile Picture
Carlos Hdez.
February 17, 2021
Please add the option to send the emails from an alternative account, like you do in your other soft, not only from gmail.
Is this review helpful?
Yes
No
Profile Pciture
Artur Veliu
February 18, 2021
I will love to see that option too
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 Pciture
Max Bradley
April 1, 2021
I'm having the same issue. I'm happy to consider a paid subscription but I need to know that the problem I'm having (only 1 email being sent per day) is a result of being on the free version and not some other bug. It's odd this is not made apparent on any website.
Profile Picture
Alpha fireservices
February 9, 2021
good
Is this review helpful?
Yes
No
1-10 of 63
Additional information
Digital Inspiration
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu