Loading
Help

Google Sheets error: "The spreadsheet row could not be sent to Google Sheets. Unable to get a value when looking for "rows". Is it empty or missing?"

Last updated:

Symptoms

You may see this error in your Google Sheets action: "The spreadsheet row could not be sent to Google Sheets. Unable to get a value when looking for "rows". Is it empty or missing?".

Causes

  • No values added to sheet.
  • No data in mapped fields.
  • App that sends data to sheet is disconnected.

How to fix it

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.

Check account connections


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