Apps Script based tool designed to automate the recruitment process of a local school complex, handling user input from Google Forms, generating PDF files and sending them via email.
- Triggers automatically on a dedicated Google Form submission
- Processes user's responses and maps them to HTML Template
- Generates a personalized PDF file and stores it on Google Drive
- Instantly sends email confirmation with the PDF attached
- Google Apps Script
- JavaScript
- Google Forms API
- HTML/CSS
- Open the Apps Script editor for your form
- Copy the content of
Kod.jsand paste it to your AppsScript editor - Create a HTML file in Apps Script and paste the content of
wniosek.htmlthere - Adjust the questions in your code in order to make them match exactly the ones from your form
- Change "[email protected]" in line 93 to the mail you wish to receive a BCC to
- Add a trigger firing on submitting the form
The PDF template (wniosek.html) and mail content are both provided in Polish, as they were originally developed for a local institution.