Read Range

Read the range of contents in google sheet

Read the contents of the specified range in sheet from the google sheets.

This activity can only be used after the Create GSuite Connection Activity.

Input

• Credential: Object Variable A variable name that references the user credential to access the resources.

• Sheet Name: String Argument The name of the sheet to be read.

• Range: String Argument The range of the sheet to be read.

• SpreadSheet Id: String Argument The Id of the spreadsheet to be read.

• Include Headers:

  • True - column headers from the specified sheet range will be extracted.

  • False - column headers from the specified sheet range will not be extracted.

Output

• Sheet DataTable: DataTable Variable The DataTable variable that stores the data extracted from the specified excel range.