Google Sheet Integration: Why is our google spreadsheet integration not working?

  • Profile Image
    tech_fo
    Asked on March 15, 2018 at 05:36 AM

    hello!
    my account tech_fo  (ps: quote is OK)

    my form is connected to Google sheet. Since 14.03 the data has ceased to arrive in the table, why?

    see pic

  • Profile Image
    tech_fo
    Answered on March 15, 2018 at 06:00 AM

    1521108016Снимок2308.jpg

  • Profile Image
    TREVON
    Answered on March 15, 2018 at 09:01 AM

    Apologies for any inconveniences caused. Would you kindly try removing the integration and adding it again to your form?

    Kindly note that this will create a new file however it will have all submissions. Kindly note that this may take some time depending on number of submissions your form has.

    https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Kindly do let us know if this does not resolve the issue.

  • Profile Image
    tech_fo
    Answered on March 15, 2018 at 09:37 AM

    1521120694Снимок2309.jpg

    this does not work and results in data loss
    loss of more than 3,000 polls, this is a lot, how to fix it? ((

  • Profile Image
    TREVON
    Answered on March 15, 2018 at 11:09 AM

    Kindly note that you will not loose your data on re-integrating with Google Sheet since the integration is picking data from your submissions.

    As long as submissions are not deleted when you run the integration the form will sync with google sheet. Depending on number of submissions and size of each submission it may take some time for the data to be in sync.

    Would you kindly confirm how many submission have ben Synced so far?

  • Profile Image
    tech_fo
    Answered on March 15, 2018 at 11:21 AM

    Total 3741 submission

    500 submission add sync google sheet

    the rest do not sync

  • Profile Image
    TREVON
    Answered on March 15, 2018 at 12:33 PM

    Thank you for confirming the above. I have pushed submissions to your google spreadsheet. Kindly confirm all submissions have been added to your Google sheet document

  • Profile Image
    tech_fo
    Answered on March 16, 2018 at 01:56 AM

    nothing changed, this does not work

    look at this problem in video http://recordit.co/JJsslr94K3


  • Profile Image
    Victoria_K
    Answered on March 16, 2018 at 07:54 AM

    As far as I understood this issue upon jumping in to the thread, I can see that for some reason the original Google Spreadsheet integration was broken a while ago. You have re-integrated several times and got only 500 submissions synchronized immediately. 

    I have tried to download all your submissions as an excel file and can confirm that it includes all your submissions, which are ~3000. This means that the process works properly at our end. 

    Investigating the issue deaper, I have found the following information as to Google limits:

    https://developers.google.com/sheets/api/limits

    My suggestion would be that the process can take a while to reflect all ~3000 submissions. 

    I have tried to push the submissions once more, can you kindly let us know if it helped today?

  • Profile Image
    tech_fo
    Answered on March 21, 2018 at 08:35 AM

    Thank you, but this is really a problem google. Well, I did so, I downloaded the Excel file and deleted all submissions, and delete integration google sheet. i create new integration sheet, but I do not get the data.

    now more than 1k submissions and I'm forced to again export excel data manually

    on another project it works without failures

  • Profile Image
    TREVON
    Answered on March 21, 2018 at 10:23 AM

    Apologies for any inconveniences caused. Based on further analysis of the problem I would like to escalate the issue to our Level2 support team. We will update you on this thread once the issue is resolved.


    In the meanwhile, kindly share the google spreadsheet (https://docs.google.com/spreadsheet/ccc?key=107aakdXYKjKCykLizNzi2-Wa5uqJeK48rPE2Kvqp9Og)with us to assist our developer to further investigate the issue. Use the guide below:

    https://support.google.com/docs/answer/2494822?co=GENIE.Platform%3DDesktop&hl=en

     Share the above withe email support@jotform.com and let us know when its done

  • Profile Image
    tech_fo
    Answered on March 22, 2018 at 02:07 AM

    Thanks you, I added access to the table