Rules and guidelines for Google Sheets targets
Consider the following rules and guidelines when you write data to a Google Sheets target:
- •When you perform an insert operation on a Google Sheets target, you must configure a data filter for the following Google Sheets source fields:
Field Name | Operator | Data Type | Example |
|---|
range | = | String | range = A1:B2 |
majorDimension | = | String | majorDimension = ROWS |
valueInputOption | = | String | valueInputOption = USER_ENTERED |
- •When you perform a delete operation on a Google Sheets target, you must configure a data filter for the range field in the Google Sheets source.