TRANSPOSE_JSON

Switches rows and columns from ranges or {data} and creates a {data} cell with the results.

FROM_JSON

Converts a json string into a json object.

TO_TEXT

Format a value as a text string. The function accepts numbers, URLs, or JSON data.

RANGE2JSON

Create a JSON array of objects from a range.

PAIR2JSON

Create a JSON object from data pairs.

PARSE

Parse JSON data.

JOIN

Join two data sources. The function will use values from the root of the JSON.

FILTER_COLUMNS

Filter columns of data from a source table or JSON array.

APPEND

Append two or more JSON {data} objects.

FILTER

Filter JSON data or ranges by a given condition.