Rows for Advanced users

Rows is great for Advanced users - learn how to work with APIs, manipulate JSON, and use multiple integrations.

Parsing data manually

Learn how to parse and manipulate JSON data manually.

Expanding data cells and Insert to other tables

Learn how to automatically insert data from JSON or other tables using OVERWRITE(), INSERT(), and UPDATE().

Filtering with JsonPath

Learn to use advanced JsonPath to get and filter for specific data points.

APIs and JSON overview

An overview of how to work with APIs and JSON in Rows,

Parsing JSON

How to parse and select JSON data in Rows.

Filtering JSON responses with JSONPath

How to use advanced JSONPath to get and filter for specific data points.

Modifying the structure of a JSON response

How to modify JSON objects so that they match exactly what you need.

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.