Google Sheets Connector

Google Sheets Connector

Rules and guidelines for Google Sheets targets

Rules and guidelines for Google Sheets targets

Consider the following rules and guidelines when you write data to a Google Sheets target:
  • When you perform an insert operation on a Google Sheets target, you must configure a data filter for the following Google Sheets source fields:
    Field Name
    Operator
    Data Type
    Example
    range
    =
    String
    range = A1:B2
    majorDimension
    =
    String
    majorDimension = ROWS
    valueInputOption
    =
    String
    valueInputOption = USER_ENTERED
  • When you perform a delete operation on a Google Sheets target, you must configure a data filter for the
    range
    field in the Google Sheets source.