You've encountered an error message that mentions 'range', specifically phrases like:
- "cannot parse range"
- "400 Error: Requested writing within range..."
Causes
There are four potential reasons behind this error:
- Colon in spreadsheet or worksheet title: If your spreadsheet or worksheet title contains a colon (:), it can interfere with Zapier's functionality.
- Empty Zap fields: Occasionally, when the Zap tries adding a blank row, it might lead to this error.
- 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.
-
Sheet formatting issues:
- Frozen, hidden rows or columns: If you have frozen or hidden rows or column, attempting to write content into a frozen or hidden cell can cause errors.
- Protected rows or columns: If you attempt to create or update rows into protected cells for which your account lacks the necessary permissions, the operation will be blocked.
How to fix it
To fix this error, follow these steps:
- Check for colons in a spreadsheet or worksheet title: If found, remove the colons and save the changes.
- 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.
- 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.
-
Check if any rows or columns are frozen, hidden, or protected in the target range and adjust accordingly.
- If there are hidden rows or columns that are necessary for your Zap, unhide them.
- If you have protected rows or columns in the range, you will need to adjust the protection settings to give the account you’ve connected permissions to edit. Alternatively, remove the edit protections.
- Toggle your Zap off and on if you’ve made any of these formatting changes.
Still having trouble?
Contact Zapier Support for help.