Update a Google Sheet row from a array

[Carlos_Herrera]

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

THANKS A LOT

also This is the JSON

blueprint.json (47.8 KB)

l

[samliew]

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!

[Carlos_Herrera]

I can’t found that optio u said

[samliew]

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

[Carlos_Herrera]

Attach

Order details

bundle.json (7.0 KB)

iterator array with metadata

iterator_bundle.json (3.3 KB)