Email each document
Send every generated file to the address in a column, with the PDF attached.
Setup
- Make sure the sheet has a column with email addresses, for example Email.
- In the sidebar, tick Email each document.
- In To, use the column as a placeholder:
{{Email}}. - 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.
- Click Test with first row to send one, then Create documents for the rest.
What is sent
- The PDF is attached when the output includes a PDF.
- A link to the file is always added at the end of the message.
- Emails are sent from your Google account, so replies come back to you.
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.