How to add Metafield information in the Google Spreadsheet?

Hi Everyone!

I have concern about the Flow, and I am not sure how can I achieve this one. That is why I am asking for your kind help about it.

So, I am working to add the information of the order of the customer in a Google Spreadsheet such as the Order number, name, name of the product, weight, and shipping method. However, I also wanted to add if the Assembly is required and what is the shipping if it is small.

The Assembly Required and Small Shipping are in the Metafield Editor App (Webly) which I know Shopify cannot check those information since it is third party app and cannot be integrated in the Shopify Flow.

The next resort that I have is to use the Metafield of Shopify to detect if the Assembly is required and if it is Small Shipping using the Boolean (True or False). So, I was able to successfully made some test, and when I run the flow, it is showing as Blank even though I made sure that all information are accurate.

Can you suggest what should I do and how can I effectively add this in the products? Since it is a furniture business, there are items that needs to be assembled when we deliver the items.

Thank you!

For an order to get a product metafield you need to go through each line item and each line items connection to a product and that products metafields.
So you can’t go order.product.metafield.namespace.key etc and hope to get something because orders do NOT have products they have LINE ITEMS

No that’s not how that should be working.
The App lets you edit metafields that EXIST on a RESOURCE in Shopify itself.
It’s not external proprietary data held by a third party app; unless detail is being omitted or something hinky is going on.

E.g. if it’s a product, or collection or etc etc metafield then flow can check it in specific actions.

Keep OTHER people in mind, show your work.
Think it through when troubleshooting: How are OTHER people supposed to know what you built in order to figure out what’s wrong with it if you do not show/share anything beyond an overview.

If you just need it fixed then reach out by clicking my profile pic (it wont reload the page) or request I PM you.

Hi! I sent a message to you. Thanks for your insights!