Guide · Google Sheets
How to send a Google Sheet as a PDF
Open the sheet, choose File → Email → Email this file, pick PDF, add the recipients and click Send. That is all it takes to send it once. If you send the same sheet every week, a free script or an add-on can do it for you, even when the file is closed.
Updated 17 November 2026 · 5 min read
Send a Google Sheet as a PDF once
This is built into Google Sheets and works on any Google account.
- 1
Open the File menu
In your Google Sheet, choose File → Email → Email this file.
- 2
Pick PDF
Choose PDF as the format. You can leave the box ticked to send yourself a copy.
- 3
Add recipients and send
Type the email addresses, a subject and a short message, and click Send. The PDF goes out from your Gmail as an attachment.
Email this file always sends the whole spreadsheet, every tab. To send a single tab or a range, choose File → Download → PDF instead, set Export to the current sheet or the selected cells, save the file and attach it to an email yourself.
Send it every week for free: Apps Script and a trigger
Google Sheets has no setting that sends the file on a schedule. A short script and a time trigger do it instead. The script turns one tab into a PDF and emails it from your Gmail. The trigger runs it every week.
- 1
Paste the script
In your sheet, choose Extensions → Apps Script, delete what is there and paste the script below. Put your recipients and the name of the tab you want to send in the first two lines.
- 2
Run it once
Click Run and allow the access Google asks for. You should get the PDF in your inbox within a minute.
- 3
Add a time trigger
Click the clock icon (Triggers) on the left, then Add Trigger. Choose sendSheetAsPdf, Time-driven, Week timer, Every Monday, 8am to 9am, and save.
function sendSheetAsPdf() {
const RECIPIENTS = '[email protected], [email protected]';
const TAB_NAME = 'Report';
const ss = SpreadsheetApp.getActiveSpreadsheet();
const sheet = ss.getSheetByName(TAB_NAME);
const url = 'https://docs.google.com/spreadsheets/d/' + ss.getId() +
'/export?format=pdf&gid=' + sheet.getSheetId() +
'&portrait=true&fitw=true&gridlines=false';
const pdf = UrlFetchApp.fetch(url, {
headers: { Authorization: 'Bearer ' + ScriptApp.getOAuthToken() }
}).getBlob().setName(TAB_NAME + '.pdf');
GmailApp.sendEmail(RECIPIENTS, TAB_NAME + ' – ' + new Date().toDateString(),
'The latest version is attached as a PDF.', { attachments: [pdf] });
}The settings at the end of the address control the layout: portrait=false gives landscape, fitw=true fits the width to one page, and gridlines=false hides the grey lines.
Where the script falls short
The script is fine for one weekly report to a few people. It gets harder when the report matters:
- The time is not exact. A trigger set for 8am to 9am runs at a random moment inside that hour.
- Errors are silent. If a tab is renamed, the script fails and the only sign is a failure email from Google that is easy to miss.
- One script per report. A daily sales PDF to the team and a monthly one to the accountant means two copies to keep up to date.
- No history. You cannot see what was sent, when, and to whom.
- Broad access. The script asks to read your Gmail and send email as you, and to see all your spreadsheets.
The no-code way: Scheduled PDF Reports
Scheduled PDF Reports for Google Sheets is our add-on, and it does the same job without code. Open it from Extensions, pick the tab, a range or the whole sheet, choose the day and time in your own time zone and add the recipients. It sends on time whether the file is open or not, keeps a history of every report, and can put a figure from your sheet in the email text, so people see the number without opening the PDF.
One weekly or monthly report to up to 3 people is free, with no card. Pro is €5 a month for up to 25 reports, daily and hourly schedules, and Excel and CSV files.
Questions
Can you send a Google Sheet as a PDF?
Yes. Open the sheet and choose File → Email → Email this file, pick PDF as the format, add the recipients and click Send. It takes less than a minute and needs nothing extra.
How do I send only one tab or a range as a PDF?
Select the range or open the tab, choose File → Download → PDF and set Export to the current sheet or the selected cells. Save the file and attach it to an email. The Email this file option always sends the whole spreadsheet.
Can Google Sheets email a PDF automatically on a schedule?
Not on its own. Google Sheets has no setting that sends the file every day or week. You can do it for free with a short Apps Script and a time trigger, as shown on this page, or with an add-on that sets it up without code.
Does the scheduled email still go out when the spreadsheet is closed?
Yes. Both an Apps Script time trigger and the Scheduled PDF Reports add-on run on Google's servers, so the email is sent whether the file is open or not and whether your computer is on or off.
Why did my trigger send the email at 8:40 and not 8:00?
A time-driven Apps Script trigger runs at a random moment inside the hour you pick. If the email has to land at an exact time, an add-on with its own scheduler is the better choice.
Is there a limit to how many emails a script can send?
Yes. Google caps how many recipients a script can email per day, and the cap is lower on a free Gmail account than on a paid Google Workspace account. A weekly report to a few people is far below it.
What is the easiest way to email a Google Sheet as a PDF every week?
An add-on. Scheduled PDF Reports for Google Sheets lets you pick the tab or range, the day and time in your own time zone and the recipients, and then it runs by itself. One weekly or monthly report is free. Pro is €5 a month for up to 25 reports, daily and hourly schedules, and Excel and CSV files.
Written by AddonNordic ApS, Aalborg, Denmark (CVR 46495985), maker of Scheduled PDF Reports for Google Sheets. Also see how to mail merge from Google Sheets to PDF. Google Sheets™, Gmail™ and Google Apps Script™ are trademarks of Google LLC; this guide is not made or endorsed by Google.