Google Spreadsheet integration breaks when editing the data in the spreadsheet

  • Profile Image
    mjjmk
    Asked on February 17, 2018 at 06:56 AM

    After editing the spreadsheet (just changing the name for a column) it no longer updates with new submissions. Is there a way I can change column names/delete specific response data without it dying?



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

  • Profile Image
    Mike_G
    Answered on February 17, 2018 at 08:21 AM

    We would like to apologize for any inconvenience. We do not encourage editing the Google Spreadsheet integrated with the form because it tends to break the integration. A workaround that you can do is to import the data from the original sheet into another sheet using IMPORTRANGE — https://support.google.com/docs/answer/3093340?hl=

    Then, you can already alter the imported data in the new sheet.

    If you have other questions, please do not hesitate to let us know.