Is there a way to integrate JotForm with an existing Google Sheet

  • Profile Image
    sarahblutonic
    Asked on August 12, 2016 at 12:47 PM

    I am trying to re-integrate my form to a Google Sheet that the form was initially integrated with, but when I try to integrate, my only option is to create a new spreadsheet.

     

    Is there a way to integrate the form to the original Google Sheet that was created when I first integrated the form?

  • Profile Image
    Charlie
    Answered on August 12, 2016 at 02:22 PM

    Unfortunately, it is not possible to associate an existing spreadsheet to your form in our Google Spreadsheet integration. Once an integration is done, it will create a new spreadsheet and automatically loads all the submission data on the new spreadsheet.

    This also applies if you re-integrate, if you remove the integration and re-integrate, it will create the new spreadsheet. The old spreadsheet will remain in your Google Drive but it will no longer update.

    I strongly suggest that if you want to make any customization on the spreadsheet, I suggest create a separate spreadsheet then use the integrated spreadsheet only as a reference (like a master spreadsheet). You can simply import the data from the master spreadsheet to your own spreadsheet by following this guide: https://support.google.com/docs/answer/3093340?hl=en. So any data received by the master spreadsheet will also be displayed on your own custom spreadsheet.

    I hope that this helps.