JQ

Lido's =JQ() formula lets you manipulate JSON strings using the popular JSON processing language JQ

=JQ(json_string, jq_query)

Examples

=JQ("[1,2,3]", ".[0]")=> "1"