Read Google Sheet Rows

This action will let you read one or more rows on a sheet from a Google Sheets.

Fields

  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 view, edit, create, or delete files.
  3. File - The Google Sheets where the row will read from.
  4. Sheet Name - The particular sheet where the row will be read from.
  5. Unformatted Values - If enabled, it will indicate that the values should be represented as unformatted.
    Row
  6. Range - If enabled, returns all rows in the sheet.
  7. Start Row - The row number where reading will start.
  8. End Row - The row number where reading will end.

Column

  1. Has Header - If enabled, will treat the first row as the sheet's header.
  2. Column - The available columns with data. You may delete the column you don't want to be read.
  3. Name - The header name of the column.

Demonstration on how to use it in a flow

  1. Drag and drop the Read Rows action into the flow.
  2. Click the gear icon to open its settings.

  1. Click the Connection dropdown list and select a particular Google Drive connection
  2. Or you can set up a new Google Drive connection by clicking the “Add Connection” icon.
  3. Select the Google Sheets file. To do it, click the “Google Drive” icon under the File field.
  4. Navigate to the file then select it.
  5. Click the “Select” button.

  1. Select the particular sheet where the row will be read from. To do it, click the Select Sheet icon and choose from the available options on the dropdown list then, click "Done".

📘

Note:

  • If the value on the row/s doesn't have any format, it is best for you to enable the Unformatted Values option.
  • If all the rows on the sheet have to be read and returned, it is best for you to enable the Range option.
  • If the column/s on the sheet has a 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.

Result

Upon executing this flow, all of the rows that contain data will be read on columns (1) Employee ID, (2) Name, (3) Total Working Days, (4) Salary Per Day, and (5) Total Salary.