When you fetch data from columns using functions like LOOKUP etc, it returns a key-value pair. Commonly, you would get the output in such format for JSON type columns of a sheet or those containing an array of objects. So when you need to get only the value from a specific key you need to use the GETKEYVALUE function.


GETKEYVALUE(object, “keyname”)


  • object: is the JSON object from where the value is to be fetched.
  • Keyname: is the default key name or label of the JSON object.

So for example,
GETKEYVALUE( JSON,”data.result")

This will get the value for the result key inside the data key.

To further understand how to use the GETKEYVALUE function refere to this article here.