Read column action in Google Sheets

Use the Read column action in the Google Sheets package to retrieve data from a column and store it in a list variable.

Settings

  • Enter the name of the session used to open the current spreadsheet with the Open spreadsheet action.
  • In the Cell options field, specify the cell location from which to read the values. For example, enter A5 to retrieve all the values located in the first column, below the fifth row.
  • You can also select the Read full column option to extract values from the entire column.
  • Select or create a list variable to hold the output.