Read Sheet

Read the all data from google sheet.

Read the contents of the specified 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.

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

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

• Include Headers:

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

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

Output

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