HomeAutomationsExport a sheet and send it as an email attachment in Google Sheets
Trigger: Sheet updatedAction: Export & email

Export a sheet and send it as an email attachment in Google Sheets

Send reports without lifting a finger. When the sheet is updated, Sheet Automation exports it to PDF and emails it as an attachment automatically.

Installs in 30 seconds · No credit card · Works inside Google Sheets

★★★★★ 4.9/5 · 500+ reviews · 300,000+ installs

What it does

This automation watches the sheet for changes. When a value is updated, it exports the sheet to a PDF and sends it as an email attachment to the recipients you choose. It’s perfect for recurring reports, invoices, or snapshots — no manual “File → Download → attach” steps.

How to set it up

  1. Install Sheet Automation from the Google Workspace Marketplace and open it from your sheet.
  2. Decide which sheet to export and who should receive it.
  3. Pick the “Export sheet and send as attachment” template, set the sheet, page size, and recipient.
  4. Save, then update a value to test — a PDF of the sheet arrives by email.

The ready-made template

Export sheet and send as attachment — Trigger: any value is updated → Action: export the sheet to PDF → Action: email it as an attachment. Edit it live below:

Loading preview…

How to use this template

The builder above is a live preview of this automation. To run it in your own spreadsheet:

  1. Click Add to Google Sheets to install Sheet Automation (free).
  2. Open it from your sheet: Extensions → Sheet Automation → Open.
  3. Open the Templates tab and choose “Export sheet and send as attachment”.
  4. Adjust the fields to match your data, then click Save.
  5. Trigger it once to confirm the automation runs.

FAQ

What format is the attachment?
The sheet is exported to PDF at the page size you choose (e.g. A4) and attached to the email.
Can I send to multiple people?
Yes. Add recipients in the email action, and customize the subject and body.
Can I run it on a schedule instead?
Yes. Swap the trigger to a scheduled one (e.g. daily) to send the report on a timer rather than on every edit.
Do I need Zapier or Make?
No. Sheet Automation runs inside Google Sheets, so there’s no third-party connector to pay for or maintain.

Related automations