My google sheet isn't updating when i've added a new question on my form.

  • tom shipley
    Asked on July 17, 2019 at 5:18 AM

    How do i update it without losing my data

  • Victoria_K
    Replied on July 17, 2019 at 6:47 AM

    From your question, I assume you have modified the integrated sheet and added your own calculations or data. Please note that we do not recommend to modify integrated spreadsheet or change its settings as this can cause the integration to fail. 

    Can you please re-integrate the form to google sheets? New integration should fetch all submissions fresh but you will get a totally new sheet file. 

    Here is related guide: How-to-Integrate-Forms-with-Google-Sheets

    If you need to apply some changes to integrated sheet, I can suggest to use IMPORTRANGE function to copy the data from integrated sheet to different sheet and apply changes to that sheet keeping original one untouched.

    Hope this helps.