zetaMerge is a Google Docs/Google Sheets add-on for the quick and easy creation of beautiful, dynamically generated reports and documents, merging data from several sources into a template. The documents created can be exported to different formats and automatically sent by email.
Get it from the Google Workspace Marketplace.