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.