How to Integrate Forms with Google Sheets

  • Profile Image
    cbibleway
    Asked on September 22, 2019 at 04: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?



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

  • Profile Image
    Victoria_K
    Answered on September 22, 2019 at 04: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.

  • Profile Image
    cbibleway
    Answered on September 22, 2019 at 08:50 AM

    Do I remove the integration and reintegrate?

  • Profile Image
    Victoria_K
    Answered on September 22, 2019 at 08:51 AM

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