Email each document

Send every generated file to the address in a column, with the PDF attached.

Setup

  1. Make sure the sheet has a column with email addresses, for example Email.
  2. In the sidebar, tick Email each document.
  3. In To, use the column as a placeholder: {{Email}}.
  4. Write the subject and message. Placeholders work here too, and {{__file}} inserts the file name.
Subject: Your {{Course}} certificate
Message:
Hi {{Name}},

Congratulations on completing {{Course}} on {{Completed on}}. Your certificate is attached.
  1. Click Test with first row to send one, then Create documents for the rest.

What is sent

Limits

Each email counts towards Google’s daily sending limit (about 100 on free Gmail, 1,500 on Google Workspace). The number left today is shown under Activity. If a row has no valid address, that row is logged as an error and skipped; fix the cell and run again.

Email per document is a Pro feature.