Google Drive / Sheets Integration

  • Profile Image
    knvpstudios
    Asked on May 10, 2017 at 03:47 PM

    Hi,

    Is the Google Sheets integration occurring in real time?  In other words, as a I receive a form submission via email, and I have Google Sheets properly integrated, shouldn't I be seeing the submission on the Google Sheet at the same time, as the submissions are made?  Or is the integration, 1 time only?

  • Profile Image
    Sven
    Answered on May 10, 2017 at 04:39 PM

    Hi, 

    If you have the integration set properly, you should be able to see every new submission in google spreadsheet, meaning it will update the sheet every time a new submission is made. 


    You will also still be able to see your submissions in your submission list here in JotForm.

     

    Here are some links to help you with your google drive integration:

    How-to-Integrate-a-Form-with-Google-Drive

    How-to-Integrate-Form-with-Google-Spreadsheet

     

    Hope this answers your question, please let us know if you need any further help.

     

    Thank you!

  • Profile Image
    knvpstudios
    Answered on May 10, 2017 at 05:06 PM

    Thanks for the response.  If I only wish to use Sheets, must I integrate with Google Drive as well?  I've successfully integrated with Sheets, and the sheet is inside my Google Drive, but it is not updating with each submission.

  • Profile Image
    jonathan
    Answered on May 10, 2017 at 11:08 PM

    Google Drive integration and Google Spreadsheet integration are 2 different and separate integration available in JotForm. You can use either only or both, and they will still work.

    It is correct that the Google Spreadsheet will be added inside your Google Drive when using the Google spreadsheet integration. This is because it just uses your same Google account.

    If I understand correctly now, the Google Spreadsheet integration on your form is not working properly at this time. Because the form submissions were not updating the Google spreadsheet.

    User guide: How-to-Integrate-Form-with-Google-Spreadsheet

    Can you try first removing the existing Google spreadsheet integration on your form. Save the form, and then redo the integration again.

    You can check again after if the Google spreadsheet is now updated with the form submission data.

    Let us know if issue persist.

  • Profile Image
    knvpstudios
    Answered on May 11, 2017 at 12:57 AM

    Hello,

    Indeed you are correct - it simply is not updating now - i.e. the submissions are not updating on Google Sheet any longer.  This is with both the Drive and Sheets integration enabled.

    I have removed and re-added the integrations, and although the initial "Sheet" it creates does have all the submissions up until that point, it fails to update on any further submissions posted after the sheet is generated.

    Please advise.

  • Profile Image
    Chriistian
    Answered on May 11, 2017 at 03:17 AM

    Hi,

    Can you please share with us the form you are currently working on? And if possible, can you please also share us the integrated sheet so that we can further check?

    I checked your only form in your account (http://www.jotform.us/form/71109166055149) and I noticed that it is not integrated either the Google Spreadsheet or Google Drive. 

    We'll wait for your response.
    Regards.

  • Profile Image
    david
    Answered on May 11, 2017 at 12:13 PM

    It seems your last response may not have posted to our forum.  If you wouldn't mind sending your last response again, we will be happy to have a look.

  • Profile Image
    knvpstudios
    Answered on May 11, 2017 at 12:40 PM

    Well, I don't know how or why, but it appears that the Google Sheets integration is now working again - and my sheet is now updating with new submissions.  There was a period of 2 days when it wasn't working which is why myself and the other person posted about it.

    I'll be sure to post here again if it stops working again.

     

  • Profile Image
    david
    Answered on May 11, 2017 at 01:28 PM

    If you make any edits to the integrated sheet, it can break the integration.  If that is not the case and the integration continues to fail, let us know and we will look into this further.