Hello! How many rows can Zapier create in google sheets (in one spreadsheet). I’m getting close to 700 and don’t know if ther is any “border” or i can create rows indefinitely.
Question
What is the maximum number of rows created in Google Sheets?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+6- Zapier Staff
Hi
Welcome to the Community! 🎉
I did some digging into this, and it looks like there isn’t really a limit for created rows. However, the only limits you would run into when adding several rows at once would be rate limits from Zapier/Google Sheets if you try to add too many rows at once. Here's more info: https://zapier.com/help/troubleshoot/behavior/rate-limits-and-throttling-in-zapier
Additionally, Google Sheets API has usage limitations tied to the user. If the user hits this limit, they will see a 429 error that says Resource has been exhausted (e.g. check quota).
Important note: this is a user-specific limit separate from Zapier's overall project limits. If you are getting that specific error, you need to slow down the reads or writes to Google Sheets.
Hopefully, this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.