Question

What is the maximum number of rows created in Google Sheets?

  • 10 June 2024
  • 1 reply
  • 10 views

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.


1 reply

Userlevel 7
Badge +6

Hi @Marcin Lirski,

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!

Reply