Automatically display data from google forms spreadsheet in a user friendly document

Status: Closed
Prize: $40
Entries Received: 5
Winner: josuna

Winner

Contest Brief

I have this google form and it sends response data to a google spreadsheet like this https://docs.google.com/spreadsheets/d/1s6zdf4gMY0bLU-OKLkVBhJcaOCWomfwu68AVRENAqq4/edit?usp=sharing I have filled in some sample data.

What I want is for everytime a new response comes in a pdf or word document is generated with a summary with all the answers to questions. ANY QUESTION THAT is not answered should be left out of this document. The document should be compact but still clear to read and user friendly, it should be designed minimally.

e.g data:
name: Mark
occupation:
age : 23
e.g document
name: Mark
age: 23

Use the google API to do this