Skip to main content

Read From SpreadSheet

This connector is used when reading data from google sheets.

Settings​

  • Authentication: A valid google credential item
  • File Location: The folder where the spreadsheet to be read from is located.
  • Select Spreadsheet: The spreadsheet containing the data to be read
  • Select Sheet: The sheet within the spreadsheet to be read.

Header Settings​

These settings apply only to the header of the sheet.

  • Replace Spaces with Underscores: This removes spaces in the header name and replaces them with underscores. e.g. "Month Of the Year" becomes "Month_Of_the_Year".
  • Remove dots?: This removes dots from the header name. e.g. "Phone No." becomes "Phone No".
  • Convert to lowercase: This converts the header to lowercase characters.

Output​

The output is an array of Objects containing the content of the selected sheet.