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

  • Profile Image
    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



    This is a re-post of a comment on How to Integrate Forms with Google Sheets

  • Profile Image
    Katherine_W
    Answered on October 16, 2020 at 02: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!

  • Profile Image
    dc4622ne
    Answered on October 16, 2020 at 02: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.

  • Profile Image
    Katherine_W
    Answered on October 16, 2020 at 04: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!