gspreadsheet

Extract the next new row according to a value (Deprecated)

Extract one by one, sequentially, each row of a sheet where a certain column has a specific value, such as a number, a text, empty value, etc.

Google Sheets Trigger


This integration allows you to automate the sequential extraction of rows in a Google Sheets spreadsheet based on the value of a specific column. You can configure advanced filters to limit the search to a specific sheet or all sheets, and exclude the first data row if necessary. Additionally, you have the option to improve processing speed by choosing not to process the sheet's formulas.

When executing this operation, you will obtain tags representing each column of the sheet, such as , , etc., as well as the row number and the sheet name . These tags can be used in the same automated task to further customize your processes. For more details and assistance, you can contact us by email or via Telegram from Monday to Friday between 7h and 13h (Spain).



  • You can limit the search of the rows to a specific sheet or to all of them.







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
  • Filter rows based on column values
  • Advanced filters
  • When the document reaches the end
  • Sheet
  • Sheet Number
  • Sheet name



Information provided

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

  • Tags

  • Column A {{column_a}}

  • Column B {{column_b}}

  • Column C {{column_c}}

  • Column D {{column_d}}

  • Column E {{column_e}}

  • Column F {{column_f}}

  • Column G {{column_g}}

  • Column H {{column_h}}

  • Column I {{column_i}}

  • Column J {{column_j}}

  • Column K {{column_k}}

  • Column L {{column_l}}

  • Column M {{column_m}}

  • Column N {{column_n}}

  • Column O {{column_o}}

  • Column P {{column_p}}

  • Column Q {{column_q}}

  • Column R {{column_r}}

  • Column S {{column_s}}

  • Column T {{column_t}}

  • Column U {{column_u}}

  • Column V {{column_v}}

  • Column W {{column_w}}

  • Column X {{column_x}}

  • Column Y {{column_y}}

  • Column Z {{column_z}}

  • Number of Row (DEPRECATED) {{row_number}}

  • Number of Row {{row}}

  • Sheet name {{sheet}}




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.