Google Sheets Connector > Introduction to Google Sheets Connector > Google Sheets Connector supported objects and task operations
  

Google Sheets Connector supported objects and task operations

You can perform insert, update, and delete operations on a Google Sheets target. You cannot perform upsert operations on a Google Sheets target.
The following table lists the Google Sheets Connector object types that you can include in Data Integration tasks:
Task Type
Source
Target
Lookup
Data Preview
Synchronization
Yes
Yes
Yes
Yes
Mapping
Yes
Yes
Yes
Yes
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