Google spreadsheet to pdf / email script

Current flow A Typeform is connected to a Google Sheet. Every time the form is filled, the results are sent automatically to the spreadsheet. Requirement We need a script that automatically generates a pdf file (using a template we will provide) every time the Google Sheet receives a new result. The file will then be sent as an attachment to an email address pulled from the same sheet. Sender Specific email address Specific “From” name Recipient Email address pulled from the result Subject line with merge tags, so we can add some custom content Body is static File sent as PDF attachment The exact content of the PDF file and its merge tags is still being defined.