Google Sheets and Analytics

  • Profile Image
    Lena Negrete
    Asked on March 20, 2020 at 01:38 PM

    Hello,


    I installed the Google Sheets widget. I did a test and the information submitted to the form seems to be just code. You can't read the actual words submitted. Please see attachment.

    Also, I am trying to install the Google Analytics widget. You have it in your features list. But on the backend in the form it's not listed in the widget options.

    Thanks!

  • Profile Image
    FelipeSantana
    Answered on March 20, 2020 at 02:10 PM

    Hello Lena,

    We do apologize for the inconvenience you are experiencing with your Google Sheets integration.

    After checking your form, I have found that you have the encryption feature turned on, which will encrypt all of your form data and will require a private key to decrypt. As you can see in the following screenshot of your form's advanced settings:

    1584727457Screenshot (30).png

    If you want to keep the form encrypted, you will need to access your private key in order to decrypt your submission data. Here are a couple of helpful user guides to assist you in using our form encryption feature:

    Encrypted-Forms-and-How-to-Use-Them

    https://www.jotform.com/blog/encrypted-forms/

    Please do get back to us if you have any further questions or concerns, we are always here to help!