Shopify flow: Add line items to Google Sheets rows when a new order is placed error

Shopify Plus

Topic summary

A user encounters an HTTP 400 error when attempting to use Shopify Flow to automatically add new order line items as rows in a Google Sheet. The error message states “This operation is not supported for this document” with a FAILED_PRECONDITION status.

Key Details:

  • The workflow uses the “Add row to spreadsheet” action
  • The request appears to contain empty or improperly formatted row data
  • The spreadsheet URL includes unusual sharing parameters

Suggested Troubleshooting:

  • Check if the data being sent is empty or malformed
  • Review the spreadsheet URL format (contains atypical parameters)
  • Consult Shopify’s official FAQ for the Google Sheets connector

Status: Unresolved - awaiting further investigation or response from the original poster

Summarized with AI on October 31. AI used: claude-sonnet-4-5-20250929.
1

Hi There,

Im getting the below error code when trying to run a google sheets add row to spreadsheet flow:
Any idea how to fix it?

*I’ve replaced personal details with “XXXXXXXXXXX”

Exception: Http 400

{“status”:400,“response_body”:“{"message":"","body":"{\n \"error\": {\n \"code\": 400,\n \"message\": \"This operation is not supported for this document\",\n \"status\": \"FAILED_PRECONDITION\"\n }\n}\n","return_value":""}”,“verb”:“POST”,“url”:“https://flow.sfe.shopifyinternal.com/flow_connectors/actions”,“request_body”:“{"shop_id":59693924523,"shopify_domain":"XXXXXXXXXXX.myshopify.com","properties":{"spreadsheet":"https:\/\/docs.google.com\/spreadsheets\/d\/1-XXXXXXXXXXX\/edit?usp=sharing\u0026ouid=107025360893277550209\u0026rtpof=true\u0026sd=true","worksheet":"Order Form","row":",XXXXXXXXXXX,\n \n,"},"action_run_id":"cedae720685c22a8e61a19750df980cfd425a940","action_definition_id":"Add row to spreadsheet"}”}

2

Hard to say. It looks like whatever you are trying to send it empty. Your URL also has a bunch of params on it that are not typically in the URL.

Otherwise, I’d look at the FAQ here: https://help.shopify.com/en/manual/shopify-flow/reference/connectors/add-row-to-spreadsheet#faq