A Typeform is connected to a Google Sheet. Every time the form is filled, the results are sent automatically to the spreadsheet.
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.
Specific email address
Specific “From” name
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.