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.
Getting data from any API using http GET
Let's learn about the HTTP GET request to retrieve data from any API using Rows.
Parsing data manually
Learn how to parse and manipulate JSON data manually.
Sending data to any API with http POST and PUT
Learn how to send information to an API using POST or PUT.
Expanding data cells and Insert to other tables
Learn how to automatically insert data from JSON or other tables using OVERWRITE(), INSERT(), and UPDATE().
Using APPEND or JOIN functions to merge tables
Learn how to merge tables using APPEND and JOIN functions in Rows.
Using QUERY and understanding the Query Language
Filter and transform data from a range of cells using an SQL-like language.
Scheduling and repeating actions
Learn how to automate your spreadsheets using REFRESH, REPEAT, and SCHEDULE.
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.
Working with integrations
Learn about the different types of integrations, how to connect them and how to use their functions.
Debugging integration connections
A few ways in which you can try and identify what's causing an integration function to error out.
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.
Creating tables out of your data
How to insert data into dynamic tables with the `OVERWRITE()`, `INSERT()`, and `UDPATE()` functions.
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.
Creating scheduled and repeating tasks
How to schedule and repeat certain tasks at regular intervals.
Managing your integrations and switching accounts
How to review your active integrations, disconnect ones you don't need, and use multiple accounts.
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,
Requesting data from any API
An introduction to the GET function in Rows and how to use it to request data from APIs
Creating a GET request
How to make HTTP GET requests with the GET function.
Authenticating your API requests
How to authenticate your API requests and understand the different authentication methods.
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.
Sending data to an API
Learn how to send information to an API using POST or PUT.
Managing multiple integrations
Learn about how to use two or more of the same integration at the same time.
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