Google Sheets Integration

  • Profile Image
    catherinehale
    Asked on April 08, 2019 at 06: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

  • Profile Image
    recepkutuk
    Answered on April 08, 2019 at 08: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.jpg


    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.jpg

    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.gif