Working with data

Get to know about recommended rows and tables to extract data easily from integration functions.


Integrations and their functions output cells with {data}. How do you work with it? Well, that’s exactly what we’ll be talking about in this article: working with data from integration functions.

Data cells

In Using Integrations, we used a Crunchbase function to get info about Apple. In the cell where we executed the function, we stored the results in a {data} cell like this:


Now, to see what data the function actually returned, we need to use the Data Explorer.

Data Explorer

With data cells, if you click on the icon-data-explorer icon, our Data Explorer panel will open up with two tabs:


RecommendedSome one-click options that quickly and easily insert the data into your table. You can choose either a recommended Row or Table.
All dataThe entire response from the external service we used with the function.

For this article, we’ll focus just on using the Recommended options to make things nice and simple. We’ll talk more about All data in our Intermediate course.


Recommended rows enrich a singular row with some data from the response. This can be, for example, the latitude and longitude of a place, the email and confidence score for a person, or the phone number for a company.

Let’s try to insert one!

  1. In cell C2 (where we previously entered our Crunchbase function), click on the Data Explorer icon-data-explorer icon.
  2. Select Company info.
  3. Choose where to insert the data and press enter.

❇️ Done! You should see some data about Apple!



Recommended tables create a whole table with column headers and all that jazz. Depending on the function, you’ll see one or more recommended tables to choose from.

Let's try it out:

  1. In cell C2, click on the Data Explorer icon-data-explorer icon.
  2. Select the Funding Rounds recommended table.
  3. Choose Overwrite.
  4. Choose where to insert it in your table and press enter.

❇️ Done! And look at all that data!

If you change Apple to Feedzai in cell A2 and press Enter, you’ll see that the table automatically updates with new data from Crunchbase. Pretty cool, right?


Table options

Now, you might be wondering what those table options were:


Use UPDATE + INSERT if, each time you execute the function, you’d like existing rows to be updated and new ones to be added.

Update example



Use INSERT if, each time you execute the function, you want the data to be appended to the table. Great if you want a constant log.

Insert example


kb-overwrite (1)

Use OVERWRITE if, each time you execute the function, you want all the data in the table to be rewritten. Really handy if you’re doing benchmarking.

Overwrite example



As you can see, all you need to do to get data out of an integration function is just click and point (we’ll cover how to make custom tables in Rows Intermediate, but for now, you’re golden).

More for Beginners

Instead of creating all these things from scratch each time, wouldn’t it be easier just to use a template to kick start an idea? Well, you’re in luck - we’ve thought of that. Check the rest of our Rows for Beginners series:

  1. Refresh the spreadsheet basics
  2. Using integrations
  3. Working with data (you're here)
  4. Installing templates: Up next! 🚀
  5. Collaborating in workspaces
  6. Making your spreadsheet go Live!