Problems with Google Sheets integration

  • Profile Image
    Asked on April 30, 2015 at 08:12 PM

    Hey guys,

    I keep running into troubles with the Google drives integration - every couple of weeks, old form entries that had already been transferred to google disappear from the google sheet (more specifically, really old ones) - alongside with all tabbed sheets other than the main one (the one where the entries go).

    Furthermore, since a couple of days only parts of the fields from the jotform seem to be transferred.

    Did you by any chance hear about a similar problem and could offer some ideas?

    Thanks so much,


  • Profile Image
    Answered on April 30, 2015 at 10:04 PM

    Hi Tobias,

    I do apologize for the issue that you are experiencing with your form integration.

    Have you been making any changes directly to the integrated spreadsheet? If so, this can cause the integration to be broken and cause the issues that you are currently experiencing.

    Please attempt the following steps to resolve the issue:

    Remove the current integration

    Clear your form cache

    Recreate your integration

    I hope this helps, please inform us if you need further assistance.

    Thank you.

  • Profile Image
    Answered on May 10, 2015 at 09:15 AM

    Hey Shadae,

    Thanks so much for getting back to me! Would you also say that the issue with some form entries only being partially transferred to google is due to what you described?


  • Profile Image
    Answered on May 10, 2015 at 10:54 AM

    Yes, that might be possible reason if it happened at that time Tobias.

    Since Google released the update to their Google Drive policy at that time, our developers worked on both Google Drive and Google Spreadsheet integration.

    This was done in a way to not interrupt any active integrations, but if it did for you, we apologize for that.

    Can you tell us if the same issue is still present for you?

    I should mention though that old parts of your Google Spreadsheet should not be missing since our integration does not remove any data, only adds to it, but please be sure that you are not near the limit of your Google Spreadsheet row count (about 400.000 rows of 1 cell, more cells means less rows, so 200.000 rows of 2 cells, and so forth).