title: PDF Automation with Typeform and GoogleSpreadsheet
body: <p>I need some help about the best way to do a small automation project.</p>
  
  <p>I have created a form using Typeform. At the end of the form, the answers are automatically send to a Google Spreadsheet using Zapier. Now, I want to generate a PDF and send it to the user each time there is a new entry in my form. I was thinking to use Google Script (JavaScript) to do so.</p>
  
  <p>The tricky part is that my form is dynamic: if the user answers A to question 1, he will jump to question 2. Else, he will directly jump to question 3 and never see question 2. So, I will have empty rows in my answer’s spreadsheet and won’t be able to just copy/paste the answers. So I am wondering: are Google Spreadsheet and Google Script the best way to generate a pdf based on answers submitted to a form? Is there another better technology to do it?</p>
  
  <p>Thank you for your advices,</p>
  
  <p>Romain</p>