Student Assessment
Teacher Scenario:
- The teacher needs to create a performance assessment for students
- The teacher wants to
- Save the assessment data into Google Sheet,
- Generate assessment as Google Doc and PDF
- Send the PDF to the student's Email with a custom message
How to automate this process with Fillable Document
Step 1: Prepare the Student Assessment template
The teacher first prepares an student assessment template in Google Document.
He/She can add dynamic fields in ${field} format

Step 2: Configure the Dynamic Fields
Open Fillable Document on the prepared Google Document Template
Dynamic fields found in the template will be automatically identified by Fillable Document
By default, the field types are text.
Configure different types (name,grade, mark etc) and other configuration as required.
For example we have configured "From date" with a field type date and time zone.
Step 3: Configure Settings
Go to settings tab and configure the destination folder and spreadsheet here
- Setup Destination spreadsheet to store the form submissions
- Setup Destination folder to store the generated documents and PDFs
- Setup Email Template
Step 4: Publish Document
- The teacher can make the Form available to all of the student by publishing the form
- Teacher will publish the template to his/her student by clicking Publish Form(4th option in tab).
- If you don't want to keep track of user activity (like user email) tick Anonymous before publishing
Step 5: Teacher submitting data in the Form.
Important Note: You need to be signed into Google Account to see the below form.
Step 6: Submitted Data stored in Google Sheet instantaneously.
To see the submitted records, business manager need to follow the steps below.
- Open "Fillable Document" add-on from the Google Document
- Click on "Open Form as Web App"
- Click on "Form Responses" icon on the toolbar
- Click on a record to select for generating document
5. Click on "Generate Document" to generate the merged document
Below is a sample generated document and screenshot for email delivery.
Teacher can generate multiple documents based on records needed. (have a look)
Teacher can send generated document as Email by clicking on "Send as Email"