Google Sheets error: 400 Blank rows cannot be written; use delete instead

Written by Owner

Updated at August 20th, 2025

+ More

Table of Contents

Causes How to fix it Still need help?

You see an error message of "400 Error: Blank rows cannot be written; use delete instead" when Zapier attempts to create a spreadsheet row in a Google Sheets spreadsheet. This error happens when testing the Zap or if the Zap is turned on.

Causes

This error happens when Zapier encounters a blank row during data transfer between an app and a Google Sheets spreadsheet. You can't create a blank spreadsheet row.

How to fix it

To fix the issue, follow these steps:

Turn off your Zap: This will prevent the Zap from trying to process data while you're working on it.
Re-test your trigger or action: This will ensure Zapier is looking at the most recent data in your spreadsheet.
Remap the field: In your affected action steps where the data hasn’t been added, re-select the field.
Save your changes: Once you have remapped the field, click the Save button.
Turn your Zap back on: Your Zap should now be able to find the data that it needs and process it correctly.

Still need help?

If this article did not fix the issue, Zapier has a few other options to get you the help you need:

Contact Zapier Support. Our Support team can investigate your account to find solutions.
Ask in the Zapier Community. Get advice from experienced Zapier users in the Zapier Community.
Learn more about getting help. Read our guide on how to get help and support with Zapier to find the best resources for your specific problem.

Google Sheets error: 400 Blank rows cannot be written; use delete instead

Contact Us

Causes

How to fix it

Still need help?

Related Articles