Update a Google Sheet row from a array

Hello guys

I’m updating a google sheet row when a order change on WooCommerce

For example, if the order 2563 change to Payment Received, I need update on my Google Shhet the row from that order id

I’ve all clear and the row updated BUT I received some data from a WooCommerce Meda Data BUT not the bundle array I need

This module I check the order details

Here I read all metadata from woocommerce order

Then I check on my google sheet what is the cell same to woocommercr order id

ALL IS OK at this step

BUT, here I need update this row

With this value from the metadata array

I don’t see the option here to select the array mentioned, only sow the 1st array value


and I need the vaue from the 3rd array


also This is the JSON

blueprint.json (47.8 KB)


Welcome to the Make community!

Please provide the output bundles of the modules by running the scenario, then click the bubble on the top-right of each module, save the contents as a bundle.json file, and upload it here into this discussion thread:


This will allow others to better assist you. Thanks!


I can’t found that optio u said

e.g.: Your screenshot 6 and 10, scroll up to the top-right.



Order details

bundle.json (7.0 KB)

iterator array with metadata

iterator_bundle.json (3.3 KB)