When you use Google Sheets Connector, you can include the following
Data Integration
assets:
Mapping
Mapping
task
Synchronization
task
You can perform insert, update, and delete operations on a Google Sheets target. You cannot perform upsert operations on a Google Sheets target.
The standard objects are the Sheet Names that are present in the spreadsheet. The Sheet Names are dynamic and fetched automatically during data preview.
The following table lists the objects and task operations that Google Sheets Connector supports for Sheet Names object:
Read
Insert
Update
Upsert
Delete
Yes
Yes
Yes
NA
Yes
For more information about configuring assets and transformations, see