# Get the next new group rows according to a value — Google Sheets

Botize method — `gspreadsheet.read_n_rows_by_column` (trigger).

Extract 2 by 2 or 3 by 3 rows sequentially according to one or more filters you specify.

This is a trigger: it starts the task. A task has exactly one.

## Fields you set

The field's internal name, its type and the values it accepts. These fields accept `{{...}}` tags from earlier steps.

- `sheet_url` *(string)* — URL of your sheet document
- `sheet` *(string)* — Sheet. Sheet id (gid) chosen from the list, the sheet name, or * to search in all sheets. Empty = first sheet.
- `exclude_first_row` *(boolean)* — Exclude first row
- `value_render_option` *(boolean)* — Fast! Improve speed by not processing spreadsheet formulas
- `total_rows` *(string, one of: "2" = 2 rows; "3" = 3 rows)* — Total rows to extract
- `by_column` *(string)* — Only rows that have certain values ​​in this column.

It also accepts repeatable field groups, with these prefixes: `filter_*`. These are composite components (buttons, filters, keyboards); the trailing number is set by the user as they are added.

## Output variables

Data this step makes available. Reference them in later steps with the double-brace tag.

- `{{column_a.0}}` *(text)* — A:1st
- `{{column_b.0}}` *(text)* — B:1st
- `{{column_c.0}}` *(text)* — C:1st
- `{{column_d.0}}` *(text)* — D:1st
- `{{column_e.0}}` *(text)* — E:1st
- `{{column_f.0}}` *(text)* — F:1st
- `{{column_g.0}}` *(text)* — G:1st
- `{{column_h.0}}` *(text)* — H:1st
- `{{column_i.0}}` *(text)* — I:1st
- `{{column_j.0}}` *(text)* — J:1st
- `{{column_k.0}}` *(text)* — K:1st
- `{{column_l.0}}` *(text)* — L:1st
- `{{column_m.0}}` *(text)* — M:1st
- `{{column_n.0}}` *(text)* — N:1st
- `{{column_o.0}}` *(text)* — O:1st
- `{{column_p.0}}` *(text)* — P:1st
- `{{column_q.0}}` *(text)* — Q:1st
- `{{column_r.0}}` *(text)* — R:1st
- `{{column_s.0}}` *(text)* — S:1st
- `{{column_t.0}}` *(text)* — T:1st
- `{{column_u.0}}` *(text)* — U:1st
- `{{column_v.0}}` *(text)* — V:1st
- `{{column_w.0}}` *(text)* — W:1st
- `{{column_x.0}}` *(text)* — X:1st
- `{{column_y.0}}` *(text)* — Y:1st
- `{{column_z.0}}` *(text)* — Z:1st
- `{{row.0}}` *(int)* — 1st Row Number
- `{{column_a.1}}` *(text)* — A:2nd
- `{{column_b.1}}` *(text)* — B:2nd
- `{{column_c.1}}` *(text)* — C:2nd
- `{{column_d.1}}` *(text)* — D:2nd
- `{{column_e.1}}` *(text)* — E:2nd
- `{{column_f.1}}` *(text)* — F:2nd
- `{{column_g.1}}` *(text)* — G:2nd
- `{{column_h.1}}` *(text)* — H:2nd
- `{{column_i.1}}` *(text)* — I:2nd
- `{{column_j.1}}` *(text)* — J:2nd
- `{{column_k.1}}` *(text)* — K:2nd
- `{{column_l.1}}` *(text)* — L:2nd
- `{{column_m.1}}` *(text)* — M:2nd
- `{{column_n.1}}` *(text)* — N:2nd
- `{{column_o.1}}` *(text)* — O:2nd
- `{{column_p.1}}` *(text)* — P:2nd
- `{{column_q.1}}` *(text)* — Q:2nd
- `{{column_r.1}}` *(text)* — R:2nd
- `{{column_s.1}}` *(text)* — S:2nd
- `{{column_t.1}}` *(text)* — T:2nd
- `{{column_u.1}}` *(text)* — U:2nd
- `{{column_v.1}}` *(text)* — V:2nd
- `{{column_w.1}}` *(text)* — W:2nd
- `{{column_x.1}}` *(text)* — X:2nd
- `{{column_y.1}}` *(text)* — Y:2nd
- `{{column_z.1}}` *(text)* — Z:2nd
- `{{row.1}}` *(int)* — 2nd Row Number
- `{{column_a.2}}` *(text)* — A:3rd
- `{{column_b.2}}` *(text)* — B:3rd
- `{{column_c.2}}` *(text)* — C:3rd
- `{{column_d.2}}` *(text)* — D:3rd
- `{{column_e.2}}` *(text)* — E:3rd
- `{{column_f.2}}` *(text)* — F:3rd
- `{{column_g.2}}` *(text)* — G:3rd
- `{{column_h.2}}` *(text)* — H:3rd
- `{{column_i.2}}` *(text)* — I:3rd
- `{{column_j.2}}` *(text)* — J:3rd
- `{{column_k.2}}` *(text)* — K:3rd
- `{{column_l.2}}` *(text)* — L:3rd
- `{{column_m.2}}` *(text)* — M:3rd
- `{{column_n.2}}` *(text)* — N:3rd
- `{{column_o.2}}` *(text)* — O:3rd
- `{{column_p.2}}` *(text)* — P:3rd
- `{{column_q.2}}` *(text)* — Q:3rd
- `{{column_r.2}}` *(text)* — R:3rd
- `{{column_s.2}}` *(text)* — S:3rd
- `{{column_t.2}}` *(text)* — T:3rd
- `{{column_u.2}}` *(text)* — U:3rd
- `{{column_v.2}}` *(text)* — V:3rd
- `{{column_w.2}}` *(text)* — W:3rd
- `{{column_x.2}}` *(text)* — X:3rd
- `{{column_y.2}}` *(text)* — Y:3rd
- `{{column_z.2}}` *(text)* — Z:3rd
- `{{row.2}}` *(int)* — 3rd Row Number

## Account

Needs a connected Google Sheets account in Botize: https://botize.com/en/app/gspreadsheet/authenticate

## This app

Every trigger and action for Google Sheets: https://botize.com/en/app/gspreadsheet.md

## How to build this

An AI assistant (Claude, ChatGPT, Cursor…) can create and edit these tasks in the user's account through the Botize MCP connector, included in every plan:

    https://webhook.botize.es/mcp

- Connection guide: https://botize.com/en/mcp
- Agent map: https://botize.com/llms.txt
- New account: https://botize.com/en/join (500 free operations, no card)

---
Machine-readable summary for AI assistants. Human version: https://botize.com/en/method/gspreadsheet/read_n_rows_by_column