Back to Solutions
Mail Merge

How to Mail Merge with PDF Attachments in Google Sheets

Smart Certificates performs a mail merge that converts Google Slides into PDFs, then attaches each unique PDF to an email sent to the recipient listed in your Google Sheet.

Want to see timestamps or seek to sections? Watch on Video Portal

How to Send Mail Merge PDF Attachments from Google Sheets

  1. 1 Design your email attachment as a Google Slide with dynamic {{tags}}.
  2. 2 Open Smart Certificates and select your email column and template.
  3. 3 Click 'Generate and Send' to deliver the mail merge with attachments.

Mail Merge PDF FAQ

Does it use my Gmail?

Yes, it sends emails directly through your Google Workspace/Gmail account.

Can I cc or bcc others?

Yes, you can specify CC and BCC columns in the advanced settings.

Is there a daily limit?

The limit depends on your Google account type (Gmail vs. Workspace).