How to Integrate Forms with Google Sheets

  • cbibleway
    Asked on September 22, 2019 at 4:12 AM

    When I first integrated my form to google sheets the registration payment amount was on it. But now the registration payment amount is not noted on the google sheet. What happened and how do I correct it?

  • Victoria_K
    Replied on September 22, 2019 at 4:21 AM

    Hello,

    May I ask if the integrated sheet was changed? Please note that we do not recommend to modify integrated spreadsheet or change its settings as this can cause the integration to fail. 

    I see on your form there are attached files. Can you please re-integrate the form to google sheets? New integration should fetch all submissions fresh. 

    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 to different sheet and apply changes to that sheet keeping original one untouched.

  • cbibleway
    Replied on September 22, 2019 at 8:50 AM

    Do I remove the integration and reintegrate?

  • Victoria_K
    Replied on September 22, 2019 at 8:51 AM

    Yes, please remove existing integration and set up new one. New integration would fetch all existing submissions freshly.