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

  • 17 October 2020
  • 8 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,


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

8 replies

Userlevel 7
Badge +14


  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


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 +14

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. 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 +14

Try rebuilding step 4.

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


Userlevel 7
Badge +10

Hi @fliegenglas 

Just checking in, did you manage to get this sorted?

Userlevel 1

No, unfortunately I have not found a way to update orders status properly via Zapier.

Userlevel 7
Badge +10


The error you’re seeing is because in the ‘Row’ dropdown you need to map the ‘Row ID” field from step 3, now the ‘Status’ field. 

That dropdown is where you tell Zapier which exact row to update - in this case the one you got from the lookup in the previous step.

If you still have problems with this, feel free to reach out and I can try and help.