📝 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:ADirection: 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
↩️ How to Use the “Loop” Function in Yoom - View Guide Here
Search Keywords
Search Keywords
Spreadsheet, repeat the same process, loop, unique value, loop processing, more than 10, Google Sheets, Retrieve Record, Retrieve Value