The safest way to let a teammate update an After Effects template is to take the composition away from them. Give them a spreadsheet instead. When every changing piece of the video is wired to a column, the person updating it edits cells, and the project file stays exactly as the designer left it.
This article is about setting that up with Templater. It covers how to name layers so they match columns, which layer types can take data, how to let the layout absorb a longer name without anyone touching a keyframe, and how to write the one-page note that makes the hand-off work. It also says plainly where this approach stops, because there are edits a spreadsheet cannot make.
Put the editing in the data, not the comp
An After Effects project is a fragile place to hand to someone else. Layers sit on top of layers. Expressions refer to other layers by name. A text box that looks fine at twelve characters falls apart at thirty. The designer who built it knows which parts are load-bearing. A teammate opening the file for the first time does not, and one stray rename can change what a render looks like.
Templater moves the changeable parts out of the file. You mark certain layers as dynamic, you give each one a name that matches a column header or a JSON property key in your data source, and Templater fills those layers from each row when it previews, renders or replicates. Dataclay’s documentation describes the mechanism in those terms. Data is mapped to layers by applying the Templater Settings effect to a layer and matching the layer name to the column header. Each row then produces one version of the composition.
That gives you a clean division of work. The designer owns the composition. The teammate owns the rows. Nobody has to learn the other person’s tool. The teammate who updates a price, a headline or a name only needs a spreadsheet, a Google Sheet, a JSON file, or a Dataclay Que feed, because Dataclay’s own docs say property keys in JSON objects are equivalent to column names in a spreadsheet.
The design decision underneath this is simple. Before you build anything, ask which parts of the video a teammate will need to change next month. Those parts become dynamic layers. Everything else stays locked inside the composition, out of reach, because nothing in the data source points at it.
Setup process
Five steps to wire a template to a spreadsheet
-
Decide which layers are dynamicAsk which parts of the video a teammate will need to change next month.
-
Name each layer for the sheet readerAssign each dynamic layer a unique name that corresponds to a column name or property key in your data source.
-
Apply the Templater Settings effect onceApply the Templater Settings effect to each dynamic layer once.
-
Set layout rules per layerUse Scale Factor and alignment rules in the Templater Settings effect so layers absorb longer text without anyone touching a keyframe.
-
Write the column guideGive the teammate a list of the columns and what each one changes on screen, the header rules, what each cell expects, and who owns the composition.
Build the template so the sheet is hard to get wrong
The names you choose are the interface your teammate will see every day. They appear as column headers. So name layers for the person reading the sheet, not for the person building the project.
Dataclay’s mapping page gives the basic rule. Assign each dynamic layer a unique name that corresponds to a column name or property key in your data source. The example it uses is a text layer for an introductory title, named introTitle. The page adds that you should pick something easily recognizable and should not use spaces in layer names. The same page says the name is easier to work with in your data source when it is recognizable, and a spreadsheet full of cryptic names makes the teammate guess which column controls which line on screen.
Two traps in that same page catch a careful designer. The first is that a layer must be explicitly renamed after you create it, even if the name it was given at creation is already the same as the column header. The page warns that if you do not explicitly rename a layer, Templater may not process it as dynamic. So type the name in again, press Enter, and confirm it saved. The second is that the Templater Settings effect goes on each dynamic layer once. Applying it twice to one layer produces unexpected results according to the same page, and a teammate cannot diagnose that from a spreadsheet.
There is a restriction on the spreadsheet side too. For Google Sheets, Dataclay’s mapped data page says Templater does not currently support column headers that begin with a numeral, contain spaces, or contain the _ character. A header like 1stPlace or sub title will not map. Something like firstPlace or subTitle will. Write that rule into the hand-off note, because a teammate who adds a new column will otherwise break the mapping with a perfectly reasonable header.
Next, choose which layers to make dynamic. The documentation lists the supported dynamic layer types as of Templater 2.8: text, solid, footage, pre-composition, adjustment and json. Shape layers are the exception. The effect cannot be applied to a shape layer, and the documented workaround is to pre-compose the shape layer and apply the effect to the pre-composition. If a teammate needs to change the color of a shape, build it that way in advance. Do not leave them to discover it.
Supported layer types
Which layer types can take data in Templater 2.8
| Layer type | Effect applies directly? | Workaround if needed |
|---|---|---|
| Text | Yes | None needed |
| Solid | Yes | None needed |
| Footage | Yes | Use standard method for video assets |
| Pre-composition | Yes | None needed |
| Adjustment | Yes | None needed |
| Shape | No | Pre-compose the shape layer; apply effect to the pre-composition |
Before hand-off
Check these before giving the teammate the sheet
- Explicitly rename every dynamic layer after creation, even if the name already looks correct
- Confirm the Templater Settings effect is applied exactly once to each dynamic layer
- Check that no Google Sheet column header begins with a numeral, contains spaces, or contains the _ character
- Pre-compose any shape layer whose color or appearance a teammate will need to change
- Set Scale Factor and alignment rules so longer text fits without a keyframe edit
- Run a Preview task on the longest row you expect before sending rows to a render
Here is a labeled hypothetical, invented for illustration and not a customer story. A marketing team has a thirty-second promo for regional store openings. The designer builds one composition. She names four dynamic layers storeName, openingDate, offerLine and storePhoto, applies the Templater Settings effect to each, and renames each explicitly. Her teammate in the regional office never opens After Effects. For each new store he adds a row to the sheet with a name, a date, an offer and a path to a photo. Her work is finished once. His work repeats every time a store opens. If the offer line for one store is twice as long as the others, the layout rules, which we cover next, deal with it.
The same naming discipline carries over to color and to media. Dataclay documents dynamic footage and dynamic color as separate topics, and the dynamic layers page links to both. If your template changes a brand color per row, or swaps a photo, give those layers the same recognizable names and put the same note in the sheet’s instructions.
Let the layout absorb changes, so nobody edits keyframes
One reason a teammate opens the comp is that new text did not fit. You can remove that reason before it exists.
Dataclay’s layout rules page explains why. When layers receive new data, they may need adjustment, because new data can change a layer’s size, alignment, color or position in an undesirable way. Templater scales and repositions dynamic layers for you, using rules you define per layer in the Templater Settings effect. Scale Factor, for instance, rescales a layer to a percentage of its parent composition’s dimensions. Setting it to 100 percent makes the dynamic layer fill the parent composition. You can force a text layer to scale to 90 percent of its composition and align to the bottom left, while a footage layer in the same composition aligns to the bottom right with its own rules.
Layers also relate to each other. The documentation describes attachments and grouping, which define how layers behave relative to one another. One of its examples is three stacked layers where the bottom two attach to the base of the layer above, so the chain conforms to changes in a single master dynamic layer. The idea is that layers chained to a master dynamic layer conform when that layer changes, so no one has to nudge them by hand. Rules on layers inside nested compositions give you more control over how they scale, align and reposition.
Each of these rules has a reason, and the reason is the teammate. A rule is a decision the designer made once so that a person without the designer’s eye does not have to make it again on every row.
Be aware of three limits, all from the documentation. First, Templater’s layout rules will not function correctly for layer properties that have Separate Dimensions enabled. If a designer separated the dimensions on a position or scale property for an animation, check that layer before trusting the rules. Second, where you map data to expressions, expression code takes precedence over any layout logic Templater might apply to that layer. If the designer wrote an expression on a layer, the layout rules will not override it. Third, the layout rules work on dynamic layers that are directly mapped. A layer without the effect is not adjusted.
The documentation also notes that mapping data to expressions is an experimental feature. It relies on a JSON footage layer, and as of After Effects 15.1.1, a dialog requiring user interaction can appear when an imported JSON footage item changes structure or data types. That dialog can interfere with batch processes. For a template you are handing off, prefer direct layer mapping. A dialog that waits for a person is the opposite of what a hand-off needs.
Handing off a prebuilt template, and the notes that go with it
Sometimes the template was not built by your team. Dataclay supports a second route for that case. Templater 3.5 and later can change values for properties promoted to the After Effects Essential Properties panel, which means it can work with pre-built templates, including Adobe Motion Graphics Templates, the .mogrt files.
The setup has more rules, and each one matters for the person editing the sheet. The pre-comp layer that contains the primary composition needs an explicit name and the Templater Settings effect. Your data source names the property it wants to change with an exact match. In a JSON source you write an element called the layer name followed by @egp, so a layer named assembly becomes assembly@egp. In a spreadsheet you can instead write a column header in the form layer name@[property name], and if the property sits inside a group in the panel, the group name is included in the header. The documentation’s own example is assembly@[Colors > Subheader Fill]. The name has to match the property name in the panel exactly.
The value has to match the type the panel expects. A color can be entered as a hex code such as #FFFFFF. A numeric property takes a number. A boolean takes true or false. If the data type does not match, Templater skips that key and writes an error to its log file. You also do not need a key for every property. Each time the composition is reversioned, Templater reloads the defaults set in the primary composition and changes only the keys found in that job’s data. If a key is missing, or its value is null or undefined, the default is used. For a teammate that is useful, because a property they leave out keeps the design’s own default. Dataclay’s page speaks of missing keys and null or undefined values, so test what an empty cell does in your own sheet.
There is a trade-off here, and Dataclay states it. Reversioning through essential properties may not be as capable as the functionality Templater already offers. Features like Time Sculpting affect more than a single layer, so Templater cannot change those layers through this feature. Media assets promoted to essential properties are supported, but Dataclay does not recommend reversioning video assets that way, because After Effects does not support Time Sculpting, audio files or videos with audio in video layers promoted to the Essential Properties panel. For video footage it recommends the standard Templater method. The documentation says power users may prefer the standard approach, alone or combined with essential properties.
Now the note itself. General practice, not a Dataclay requirement, is to give the teammate a short instruction sheet that lives next to the data. It needs few things. A list of the columns and what each one changes on screen, in the teammate’s words. The header rules, including no spaces and no leading numerals for a Google Sheet. What the sheet expects in each cell, so a color column says hex code and a photo column says a path. What to do when a value will not fit, which is to tell the designer instead of opening the file. And one line on who owns the composition.
The last piece is the preview. Before the teammate’s rows go to a render, they should look at what a row produces. Templater has a Preview task alongside Render and Replicate, and the faults article on where batch faults are caught sorts them by the stage where they show up. Our broader best practices for batch templates post goes deeper on building the project itself. If the data arrives by a feed instead of a file, Que can serve as a JSON-based data source for Templater. And if your teammate is starting from a CSV, the guides on text from a CSV and importing CSV into After Effects show the plain After Effects side of that route.
Who should look elsewhere? If your teammate needs to restyle the video, change the timing of animation, or add a scene, a spreadsheet will not do it. Those are design changes and they belong in the comp. This approach is for the repeated, predictable edits: text, numbers, dates, colors and swapped media. For those, it keeps the composition out of the teammate’s hands.
The bottom line is short. Build the template once, name every changing layer for the reader of the sheet, let the layout rules handle size and position, and write the column guide before the teammate asks. Then the person updating the video edits cells, and the composition stays untouched.
Before you hand the sheet over, run through these. They are the questions that come up once the template is built and a real person is about to use it.
Frequently Asked Questions
Why does my teammate’s new column not change anything in the video?
The layer name and the column header have to match, and the layer has to be processed as dynamic. Dataclay’s docs say a layer must be explicitly renamed after creation, even if the name looks the same, or Templater may not process it as dynamic. Check that the Templater Settings effect is applied once to the layer. For Google Sheets, also check the header. Templater does not currently support headers that begin with a numeral, contain spaces, or contain the _ character. Rename the header, then run a preview of that row before sending it on to a render.
Can a teammate change shapes or colors from the sheet?
Colors and text can be data-driven. Shape layers cannot take the Templater Settings effect, so the documented workaround is to pre-compose the shape layer and apply the effect to the pre-composition. Dataclay also documents dynamic color as its own topic. If you plan for a teammate to change a shape’s appearance, have the designer set up the pre-composition before the hand-off. A teammate who finds this out mid-job will have to ask for a change to the comp, which is the thing we are trying to avoid.
What happens if a cell is empty?
It depends on how the layer is mapped. For properties promoted to Essential Properties, Dataclay’s documentation says that if a key is missing from the data, or its value is null or undefined, Templater uses the default value set in the primary composition. For ordinary mapped layers, test it. Put a row with a blank cell through a preview and look at the result before you tell the teammate what blanks do. Our docs do not describe an empty-cell rule for ordinary layers in the pages we reviewed.
Will the layout rules fix text that is far too long?
They help, but they have limits. Layout rules scale and reposition dynamic layers based on the rules the designer set, such as Scale Factor relative to the parent composition. They will not function correctly on properties with Separate Dimensions enabled, and expression code takes precedence over Templater’s layout logic on a layer. A very long value can also be a content problem. Preview the longest row you expect and ask the designer to tune the rules against it.
Can I use a Motion Graphics Template instead of building my own?
Yes, with Templater 3.5 or later. Dynamic Essential Properties lets you change values for properties promoted to the Essential Properties panel, and Dataclay says this supports pre-built templates including .mogrt files. You name the property exactly, match the data type, and name the pre-comp layer explicitly. The documentation also says this is not as capable as Templater’s standard method. Features like Time Sculpting affect more than one layer, so they cannot be driven this way.
What should go in the hand-off note?
Four things. A list of columns with what each one changes on screen. The header rules for the data source, such as no spaces in names and no leading numerals for Google Sheets. The type each cell expects, such as hex color, a number, true or false, or a media path. And who to contact when a value will not fit. This is general practice, not a Dataclay requirement. The aim is that the teammate never has to open the composition to find out what a column does.
