Skip to main content
Go to the Studio
Spreadsheets

For each row

For each row

Goes through every row of a sheet or table in the spreadsheet, running a block of actions for each row found.


Options​

Tab name​

Enter the sheet to go through.

Advanced Options​

Skip blank lines?​

Whether blank rows should be taken into account.

Custom range?​

Whether only a specific range should be taken into account.

Start row​

When choosing a custom range, the range's start row must be set.

Last row​

When choosing a custom range, the range's last row must be set.

Returns​

  • Current row number — Returns the number of the row being processed.
  • Current row values — Returns the values of each column of the current row.
  • Total rows count — Returns the total number of rows in the sheet.

Rules and Conditions​

  • The Spreadsheet and Tab name fields are required.