Create assets in Data Integration to integrate data using Google Sheets Connector.
You can perform insert, update, and delete operations on a Google Sheets target. You cannot perform upsert operation on a Google Sheets target.
When you use Google Sheets V2 Connector, you can include the following Data Integration assets:
•Mapping
•Mapping task
The standard objects are the Sheet Names that are present in the Google Sheets spreadsheet. The Sheet Names are dynamic and fetched automatically during data preview.
You can perform the following operations on the spreadsheet object in Google Sheets V2 Connector: