Can i change google sheet colum header without breaking the integration?

  • Martin Luck
    Asked on August 30, 2022 at 3:48 PM

    Hello, Can I change the Google Sheets column header titles once the integration of my jotform has taken place. For example the Name on GS has shown as Label 1 or similar?
    I's rather it were called Name? Thanks

  • Harvey JotForm Support
    Replied on August 30, 2022 at 6:02 PM

    Hi Martin,

    Thanks for reaching out to Jotform Support. Unfortunately, you cannot change the headers on the google sheet without having to change them on Jotform. The column header name in the integrated Google spreadsheet is based on the field's label name. Changing the header on the spreadsheet without changing the form field's label name will cause the integration to break.

    A possible workaround I can suggest would be to create another Google Spreadsheet with your preferred headings. Then use the ImportRange function to copy the data from the integrated google sheet into the google sheet that you created. You can follow this guide on How To Import Data From Other Google Spreadsheets.

    Give it a try and let us know how it goes.