Skip to main content
Best answer

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

  • January 17, 2023
  • 2 replies
  • 318 views

Forum|alt.badge.img+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
 

 

Best answer by SamB

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!

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

SamB
Community Manager
Forum|alt.badge.img+11
  • Community Manager
  • 9652 replies
  • Answer
  • January 17, 2023

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!


Forum|alt.badge.img+1
  • Author
  • Beginner
  • 15 replies
  • January 17, 2023

@SamB, It worked thanks :)