Skip to main content
Go to the Studio
Spreadsheets

For Each Column

For Each Column

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


Options​

Sheet name​

Enter the sheet whose columns will be gone through.

Initial column of the spreadsheet​

Indicates the column where the action starts going through the spreadsheet columns. By default it starts on column A.

Final column of the spreadsheet​

Indicates the column where the action stops going through the spreadsheet columns. By default, the last column of the spreadsheet is column A.

Returns​

  • Current column position — Returns the position of the column being processed in the iteration.

Rules and Conditions​

  • The Spreadsheet and Sheet name fields are required.