Read row action in Google Sheets

Use the Read row action in the Google Sheets package to retrieve data from a row 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 D5 to retrieve the values located in the fifth row and right of the fourth column.
  • You can also select the Read full row option to extract values from the entire row.
  • Select or create a list variable to hold the output.