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

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

Jotform Support

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!
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.
Kat

Jotform Support

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!