Skip to main content
Question

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

  • 10 June 2024
  • 1 reply
  • 21 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.

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!