Create a PDF using Google Docs template, populate the template from sheets data and send out the PDF via mailApp. In this …
source
Unlock the Secrets of PDF Generation with Google Apps Script
Headlines