Google Spreadsheet: Why new submissions are not showing in spreadsheet?

  • kayemac
    Asked on March 7, 2017 at 12:50 PM

    Hi guys! Why are the new submissions not showing in Google Sheets? I had to reintegrate the Google Sheets last time because of the same issue and now it's not working again. Please see screenshot: https://www.screencast.com/t/5qjeJtdnMUtq

    https://form.jotform.me/70517591808462

    Can you please check what's happening? Thanks!


    By the way, I had to try and post in this thread because every tome I try to post a new one, I always get a spam error.

  • Kiran Support Team Lead
    Replied on March 7, 2017 at 1:02 PM

    We are sorry for the inconvenience this may have caused. Could you let us know if you are making any changes to the integrated Google spreadsheet? Please be noted that any changes made to the spreadsheet will break the integration. I have now pushed the missing submissions to the spreadsheet. Please check and let us know if the new submissions are updated in the spreadsheet.

    If the issue still persists, please try reintegrating the spreadsheet and see if that helps. Also, please make sure that you are not making changes to the spreadsheet.

    Thank you! 

     

  • anaflores
    Replied on March 8, 2017 at 12:22 PM

    Hi it's me still but it seems the account showing up is different.

    I got this issue resolved by reintegrating the form and google sheets and not making any changes to the sheet itself.

     

    Now I have a different issue in one of the forms I created a while back (concerning this account that's showing up).

     

    Can you please help me delete this form or link showing up in google search? Should be about 6 listings down.  

     

    https://www.google.com/search?q=tyler+shearburn&client=safari&hl=en-us&biw=414&bih=696&prmd=inv&ei=jTe_WKjxM8HPjwTXxrX4DA&start=20&sa=N&dpr=3

     

    Not sure how to but I need to remove this asap.

     

    https://www.jotform.com/form-templates/20four7va-eod-report-ana-flores-for-tyler-shearburn

  • Kiran Support Team Lead
    Replied on March 8, 2017 at 12:43 PM

    Thank you for confirming that the Google spreadsheet integration is now working fine. The other question is moved to a separate thread and shall be addressed there shortly. Please follow the link below:

    https://www.jotform.com/answers/1084967

    Thank you! 

  • kayemac
    Replied on March 13, 2017 at 9:56 AM

    Hi. I noticed that my other forms aren't working properly too. New submissions aren't showing in Google sheets and I had to reintegrate this form twice. https://form.jotform.me/70254434414449

    Still it's not working. Some of the new submissions are not showing in Google sheets. Are you guys having issues with Google sheets integration right now? Been having troubles the past weeks now with JotForm.

  • Kiran Support Team Lead
    Replied on March 13, 2017 at 11:12 AM

    We are sorry for the inconvenience caused. The Google spreadsheet integration is working fine and we have not received any reports in this regard. I have pushed the missing submissions to your Google spreadsheet for the form specified. Please check and see if the new submissions are being updated normally.

    If the issue still persists, please let us know. Also, please make sure that you are not making any modifications to the Google spreadsheet which will break the integration. 

    Thanks!

  • kekay
    Replied on March 20, 2017 at 10:57 AM

    And what is wrong with your Support Page? I keep getting this error.

    https://www.screencast.com/t/apRySxE1Cn
  • kekay
    Replied on March 20, 2017 at 10:58 AM

    Hi guys. It's me again but using a different account. I have created jotform accounts for each of our employees and we also have a paid account. There are a lot of Google sheets that are not working. Submissions are missing and these are important info from clients and applicants. Can you do something about this? If there's no known issue with Google sheets then why do I have lots of Google sheets that are not working? It's getting frustrating because I think I don't need to reintegrate the sheets everytime it's messed up.

    One jotform with missing submissions in the Google sheets is this: https://form.jotform.me/62403087788464

  • Kiran Support Team Lead
    Replied on March 20, 2017 at 1:19 PM

    We are sorry for the inconvenience this may have caused. A few months, we had an issue with the Google spreadsheet integration due to the policy changes from the Google API and forcing some limits. However, the issue was fixed by our backend team by applying for higher limits. Some of the forms with lot more fields that were integrated with Google spreadsheets might have affected with this restriction and could have caused the missing submissions. However, it should be fixed by reintegrating the Google spreadsheet again with the form.

    We would request you to check a few forms by reintegrating Google spreadsheets and see if that works. Please let us know if the issue still persists so that we will be happy to investigate the issue further.

    The issue with the support page error shall be addressed on a separate thread. Please follow the link below:

    https://www.jotform.com/answers/1096567

    Thanks!

  • kayemac
    Replied on March 20, 2017 at 6:48 PM

    That's a lot of hassle on my part because our company only uses Jotform for all our forms. But I guess I got no better choice. I will check all Google sheets I HAVE ALREADY REINTEGRATED to see if the new submissions are coming in.

    In the mean time, can you please push the new submissions to the Google sheet integrated to this form? 

    https://form.jotform.me/62403087788464

     

    I've reintegrated this form with Google sheets more than twice already. Please investigate.

  • Kevin Support Team Lead
    Replied on March 20, 2017 at 11:34 PM

    I've checked your form and I can see an error while trying to send the missing submissions to your form. 

    I will forward the issue to our second level so our developers may further investigate it in a deeper way, we will let you know as soon as we get any update about it. 

     

  • jenniferaguirre
    Replied on March 21, 2017 at 12:18 PM

    Thanks! Can you please check my other form as well?

    https://form.jotform.me/62404476966465

    I'm having the same issue with this. I've also reintegrated this twice and still the new submissions are not coming in.

     

    PS

    I've logged out from this account and opened a new tab to log in to our company's paid Jotform account and post this question. And still it shows one of our employees' (which I just created).

  • Kiran Support Team Lead
    Replied on March 21, 2017 at 1:57 PM

    I have tried pushing the missing submissions to the spreadsheet for the mentioned form. However, it looks like there is an issue with the integration or the account used. I received an error mentioning that Invalid Grant. Could you try logging into your JotForm account using a private/incognito window and then try to reintegrate the Google spreadsheet to see if that works?

    Since the issue is already has been forwarded to our backend team, once we have any information in this regard, you'll be posted here.

    Thank you! 

  • kayemac
    Replied on March 22, 2017 at 2:38 PM

    This form has the same issue.

    https://form.jotform.me/60850902894462


    We just noticed that it stopped getting the new submissions since 01/27/2017. Other forms stopped as well on the same date. I shouldn't be reintegrating them over and over again. 

     

    Please add this form in the escalation. Thanks and I will be waiting for the resolution.

  • Kiran Support Team Lead
    Replied on March 22, 2017 at 4:10 PM

    @kayemac,

    I just tried to push the missing submissions to the form provided. However, I see that the message says that the submissions are already merged. 

    Could you check if all the submissions are updated in the spreadsheet now? Let us know if it is not so that we can add it to the bug report.

    Thanks!

  • kayemac
    Replied on March 22, 2017 at 10:14 PM

    Unfortunately, it didn't work.

     

    Google Spreadsheet: Why new submissions are not showing in spreadsheet?  Image 1 Screenshot 20

     

    :(

  • Chriistian Jotform Support
    Replied on March 23, 2017 at 2:23 AM

    I have tried also to push the missing submissions to Google Spreadsheet on this form (https://form.jotform.me/60850902894462) and added this form too to the raised ticket.

    We'll inform you in this thread if there are any updates.

    Regards.

     

  • kayemac
    Replied on March 31, 2017 at 8:26 PM

    Still no updates???

  • Kiran Support Team Lead
    Replied on April 1, 2017 at 2:16 AM

    Unfortunately, there is no update yet on this issue. Let me send a note to our backend team to see if we have any update in this regard.

    We appreciate your patience and understanding.

  • Denis VP of Engineering, Enterprise
    Replied on April 11, 2017 at 3:40 AM

    Hello kayemac, 

    Sorry for the trouble caused to you. I have checked our logs, it seems Google denies your updates for forms 20Four7Va - VA Database and Client Database. I am sorry to say that there is nothing to do for these forms on our side. Re-integrating these forms should fix the problem. Please note that if you are using many integration/apps like Google Drive, Google Spreadsheets integrations on single Google account may cause this problem. But I can't see any problems with 20Four7VA VA Application Form. For the deeper investigation, I should ask for access to related Spreadsheet if possible. We are looking forward to hearing from you. 

    Regards.