• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Updating woocommerce order status to google sheets with multiple items


Hi everyone,

I created a workflow with Iterator to add woocommerce new order that has multiple items to google sheets and is working fine and adding multiple rows for orders that has more than one item.

Now, I need to create another workflow to update the order status once changed in woocommerce to the existing orders with multiple items in google sheets. I used "Lookup spreadsheet rows" which gives more than one row index and didn't know how to map them in next action.

Your help is extremely appreciated.



Staff member
Hi @Asim,

You can disable Simple Response, then click on 'Save & Send Test Request.' This will give you a response in the form of an array. Next, you can add an Iterator to your workflow and map the Iterator response in the 'Update Cell Value' action step. The Iterator will allow you to iterate through all the rows that contain the specific ID and update those cells.