Best answer

Error: Failed to create multiple spreadsheet rows in Googe Sheets, requested writing within range.

  • 17 January 2023
  • 2 replies
  • 232 views

Userlevel 1
Badge +1

I get this error on google sheet, why am I getting it. 

This is how the sheet where the data should be inputted looks like

 

This is what the Zapier action looks like
 

 

icon

Best answer by SamB 17 January 2023, 14:06

View original

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

Userlevel 7
Badge +11

Hey @Fahad, welcome to the Community! 🙂
 

It looks like the worksheet has a colon (:) in its name. That can often be the cause of a “within range” kind of Google Sheets error. You can find out more about the different causes of that type of error here: I'm seeing an errors that mention 'range' (cannot parse range, requested writing within range)

To fix this, try removing the colon from the worksheet name in Google Sheets and then reselect the worksheet in your Zap. Please do give that a try and let us know whether that then allows the spreadsheet rows to be added successfully!

Userlevel 1
Badge +1

@SamB, It worked thanks :)