Google Spreadsheet Integration: Submissions not being updated on the sheet after a day or two

  • Profile Image
    Bjksolutions
    Asked on March 16, 2018 at 12:43 PM

    Hello, 

    I have been facing the issue from past many days. When I integrate my form with google spreadsheet it works fine for a day or 2 and after that it stop syncing. Whatever the responses captured in the form does not appear in the google spreadsheet. 

    Then I had to remove the integration and re-integrate the form after that I am able to see the data in that. 

    This is very annoying that we have to remove the integration and then create again. 

    Everytime we integrate it gives us the different link to access and in that case we cant even save the link, so we have to login into the form and we have to open the link from the form which is also a waste of time as well as quite frustrated. 

    Kindly look into this issue and update me at the earliest. I will be thankful to you. 


    Thanks 'n' Regards

    Rakshit Sood 

  • Profile Image
    david
    Answered on March 16, 2018 at 01:58 PM

    Usually the only time the integration breaks is if the integrated sheet is being modified or modifications are made to the form that change the column structure of the sheet.  I checked the most recent integration for your form and it is still connected. 

    I tried pushing the most recent set of submissions and I am not sure if the process completed.  Check the sheet to see if all information is there.

    If no edits are being made to the sheet or the form and it continues to disconnect, let us know the next time it disconnects and we can forward this to our developers to have a look.

  • Profile Image
    Bjksolutions
    Answered on March 16, 2018 at 02:36 PM

    I have integrated this sheet day before yesterday and when I checked it in the morning it was not updating, so I removed the integration and integrate it again. As i have done this today morning only so it is going to work for today or may be till tomorrow as well. 

    We do not modify the spreadsheet at all, but yes we do modify the form but we do that only on monday and thursday but this integration can stop any day anytime and we are not even able to trace the issue that why exactly this is happening. 

    Is this a bug in your application. 

  • Profile Image
    david
    Answered on March 16, 2018 at 02:40 PM

    If/when it does fail again, let us know when it does and we will forward this to our developers to see why. 

  • Profile Image
    Bjksolutions
    Answered on March 17, 2018 at 10:43 AM
    As per you said to update you when the issue persists. Since yesterday I
    have not made even a single change in the form and as i checked today I am
    unable to see the data of today's date.
    This is a serious issue and please look into this on high priority and help
    us in getting this issue resolved at the earliest.
    Thanks 'n' Regards
    Rakshit

    Virus-free.
    www.avg.com

    <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
    ...
  • Profile Image
    John_Benson
    Answered on March 17, 2018 at 01:38 PM

    I checked the form (https://form.jotform.me/Bjksolutions/saveurmoney) and there's no Google Spreadsheet integration.

    1521308252Integration_001.png

    Please re-integrate the Google Spreadsheet to your form by following this guide: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    After that, please test it again and if the issue still persists, let us know. Thank you.

  • Profile Image
    Bjksolutions
    Answered on March 17, 2018 at 04:43 PM
    I have checked again and it shows me that integration is done with google
    Spreadsheet. I have shared the link below. If it would not be integrated
    then i wouldnt be having the link.
    https://docs.google.com/spreadsheet/ccc?key=1rmnRRKsXdkgR1rvTyBGZ8SqjoXuTk-XFhhHXojb5gpg
    Kindly refer to the attached snapshot as well where it shows that
    integration is done.
    ...
  • Profile Image
    TREVON
    Answered on March 17, 2018 at 05:44 PM

    We can now see the Integration. I have done a manually pushed submissions to your Google Sheet document. Kindly check if you have the latest submission in the Google Sheet file.

  • Profile Image
    Bjksolutions
    Answered on March 17, 2018 at 06:43 PM
    I will check this on monday and will update you accordingly as we have left
    for the day.
    ...
  • Profile Image
    Bjksolutions
    Answered on March 19, 2018 at 10:43 AM
    I just checked the spreadsheet but didnt see any submission made by you in
    that. The spreadsheet last synced on 16th march. But it still shows that
    the integration is done and working properly but its not working.
    Kindly look into this and revert me at the earliest.

    Virus-free.
    www.avg.com

    <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
    ...
  • Profile Image
    John_Benson
    Answered on March 19, 2018 at 12:12 PM

    I cloned your form so I can re-integrate Google Spreadsheet and it is working properly on my end. 

    1521475788Sheets_001.png

    Unfortunately, I was not able to access the Google Spreadsheet link you provided. I think it is set to Private. 

    I also submitted a test submission to your form (https://form.jotform.me/Bjksolutions/saveurmoney), did you receive it in the Submission Panel or notification email? If yes, please check the Google Spreadsheet if you also receive my test submission.

    We'll wait for your reply. Thank you.

  • Profile Image
    Bjksolutions
    Answered on March 19, 2018 at 05:43 PM
    I have received your test submission but it does not appear on the google
    spreadsheet. As it didnot synced since 16th March. In order to get the
    current responses in google spreadsheet I have to remove the integration
    and then again reintegrate it which works fine for another day or two.

    Virus-free.
    www.avg.com

    <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
    ...
  • Profile Image
    jonathan
    Answered on March 19, 2018 at 08:04 PM

    Thank you for updating us on the status. From your latest response, I understand that the issue was resolved already as of this time.

    Please don't hesitate to contact us again anytime should the issue persist.

    Regards

  • Profile Image
    Bjksolutions
    Answered on March 19, 2018 at 08:43 PM
    Have you clearly read my last reply. Where did i mentioned that issue has
    been resolved. This is really not at all the kind of support i have been
    looking for.
    I expected i lot better from you all. I suggest to escalate this issue to
    the developers. Maybe they might provide me any resolution.
    ...
  • Profile Image
    Kiran
    Answered on March 20, 2018 at 01:37 AM

    We are sorry for the confusion. Let me forward the issue to our backend team to investigate the issue further. We also request you to share the Google spreadsheet that is currently integrated to the form so that we can take a look.

    1521524167GoogleSpreadsheetShareLink.png

    If we have any news in this regard, we'll update you here.

    Thank you!

  • Profile Image
    Bjksolutions
    Answered on March 20, 2018 at 02:43 PM
    Hello
    As per your requirement I have shared the link mentioned below. This link
    is currently integrated with our form but if you see the data in it the
    last data appeared on it is of March 16.
    https://docs.google.com/spreadsheets/d/1rmnRRKsXdkgR1rvTyBGZ8SqjoXuTk-XFhhHXojb5gpg/edit?usp=sharing
    Let me know if you need anything else from my end to further troubleshoot
    the issue.

    Virus-free.
    www.avg.com

    <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
    ...
  • Profile Image
    TREVON
    Answered on March 20, 2018 at 02:54 PM

    Apologies for the confusion, by share we meant you grant support@jotform.com access to the Spreadsheet document if you do not mind doing so.

    Thank you.


  • Profile Image
    Bjksolutions
    Answered on March 20, 2018 at 03:43 PM
    I am sorry that would not be possible, what best i can do is that when you
    make changes you may update me and i will check if the changes made by you
    are reflecting or not.
    ...
  • Profile Image
    Victoria_K
    Answered on March 20, 2018 at 04:23 PM

    Thank you for updating us! 

    We will let you know if there is an update as to this issue.