Skip to main content
Answer

Google Sheets - Adding new rows

  • November 12, 2020
  • 2 replies
  • 158 views

I have a zap that adds a new row to a Google Sheet from a webhook. I expect to be dealing with a large amount of data.

I presume that when there are no new rows left on the sheet (currently around 3000), the zap will add new rows.
 

Can anyone confirm this is how the zap will act? How many new (blank, not from webhook data) rows will the zap add to a sheet at a time?

Best answer by Danvers

Hi @Ben164584

To specifically answer this question:

 How many new (blank, not from webhook data) rows will the zap add to a sheet at a time?

 

A zap can only add new rows with data; it can’t add a blank row to the sheet. 

 

Also, if you want to add more than one new row from the webhook data, you’ll need to use the action Create Spreadsheet Row(s) as opposed to Create Spreadsheet Row The (s) is important because it means that the Zap will add more than one row in Google sheets (from line items). 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • November 12, 2020

Zap will add 1 row at a time with data.


Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • Answer
  • November 12, 2020

Hi @Ben164584

To specifically answer this question:

 How many new (blank, not from webhook data) rows will the zap add to a sheet at a time?

 

A zap can only add new rows with data; it can’t add a blank row to the sheet. 

 

Also, if you want to add more than one new row from the webhook data, you’ll need to use the action Create Spreadsheet Row(s) as opposed to Create Spreadsheet Row The (s) is important because it means that the Zap will add more than one row in Google sheets (from line items).