Google Sheets Integration

  • catherinehale
    Asked on April 8, 2019 at 6:49 AM

    I am looking to use Jotforms and I want to be able to export the data most likely into Google sheets as this seems the most sensible option from the Aps/integrations that you offer.


    But before I enter all the data for the form into Jot forms I want to know what format it will appear in Google sheets and whether its going to be in a workable format for me.

    What I don't want is to have to spend considerable time editing each form as I export it over.

    This is a sample of the form that my teacher is using: https://form.jotform.com/82768968684180

    Would this appear in a easy to use way on Google sheets ? Can you advise please?

    Thank you

  • recepkutuk
    Replied on April 8, 2019 at 8:04 AM

    Hello Catherine,

    I have prepared a demonstration based on your form settings.

    You can preview your form, fill and submit. After that, you can turn preview mode off and navigate to Settings tab at the top, select Integrations section at the left. There you will see Google Sheets integration box.

    1554724428g2 Screenshot 10


    When you select Google Sheets integration, you will be prompted to next screen, where you will be asked to authenticate your Google account and complete integration.

    1554724692g3 Screenshot 21

    When the integration is completed, you will be able to see your submissions in your Google Sheets.


    I have filled the sample form with some dummy data. It will look like this:
    1554722907o8KctIrrRv Screenshot 32