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 guideYour 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.
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