Email Templates (Full Update)
Description
See the Aerial Spec for more details.
File Naming Convention
TGEN_emailTemplates_fullupdate_2026-08_<optionalSuffix>.csv
importType:fullupdateapiVersion:2026-08
Columns
Nested object fields are flattened into columns using dot notation (parent.child). Array fields are flattened using zero-based index notation, one element per column (field[0], field[1], and so on).
Note: A whole array cannot be passed in a single column: a literal value such as ['value-1','value-2'] will be rejected. To import multiple array elements, add one indexed column per element. Rows in the table below with type array describe the field as a whole and are not valid CSV column headers.
| Column Header | Description | Key Information | Type | Required |
|---|---|---|---|---|
externalId | Integrator provided unique identifier for the template. Typically used to map a primary key from a third party system to the Tulip resource. | Max Length: 32 | string | No |
subject | Subject of the template | Max Length: 160 | string | No |
name | Name of the template | Max Length: 160 | string | No |
content | HTML Document for the structure of the template | string | No | |
languageCode | The language code of the template | Max Length: 5 | string | No |
defaultText | Default Content for the template (to replace the {{content}} tag in the structure) | string | No | |
thumbnailUrl | URL for the email template thumbnail | string | No | |
category | The category in which the email template belongs | Max Length: 36 | string | No |
stores | List of associated store UUIDs | Not a CSV column header. Pass each array element in its own indexed column (stores[0], stores[1], and so on). | array | No |
stores[0] | Array element | string | No | |
storeGroup | N/A | mixed | No | |
storeGroup.externalId | The external identifier of the store group | string | No | |
storeGroup.type | Type of the store group | mixed | No | |
storeGroup.name | Name of the store group | string | No | |
storeGroup.description | Description of the store group | string | No | |
storeGroup.rules | Rules for membership in the store group. Valid keys: countryCode, disabled, district and storeType | object | No | |
isGlobal | Determines the visibility scope of the template. If true, the template is ‘Global’ and accessible by all stores automatically. If false, the template’s visibility is restricted to specific store or group assignments (if any). | boolean | No |
Sample CSV
See the following emailTemplates CSV sample file.
Note: The sample CSV may contain sample ID fields which reference other resources that do not match the data in your environment.