My google sheets integration just stops updating randomly

  • Polljosh
    Asked on July 19, 2017 at 1:48 PM

    Yesterday around 4 pm MST my sheet stopped updating with submission data. I have had this happen a few times now and it is very frustrating to have to go pull the data from the site to manually update it to get it working again. I did update the manual update today and it still isn't pulling my data. We can't just keep creating new sheets every time this happens. What do you suggest on what is happening? 

  • Welvin Support Team Lead
    Replied on July 19, 2017 at 3:37 PM

    I have manually synced the missing submissions into the spreadsheet file. You should see them now. I suspect it's the number of submissions in the form that's causing the delay. If the issue persists, let us know here, and we will be more than happy to create a ticket about it to our developers. 

  • Polljosh
    Replied on July 19, 2017 at 4:02 PM

    When did you manually sync the missing submissions? It started updating then it stopped again but it was probably because I downloaded the file and updated the file myself again. This may have messed up what you did. Can you do what you did again and then we will see what happens? 

     

    Thanks

  • Welvin Support Team Lead
    Replied on July 19, 2017 at 4:15 PM

    That was 30 minutes ago before I posted my first reply for you. The sync tool will scan the missing submissions and add them manually to the sheet. Your modifications or changes to the existing data in the spreadsheet won't be affected. Again, only the missing ones will be queued. This won't break the integration. 

  • Polljosh
    Replied on July 19, 2017 at 4:26 PM

    Ok. The data on the site is working fine it just isn't pulling any new data to my integrated sheet.  Is this something you can have the developers look into or am I stuck nonintegrating and then integrating a new sheet? 

  • jonathan
    Replied on July 19, 2017 at 4:46 PM

    I have updated you on your other thread about the issue of not pulling new data here https://www.jotform.com/answers/1203220

    Please reply on that thread instead about this issue.