Rows for Advanced users

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

Authenticating your API calls

Learn about authentication in APIs: the different types, how to use them, and how to read API documentation to find what you need.

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 data with functions FILTER and FILTER_COLUMNS

Learn how to use the FILTER and FILTER_COLUMNS functions to build specific views on your data.

Creating Tables from complex data structures

An introduction to UNNEST and FLATTEN and how they can help you optimize complex data structures for better-looking Tables.

Using AUTOFILL to automatically fill a row or column

Use the `AUTOFILL` function to apply the same formula to each row in a neighboring table—even when the table changes dynamically.

Managing your integrations and switching accounts

How to review your active integrations, disconnect ones you don't need, and use multiple accounts.

Filtering JSON responses with JSONPath

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

Geocoding and reverse geocoding with Google Maps APIs

Learn how to convert an address into a pair of coordinates or coordinates into an address

Send SMS with Infobip

Send SMS messages directly inside your spreadsheet

Send SMS with MessageBird

Send SMS messages directly inside your spreadsheet

Platform limits

To give you the best experience using Rows, we have a few limits in place for now.

Using QUERY and understanding the Query Language

Filter and transform data from a range of cells using an SQL-like language.

Debugging integration connections

A few ways in which you can try and identify what's causing an integration function to error out.

Creating scheduled and repeating tasks

How to schedule and repeat certain tasks at regular intervals.

Managing multiple integrations

Learn about how to use two or more of the same integration at the same time.