Automatically if it contains rows, select the next x rows

Google Sheets

Trigger

Extract 2 by 2 or 3 by 3 rows sequentially.


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.