I am using the Google Spreadsheet integration - if I add my own columns or sheets will jotform delete my added data?

  • Profile Image
    Asked on February 03, 2015 at 06:10 PM

    So, I used jotform Google Spreadsheet integration and connected to a sheet in my Google account. I tested the form and entered test data. I saw the data show up on the sheet. Very cool. Then I just wanted to add my own extra columns to the spreadsheet that I did not want on the form. It seemed as though it left it alone, but when I came back later, my extra columns were gone while the jotform field generated columns were still there.

    Can you confirm what jotform does - I mean if it will delete my custom data I put in the sheet, then I won't bother entering it. I don't know if it is something I did or something jotform did, but maybe you know the answer.


  • Profile Image
    Answered on February 03, 2015 at 07:45 PM

    Making any changes to Google spreadsheet and its headers will break the integration. This may result in loss of existing data in the spreadsheet and any new submissions cannot be updated into the  spreadsheet. You may need to remove the existing integration and re-integrate again in order to get it work again. We suggest not to make any changes to integrated spreadsheet especially with the column names. However, you may use Import Range function of Google Docs that imports the data of the integrated sheet to a separate spreadsheet for making any changes.

    Hope this information helps!