Skip to content

Read Column Values

Using the Read Column Values action in a flow will let you read the values of a column in the selected range of a sheet from the connected Google Drive.


  1. Name - By default, it is prefilled by the name of the action. You can change it based on your preferred action name.
  2. Connection - Your selected Google Drive connection. Note that you have to select the connection where you have access to read the Google Sheet file you will select later.
  3. File - The Google Sheet that you want to read the column values.
  4. Sheet Name - The name of the sheet where the column values you want to be read is under.
  5. Unformatted Values - If enabled, it will indicate that the values should be represented as unformatted.
  6. Range - If enabled, return all rows in the sheet.
  7. Start Row - The row number to start from reading.
  8. End Row - The row number where reading will be read.
  9. Has Header - If enabled, will treat the first row as the Sheet's header.
  10. Column - The selected column where its values will be read.

Demonstration on how to use it in a flow

  1. Drag and drop the Read Column Values action into the flow.
  2. Click the gear icon to open its settings. Google Docs Template
  3. Click the Connection dropdown list and select a particular Google Drive connection Google Docs Template Google Docs Template

    Or you can set up a new Google Drive connection by clicking the “Add Connection” icon. Google Docs Template

  4. Select the Google Sheet file. To do it, click the “Google Drive” icon under the File field.

  5. Navigate to the location of the folder and select the file.
  6. Then, click the “Select” button. Google Docs Template
  7. Select the sheet name where the column and its values you want to read are under. To do it, click the Select Sheet icon and choose from the available options on the dropdown list. Then, click "Done".
    Google Docs Template Google Docs Template Google Docs Template
    Note: If the value on the row/s doesn't have any format, it is best for you to enable the Unformatted Values option.
    Note: If all the rows on the sheet have to be read and returned, it is best for you to enable the Range option.
    Note: If the column/s on the sheet has column header, it is best for you to enable the Has Header option then click the "Load Columns" button to load the available column header on the sheet.
    Google Docs Template
  8. Select the Column that you want to read the values. Google Docs Template