Apps/Google Sheets/Get the next new group rows according to a value
Google Sheets
Google Sheets Trigger

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.

200+ apps to connect·Tested & maintained tasks·Human support in English & Spanish

In detail

What it does and what it's for

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.

Already using Botize?

Connect your Google Sheets

Add a profile to use it in your tasks. There's a step-by-step guide if you need it.

Add a new profile Step-by-step guide

Your profiles

Your connected Google Sheets accounts

These are the accounts you already have linked to Botize, ready to use in your tasks. You can reconnect or remove any of them.

Setup

Customization options

Fields you can adjust when using it 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

Output data

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}}

Learn by watching

Video tutorials

Short videos where you watch a real task being built from start to finish.

Need a hand?

Real people behind it

Email us

info@botize.com
Monday to Friday from 7 a.m. to 1 p.m. (Spain).

Message us on Telegram

t.me/botizesupport
Monday to Friday from 7 a.m. to 1 p.m. (Spain).

Come with an idea.
Leave with an automation.

Create your first task in minutes. Do it once and forget about it forever.

Start automating