Extracting attribute:value and placing into google sheets

How To
,
1

I have product data in google sheets in the format of
Producer: Simfer
Gross depth (mm): 570 mm
Gross height (mm): 110 mm
Gross weight: 4.85 kg
Gross width (mm): 340 mm

I have used Text parser match elements key:value to separate the attribute and value and this is done successfully as bundles:

image
image300×353 5.02 KB

I need to place these values into specific cells in google sheets document. Can anyone please guide me how to do this? I’ve tried so many ways, but failed. Only way that has worked has been through Router > Google sheets update row and using filtering for each attribute name, but i have so many different attributes that it’s not a very effective way and it’s using a lot of operations. Is there some other way to map a correct attribute value to a specific cell (update row) in google sheets?

2

Use the get() function to access the values.