Process data from Google spreadsheets. Requires JSON credentials from the Google dev console.

GoogleSpreadsheetReader Properties

  • credential (Env First): The Google credential with permissions to the Google service.
  • spreadsheetId (Inline Only): The Google Spreadsheet Id for the spreadsheet.
Example with Environment Credentials
-
    name: myConnectorName
    type: GoogleSpreadsheetReader
    properties:
      spreadsheetId:  23r3242  # optional 
    #schemaRef: schemaName # optional from "schemas:"
Example with Inline Credentials
-
    name: myConnectorName
    type: GoogleSpreadsheetReader
    properties:
      credential: jsonValue 
      spreadsheetId: 23r3242  # optional 
    #schemaRef: schemaName # optional from "schemas:"

GoogleSpreadsheetWriter Properties

  • credential (Env First): The Google credential with permissions to the Google service.
  • sheetName (Inline Only): The sheet name of the spreadsheet.
  • spreadsheetId (Inline Only): The Google Spreadsheet Id for the spreadsheet.
Example with Environment Credentials
-
    name: myConnectorName
    type: GoogleSpreadsheetWriter
    properties:
      sheetName:  mySheetName 
      spreadsheetId:  23r3242  # optional 

Example with Inline Credentials
-
    name: myConnectorName
    type: GoogleSpreadsheetWriter
    properties:
      credential:  jsonValue 
      sheetName:  mySheetName 
      spreadsheetId:  23r3242  # optional