How to email a Google Sheet as a PDF automatically
By Jake Marsh · Updated
To email a Google Sheet as a PDF automatically, open Extensions, Scheduled Sheet Reports, Open reports, click New report, pick the tab or range under What to send, tick PDF under Send as, add the recipients, set When (for example every Monday around 8 AM) and click Save and schedule. The PDF is made from the sheet's current values each time, so it always has the latest numbers.
Steps
- Open the spreadsheet and start the add-on from the Extensions menu.
- Click New report and name it, such as "Weekly sales PDF".
- Choose What to send. A whole sheet (tab) sends one tab. A range of cells sends part of one, like
A1:H40; select it and click Use selection. Every visible sheet puts all visible tabs in the PDF. - Tick PDF under Send as, then choose Portrait or Landscape and Letter or A4. Leave Fit to page width on for wide tables, and Gridlines on or off to taste. Tick Include charts from the sheet to add the tab's charts.
- Add the recipients in To, with Cc and Bcc if needed. Tick the box that confirms they expect the report.
- Write the subject, for example
Sales for the week of {{date}}: {{Summary!B2}}. Tokens like{{date}},{{weekday}}and{{month}}fill in when it's sent, and a cell reference fills in that cell's value. - Set When. Pick Daily with the days and an hour, Every few hours between two hours, or Monthly on a day number or Last day.
- Click Preview to check the message and recipient list, Send test to me to see the PDF in your own inbox, then Save and schedule.
Schedules that fit common reports
| Report | When |
|---|---|
| Weekly sales every Monday morning | Daily, Monday only, around 8 AM |
| Daily stock sheet on workdays | Daily, Monday to Friday, around 7 AM |
| Month-end summary | Monthly, Last day, around 5 PM |
| Twice-a-day status during work hours | Every 4 hours, from 8 AM to 4 PM, on workdays |
Times are in the spreadsheet's own time zone, which you can check under File, Settings. Reports go out during the hour you set.
PDF plus a table in the body
Many people read reports on their phone without opening attachments. Tick Table in the email as well as PDF: the email shows the first 300 rows and 30 columns as a formatted table with the sheet's colors and bold, and the PDF carries the whole thing for printing or filing. Add Excel if someone will want to work with the numbers.
How the PDF looks
The add-on draws the PDF itself from the sheet's displayed values, colors and fonts, so it doesn't use the print settings in Google Sheets, such as custom headers, footers or page breaks. If those matter, test-send one first and adjust the range, orientation and paper size until it reads well.
What it costs
Scheduled Sheet Reports is $6.99 a month or $59 a year per Google account. Free trial: 20 scheduled sends or 14 days, whichever comes first. No card needed. Every plan and the install link are on the Scheduled Sheet Reports page.
Scheduled Sheet Reports
Email a range or a whole sheet on a schedule, with a stop button that always works $6.99 a month or $59 a year per Google account.
Questions
Does the spreadsheet have to be open?
No. Reports run on Google's servers on the schedule, from the account of the person who created them.
Can I send the PDF to people outside my company?
Yes, to any email address. Each send counts toward your Google account's daily recipient limit.
Can I stop the PDF after a project ends?
Yes. Under Stop automatically, set After this many sends or After this date. To stop it right away, click Pause next to the report, or choose Stop all reports in this spreadsheet from the menu.
What is the PDF called?
The report's name followed by the date it was sent, so each week's file is easy to tell apart.
More Scheduled Sheet Reports guides
- How to email each person only their rows from a Google Sheet
- How to send an email when a Google Sheets cell crosses a limit