Woocommerce Order Updates in Google Sheets: How does a zap look like?

  • 17 October 2020
  • 5 replies

Userlevel 1

Ok, so I created a zap that creates a new row in a Google Spreadsheet when a Woocommerce order is created in WooCommerce. 

But the order status is (obviously) not updated. So many orders that are on status “completed” in Woocommerce are still on “pending” in the Google Spreadsheet.

So my questions are:

1.) Is it possible to create a zap that updates the order status of already imported orders?

2.) How can I do that?

Thank you for any help,


5 replies

Userlevel 7
Badge +5

Try rebuilding step 4.

There can be a lot of factors that cause errors for GSheets.


Userlevel 1

Thank you. Yes, that was it!

However now step 4 does not seem to work.


Here’s the screenshot for the settings:


And here’s the error message when testing:


Thank you for your incredible patience! Really appreciated.




Userlevel 7
Badge +5

Have you pulled thru a sample order that matches the conditions of the Zap for which you are trying to test? (e.g. Status = Completed)


Probably need to remove the static “status” value.


Userlevel 1

Thank you for the super-fast help.


However, when trying to follow your steps, I am facing the following problems:


in Step 2: The filters don't seem to recognize any value such as “completed” or “pending” as transferred by the first ZAP to GSheets. See here:

and here:

What could be the issue there?


In Step 3: GSheet Lockup Row does also seem to have an issue:


What am I doing wrong?

Thank you very much for your kind support.





Userlevel 7
Badge +5


  1. Trigger: WooCommerce Order (make sure to adjust the settings to be for updated Orders only)
  2. Action: Filter (TBD if this step is needed but could be used to filter for only a specific Status)
  3. Action: GSheets Lookup Row
  4. Action: GSheets Update Row