Loading
Help

Google Sheets error: "The spreadsheet row could not be sent to Google Sheets. There was an error writing to your Google sheet."

Last updated:

Symptoms

You may see this error in your Google Sheets action: "The spreadsheet row could not be sent to Google Sheets. There was an error writing to your Google sheet."

Causes

  • Entering a value in the Row field that is not a row ID.
  • Size limits.
  • No values added to sheet.
  • No data in mapped fields.
  • Name of spreadsheet or worksheet changed.
  • Punctuation in spreadsheet or worksheet name.
  • Frozen or hidden columns/rows/cells.

How to fix it

Enter a row ID in the Row field

You must enter the row ID in the Row field. The row ID is a numeric value and corresponds to the row number that you see in Google Sheets.

To enter a row ID:

  • Select a row from the dropdown menu. This row will be used each time the action runs.
  • Enter a row ID as a custom value. The row ID will change each time the action runs.
Tip

You can use a Lookup Spreadsheet Row action to find a specific row in your sheet. This returns the row ID, which you can enter as a custom value.

Change the size of your sheet or use a different sheet

Your sheet cannot contain more than:

  • 5,000,000 cells.
  • 40,000 rows.
  • 18,278 columns.
  • 50,000 characters per cell.

If you exceed these limits, you must delete data from the sheet or use a different sheet.

Add values to your sheet

Make sure there are values in your sheet. Learn how to set up your sheet action.

Check that mapped fields have data

If your mapped fields have no data, check previous steps to ensure that information is correctly sent to the Google Sheets step.

Tip

You can use Formatter by Zapier to create a default value when a previous field doesn't contain data.

Reselect your spreadsheet and worksheet

If the name of your sheet or worksheet has changed, reselect both in the Zap editor.

Remove any punctuation in your spreadsheet or worksheet name

If your spreadsheet or worksheet has punctuation marks on its name, remove any punctuation. Then, reselect both in the Zap editor.

Unfreeze and unhide columns/rows/cells

Frozen or hidden columns can cause trouble for Zaps, so make sure to unfreeze or unhide any columns or cells in your spreadsheet.


Need More Help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community