How to integrate an encrypted form with Google Spreadsheet?

  • Profile Image
    dgrote
    Asked on April 22, 2016 at 06:27 PM

    If I choose to encrypt form data and to integrate a form with Google Sheets, the data is not visible to me in GS.  I chose the option of encryption because of highly sensitive information in the form.  Am I correct in enabling encryption?  Is there a trick to getting the Google Sheet to open with the form data visible rather than garbled?

    Thank you,

    Dan

  • Profile Image
    Kevin_G
    Answered on April 22, 2016 at 08:11 PM

    I do not think that this could be possible to do, if you would like to have your submitted data available on your spreadsheet then you will need to disable encryption in your form. 

    **Do note that the already encrypted data will be still encrypted, only new received data will be shown normally. 

    Also, let me tell you that our forms are secure, so all of our links load over a secure URL (HTTPS) it means that they are being transferred using this security protocol even when you are using our integrations.

    If you are afraid of the data being saved in JotForm then you may disable encryption and delete  your submissions as soon as they come, as you have already your form integrated with Google Spreadsheet you will not loose any data. 

    Here is the app that will help you to delete submissions as soon as they are received: http://apps.jotform.com/app/auto_delete_submissions

    So you will have your data saved only in your spreadsheet.