Google Sheets V2 Connector > Mappings and mapping tasks with Google Sheets V2 Connector > Google Sheets V2 targets in mappings
  

Google Sheets V2 targets in mappings

To write data to a Google Sheets target, configure a Google Sheets object as the Target transformation in a mapping or mapping task.
You can switch mappings to advanced mode to include transformations and functions that enable advanced functionality.
Specify the name and description of Google Sheets target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for a Google Sheets target:
Property
Description
Connection
Name of the Google Sheets V2 target connection.
Target Type
Type of the Google Sheets target objects available.
You can write data to a single Google Sheets target object. You cannot write data to multiple objects or parameterize the object.
Object
Name of the Google Sheets target object based on the target type selected.
Operation
You can select one the following operations:
  • - Insert
  • - Update
  • - Delete
The following table describes the advanced properties that you can configure for a Google Sheets target:
Property
Description
Initial Column Range
Specifies the first column name from a data range in a Google Sheets spreadsheet from where you want to start writing the data.
Final Column Range
Specifies the last column name from a data range in a Google Sheets spreadsheet from where you want to stop writing the data.
Success File Directory
Not applicable.
Error File Directory
Not applicable.
Forward Rejected Rows
Not applicable.