Google Sheets error: cannot pass range or requested writing within range

Symptoms

• "cannot parse range"
• "400 Error: Requested writing within range..."

Causes

1. Colon in spreadsheet or worksheet title: If your spreadsheet or worksheet title contains a colon (:), it can interfere with Zapier's functionality. 
2. Empty Zap fields: Occasionally, when the Zap tries adding a blank row, it might lead to this error. 
3. Changed spreadsheet or worksheet name: If the name of the spreadsheet or worksheet has been altered since you initially set up the Zap, it can cause this error. 
4. Sheet formatting issues:
   • You have frozen, hidden rows or columns.
   • You have protected rows or columns.

How to fix it

1. Check for colons in a spreadsheet or worksheet title: If found, remove the colons and save the changes.
2. Verify Zap field mappings: Review the Zap's fields and ensure that all required fields are mapped and contain appropriate values. If any fields are missing or empty, map them and provide the necessary data.
3. Check for name changes: Confirm that the spreadsheet and worksheet names haven't been changed since setting up the Zap. If the names have been altered, temporarily disable the Zap, make the necessary name changes, and then re-enable the Zap.
4. Check if any rows or columns are frozen, hidden, or protected in the target range and adjust accordingly.