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.

Start automating See how it's set up

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.

How it works

How it fits in an automated task

A Botize task pairs a trigger with one or more actions. This piece is one of them.

This is the trigger

Every time this event happens, the task kicks off on its own. You don't have to do anything.

Add one or more actions

What should happen next, in this app or in any of the 200+ connectable apps.

Turn it on and forget it

The task runs on its own from then on. If something's off, tweak it or we'll help you.

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/botize
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