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

Google Sheets targets in mappings and mapping tasks

To write data to a Google Sheets target, configure a Google Sheets object as the Target transformation in a mapping or mapping task.
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 active Google Sheets connection that is associated with a dataset.
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
  • - Upsert
  • - Delete
  • - Data Driven
The following table describes the advanced properties that you can configure for a Google Sheets target:
Property
Description
Success File Directory
Not applicable for Google Sheets Connector.
Error File Directory
Not applicable for Google Sheets Connector.
Forward Rejected Rows
Not applicable for Google Sheets Connector.