Google Sheets Connector

Back Next

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 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.