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

  • Profile Image
    Martin Luck
    Asked on August 30, 2022 at 03: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



    This is a re-post of a comment on How to Integrate Forms with Google Sheets

  • Profile Image
    Harvey
    Answered on August 30, 2022 at 06: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.