Google Drive / Sheets Integration

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?

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!

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.

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.

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.

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.

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.

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.

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.