Google spreadsheet integration is broken.

  • Profile Image
    rcandco
    Asked on March 06, 2018 at 09:55 AM

    Hello,


    I'm not sure what happened but one of our integrations is no longer working.  Nothing was changed on the back end, but the file itself just stopped pushing to Google Spreadsheets.  The Jotform is "LISTING: New Listing Questionnaire (completed by Agent)" and it says that it is still integrating to "https://docs.google.com/spreadsheets/d/1SHxJnOg145QhyzP8djvjsCvNFonOf_tdPd09MrtCq3Q/edit#gid=540338346", but it doesn't actually work.


    I need this fixed in the next hour for a meeting, so if I don't hear back soon I will simply turn off the integration, turn it back on for a new sheet, and then change all of my formulas that push the info to reports. That would be a bit of a project though.

  • Profile Image
    rcandco
    Answered on March 06, 2018 at 11:02 AM

    I had to reset the integration for my meeting, so it is working now.  Still might be worth letting you know that something seemed to go wrong.  It was working one moment and then the next the google spreadsheet stop integrating and said "File cannot be found" or something like that.


    Thanks though.

  • Profile Image
    Marvih
    Answered on March 06, 2018 at 11:18 AM

    Upon checking your Form's Revision history I can see that there are some modifications made on your form yesterday. And it might have broken the Google Spreadsheet integration.

    https://www.jotform.com/help/294-How-to-View-Form-Revision-History

    15203523651388.png


    Please also take note that modifying data manually on your Google Spreadsheet will break the integration and you need to remove the current integration and add it back again to create a new updated Spreadsheet.

    Glad that it is now working now after removing the integration and adding it back. That will be the most recommended solution if the integration stops working.

    If you didn't do any changes on the form and the integration stopped working then we can try pushing manually the submission data into your spreadsheet. This is possible to happen specially when Google do some updates on their end .

    Thank you,