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?".
- No values added to sheet.
- No data in mapped fields.
- App that sends data to sheet is disconnected.
Make sure there are values in your sheet. Learn how to set up your sheet action.
If your mapped fields have no data, check previous steps to ensure that information is correctly sent to the Google Sheets step.
You can use Formatter by Zapier to create a default value when a previous field doesn't contain data.