gspreadsheet

Get the next new group rows according to a value

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

Google Sheets Trigger


Automating tasks with Google Sheets is now easier thanks to Botize's integration. This tool allows you to extract groups of rows from a spreadsheet based on specific criteria, facilitating efficient data management and analysis.

With customization options such as sheet selection, number of rows to extract, and filter configuration, you can tailor the automation to your specific needs. Additionally, the integration provides detailed information about the extracted rows, enabling their use in other automated tasks within Botize.







Customization Options

Configurable fields you can adjust in your automation

  • URL of your sheet document
  • Exclude first row
  • Fast! Improve speed by not processing spreadsheet formulas
  • Total rows to extract
  • How to select sheet
  • Sheet Number
  • Sheet name
  • Column letter to filter by
  • Filters configuration
  • Restart rules



Information provided

When executed, this operation delivers the following data, which can be used in the same automatic task.

  • Tags

  • A:1st {{column_a.0}}

  • B:1st {{column_b.0}}

  • C:1st {{column_c.0}}

  • D:1st {{column_d.0}}

  • E:1st {{column_e.0}}

  • F:1st {{column_f.0}}

  • G:1st {{column_g.0}}

  • H:1st {{column_h.0}}

  • I:1st {{column_i.0}}

  • J:1st {{column_j.0}}

  • K:1st {{column_k.0}}

  • L:1st {{column_l.0}}

  • M:1st {{column_m.0}}

  • N:1st {{column_n.0}}

  • O:1st {{column_o.0}}

  • P:1st {{column_p.0}}

  • Q:1st {{column_q.0}}

  • R:1st {{column_r.0}}

  • S:1st {{column_s.0}}

  • T:1st {{column_t.0}}

  • U:1st {{column_u.0}}

  • V:1st {{column_v.0}}

  • W:1st {{column_w.0}}

  • X:1st {{column_x.0}}

  • Y:1st {{column_y.0}}

  • Z:1st {{column_z.0}}

  • 1st Row Number {{row.0}}

  • A:2nd {{column_a.1}}

  • B:2nd {{column_b.1}}

  • C:2nd {{column_c.1}}

  • D:2nd {{column_d.1}}

  • E:2nd {{column_e.1}}

  • F:2nd {{column_f.1}}

  • G:2nd {{column_g.1}}

  • H:2nd {{column_h.1}}

  • I:2nd {{column_i.1}}

  • J:2nd {{column_j.1}}

  • K:2nd {{column_k.1}}

  • L:2nd {{column_l.1}}

  • M:2nd {{column_m.1}}

  • N:2nd {{column_n.1}}

  • O:2nd {{column_o.1}}

  • P:2nd {{column_p.1}}

  • Q:2nd {{column_q.1}}

  • R:2nd {{column_r.1}}

  • S:2nd {{column_s.1}}

  • T:2nd {{column_t.1}}

  • U:2nd {{column_u.1}}

  • V:2nd {{column_v.1}}

  • W:2nd {{column_w.1}}

  • X:2nd {{column_x.1}}

  • Y:2nd {{column_y.1}}

  • Z:2nd {{column_z.1}}

  • 2nd Row Number {{row.1}}

  • A:3rd {{column_a.2}}

  • B:3rd {{column_b.2}}

  • C:3rd {{column_c.2}}

  • D:3rd {{column_d.2}}

  • E:3rd {{column_e.2}}

  • F:3rd {{column_f.2}}

  • G:3rd {{column_g.2}}

  • H:3rd {{column_h.2}}

  • I:3rd {{column_i.2}}

  • J:3rd {{column_j.2}}

  • K:3rd {{column_k.2}}

  • L:3rd {{column_l.2}}

  • M:3rd {{column_m.2}}

  • N:3rd {{column_n.2}}

  • O:3rd {{column_o.2}}

  • P:3rd {{column_p.2}}

  • Q:3rd {{column_q.2}}

  • R:3rd {{column_r.2}}

  • S:3rd {{column_s.2}}

  • T:3rd {{column_t.2}}

  • U:3rd {{column_u.2}}

  • V:3rd {{column_v.2}}

  • W:3rd {{column_w.2}}

  • X:3rd {{column_x.2}}

  • Y:3rd {{column_y.2}}

  • Z:3rd {{column_z.2}}

  • 3rd Row Number {{row.2}}




Write us

By email or by Telegram.
Monday to Friday from 7 a.m. to 1 p.m. (Spain).

Let's talk

Choose day and time.
We share the screen and answer all your questions.