What happened to google sheets legacy?

  • Kirk Kleinpeter
    Asked on January 11, 2023 at 7:10 PM

    What happened to google sheets legacy?
    It has always worked great for the past few years and now all of a sudden it is not transferring over.
    Thanks

    Page URL: https://www.jotform.com/help/228-how-to-integrate-forms-with-google-sheets/
  • Mafe_M JotForm Support
    Replied on January 12, 2023 at 4:13 AM

    Hello,

    Thank you for reaching out to Jotform Support. I am sorry this is happening. Rest assured, I am here to help. When you say issue with transferring over to the spreadsheet, are there submissions that do not sync to your Google Sheet? If yes,  kindly remove the integration and re-integrate again to Google Sheet. Please note that once you remove Google Legacy it will no longer be available and you will need to use the new Google Sheet integrate once you reintegrate your form again. Here is how to remove the integration:

    • In the Form Builder, click Settings
    • Go to the Integrations tab on the left side of the page
    • Click Google Sheets (Legacy)

    1673513779 63bfcb3341ba8 Screenshot 10

    • Click Remove Integration

    1673513824 63bfcb60795dc Screenshot 21

    Since you have removed the integration you will reintegrate the form to the new Google Sheets. Here is how to do it:

    • In the Form Builder, click Settings
    • Go to Integration tab on the left side of the page
    • Search and select the Google Sheets integration.

    1673514133 63bfcc95721d0 Screenshot 32

    • Click Authenticate and connect your Google account.

    1673514359 63bfcd7749485 Screenshot 43

    Please keep in mind that editing the spreadsheet that is integrated into the form can break the integration and we do not recommend it. Also, editing of the form, such as adding the new fields or editing of the field labels will break the integration.

    See this list of the features of the improved version of the Google Sheets integration and what it allows you to do:

    • Create a new spreadsheet or select an existing one.
    • Select questions to send to the spreadsheet.
    • Once authenticated with your Google account, you can select a connected account to create integration.
    • You can select to send the existing submissions or not.
    • The integration will continue working properly if the header columns moved to another column.
    • If all questions are selected to send to the spreadsheet, new fields on the form will be added to the spreadsheet.

    Let us know if you need more help.