Get Rows
Read rows. Header row supplies column names (DataTable). Optional lookup filters by a column value.
Overview
Get Rows is a no-code automation step in the Google Sheets category of AutoFlowRPA. It performs its action in a single step when the workflow reaches it. You can configure 9 parameter(s) to control exactly how it behaves. It is one of 369 commands you can drag into a workflow in the visual builder — no scripting required.
What it does
Read rows. Header row supplies column names (DataTable). Optional lookup filters by a column value.
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| Connection name | variable | Required | sheets | Name of the connection created by Authorize. |
| Spreadsheet (ID or URL) | string | Required | Spreadsheet ID, or paste the full Sheets URL. Example: 1AbC...xyz Supports variables | |
| Sheet/tab name | string | Required | Sheet1 | Example: Sheet1 Supports variables |
| Header row number | number | Optional | 1 | |
| Return as | dropdownDataTable (header keys) · Raw rows (list of lists) | Optional | DataTable (header keys) | |
| Lookup column (optional) | string | Optional | Return only rows where this column equals the value. Supports variables | |
| Lookup value (optional) | string | Optional | Supports variables | |
| Max rows (optional) | number | Optional | ||
| Store result in | variable | Required | Example: rows |
How to use Get Rows
- 1
Open AutoFlowRPA and drag the Get Rows command from the Google Sheets group onto the canvas.
- 2
Set its parameters in the side panel — Get Rows has 9 configurable field(s).
- 3
Connect it into your workflow and press Run. Everything executes locally on your machine.
Frequently asked questions
What does the Get Rows command do?
Read rows. Header row supplies column names (DataTable). Optional lookup filters by a column value.
Which group does the Get Rows command belong to?
Get Rows is part of the Google Sheets group. AutoFlowRPA ships with 369+ ready-made commands you can combine without code.
Does the Get Rows command take any parameters?
Yes — Get Rows has 9 configurable field(s), all editable in the visual node editor.
More Google Sheets commands
Ready to automate your busywork?
Start your free 30-day trial today. No credit card, no commitment.