Skip to main content
All Collections🔍 Yoom FAQ & Tips CollectionFlowbotFAQ・Tips about Others
How to Retrieve More than 10 Rows from a Spreadsheet
How to Retrieve More than 10 Rows from a Spreadsheet

As of Dec 25, 2023

Yoom Customer Service avatar
Written by Yoom Customer Service
Updated this week

📝 Overview

In Yoom, you can use the "Retrieve multiple rows (records)" action, which is available in the database manipulation tools, to retrieve multiple rows of data at once.

However, there is a limit to how many rows you can retrieve, with a maximum of 10 rows for spreadsheets or Excel.

In this guide, we’ll show you how to retrieve more than 10 rows from a spreadsheet.

Below is an example of the completed Flowbot up to the point where it retrieves multiple rows.


🛠️ How to Set Up

1. Prepare your Spreadsheet

Start by preparing the spreadsheet you want to use. For this example, we’ll use a spreadsheet that contains three columns, including an ID column, as shown below.

2. Retrieve Columns Containing Unique Values

You’ll first need to retrieve all columns that contain unique values.

To do this:

  • App: Google Sheets

  • Action: Retrieve values

  • Spreadsheet ID / Sheet Name: Specify the spreadsheet and sheet name

  • Range: Choose the column with unique values (e.g., IDs).
    For this example, it’s A2:A

  • Direction: Column direction

☝️ Note:

This step will only work if the column contains unique values. If there are no unique values, the operation cannot proceed.

3. Break Down the Retrieved Unique Values

Once you’ve retrieved the unique values, you need to break them down individually. Use the following operation:

  • Action: Loop

  • Operation to set: Retrieve values (as configured in step 2)

  • Output: The values retrieved in step 2

For more details on the Loop Command, please refer to this link.

4. Retrieve the Corresponding Rows Using the Unique Values

Now, you’ll retrieve the rows corresponding to the unique values you broke down earlier.

Use this operation:

  • App: Google Sheets

  • Action: Retrieve Record

  • Spreadsheet ID / Sheet Name: Specify your spreadsheet

  • Range: Select all ranges, including column names (e.g., A1:C)

  • Search Condition: Unique value (e.g., ID)

  • Search Symbol: “Equals” or “=” (for this example, “Equals”)

  • Search Field: ##{{○○ loop variable}}

☝️ Note:

To select the search field, click it, then choose “Repeat the same process” from the output menu, and select the “○○ loop variable” within it.

That’s how you can retrieve more than 10 rows from a spreadsheet! 🎉

🗂️ Flowbot Templates

We’ve created a Flowbot template for this example. Feel free to copy and use it for your own flows.

📚 Related Guides

Search Keywords

Spreadsheet, repeat the same process, loop, unique value, loop processing, more than 10, Google Sheets, Retrieve Record, Retrieve Value

Did this answer your question?