Is there a limit to the number of entries that can be pushed to Google Sheets?

  • dc4622ne
    Asked on October 16, 2020 at 12:44 PM

    Is there a limit to the number of entries that can be pushed to Google Sheets? Mine seem to have stopped at 500.

    Thanks

  • Kat JotForm Support
    Replied on October 16, 2020 at 2:42 PM

    Hi @dc4622ne,

    Happy to help!

    Is this happening with all of your forms or just one in particular? Could you please provide the URL of the form that is experiencing the issue?

    Please note that anytime you change a form you will need to reintegrate with Google Sheets: could you please reintegrate the form in question with Google Sheets and see if this solves the limit issue and update us on this thread? To err on the side of caution, I have also cleared your form caches.

    We await your response. Thank you!

  • dc4622ne
    Replied on October 16, 2020 at 2:45 PM

    I reintegrated and it still stopped at 500. URL of form is: https://form.jotform.com/202645629523154

    Thanks for your help on this.

  • Kat JotForm Support
    Replied on October 16, 2020 at 4:49 PM

    Hi again,

    Thank you for the update! I have one more thing that we can try together.

    You may be able to use the onChange event trigger for this if there is an issue with Google Script. Please refer to this forum and see if this helps: https://stackoverflow.com/questions/16183127/trigger-google-apps-script-when-jotform-submitted-and-integrated-to-spreadsheet

    If the problem still persists, please let us know.

    Thank you!