Google Spreadsheet integration breaks when editing the data

  • Profile Image
    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
    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 —

    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.