• Compatibility After Effects
    Please check exact version compatibility under the "COMPATIBILITY" tab below

Author: Dataclay

License terms
  • Buy 2 for $107.99 each and save 10%
  • Buy 5 for $101.99 each and save 15%
  • Buy 10 for $95.99 each and save 20%

Quick Overview

Easily customize video with an elegant and streamlined workflow solution.
Add Your Tags

What is Templater?

It's a workflow automation tool for Adobe After Effects that makes customizing video content painless. Users automate customization through a streamlined interface that transforms text, footage, and solids into dynamic layers that update as Templater processes an external spreadsheet. Once dynamic layers update, Templater automatically corrects layouts and can render the result to video or generate new unique compositions.

  • @DataClay Nice work! People are going
    to love this utility.

    Todd Kopriva, After Effects Quality Engineer,
    Adobe Systems, Inc.
  • This could save a huge amount of
    time in customizing!

    Larry Jordan, host of Digital Production BuZZ
  • This looks extraordinarily useful.

    Lester Banks, fifteen year veteran instructor in computer graphics, lesterbanks.com.
  • [Templater] is relieving a major bottleneck in post workflows that want to embrace live data inputs, such as Twitter updates, with beautifully constructed motion graphics projects ... [it] is not only saving people time but allowing the actual content creators to spend more time on the story and finesse their design behind the idea, allowing for a better end product.

    Brady Betzel, contributing writer for postPerpsective & editor at Bunim Murray Productions

Key Features

  • Use spreadsheets to easily customize templates
  • Assign rules to autocorrect layouts with new input
  • Replace multiple footage sources very easily
  • Incorporate data from any web API *
  • Translate text layers into different languages
  • Use live tweets in compositions * *
  • Render many unique videos
  • Generate many unique compositions
  • Save countless hours in your workflow!

Suggested Uses

  • Customizing television network branding graphics
  • Integrating social media content into video
  • Localizing text to be rendered into video
  • Personalizing ads and communication campaigns
  • Producing video content for e-commerce platforms
  • Producing video content for digital signage
  • Creating video slates and slideshows at live events
  • Customizing video slideshows of photo streams
  • Creating motion graphic material for video art
  • Quality assuring video templates

How does it work?

Users feed customization data directly into After Effects from a spreadsheet in a very simple manner. While Templater can read flat tab-delimited files exported from common spreadsheet applications such as Microsoft Excel or Apple Numbers, its real power comes from leveraging Google Sheets™ that can store data from third-party Application Programming Interfaces (APIs). Templater also comes with a layout engine that automatically adjusts dynamic layers to produce a finely crafted composition that designers and post-production professional can appreciate.

Templater ships with a custom effect and a panel that is installed into After Effects' application folders. It integrates seamlessly into After Effects users' normal workflow. Users simply tag video composition layers as dynamic with a custom effect and then map spreadsheet data to those layers. For each row in a spreadsheet, Templater updates each tagged layer with its mapped data and automatically scales, aligns, and adjusts it according to rules defined within the effect. It then either renders or replicates the user's desired composition.

What problem does it solve?

Templater was made to improve the process and workflow of producing targeted video based on various external data sources. As organizations mine and store more information, they need ways of leveraging this data to create meaningful connections with customers in markets across the world. Big data can drive media content, but video producers need a way to easily insert information into custom video without tediously replacing assets one by one. One main goal for Templater is to ease the pain points that motion graphics designers and post-production professionals face when creating new video templates and customizing ones that already exist.

Who is it for?

Post production pros, motion designers, marketing automation gurus, web developers, artists, and anybody who use After Effects as a central part of their media production process will find that Templater increases their productivity. Whether they are motion graphics artists, editors or designers, whether they work in television news or live event control rooms, post-production houses, or their own private studios, Templater enables users to work smart hours rather than long hours.


Live Data

Feed your spreadsheet data directly into composition layers. Simply name your layers with the text in your spreadsheet's column headers. Use Google Sheets stored on your Google Drive account as your data source, or use a local file. Templater supports tab-delimited files—export them from Microsoft Excel, Apple Numbers, or Google Sheets.

Intelligent Layout

Using the provided effect, define rules for how your layers arrange themselves in your composition when Templater reads data from your spreadsheet. At render time, Templater adjusts dynamic layers relative to its containing composition and its neighboring layers. No need to futz with aligning, scaling, or positioning dynamic layers—let Templater craft your composition according to your rules.

Punctual & Global

Templater supports unicode characters meaning it can read and write from all languages. Insert characters from any language into your spreadsheet and see them appear in your layers. Of course, your installed fonts should have the glyphs you require. Additionally, text is read as-is, so what you type in the spreadsheet is what you will see in your composition's layer. Commas, quotes and apostrophes are accepted, and right-to-left scripts are supported.


Be certain about how your data displays in your project compositions. With a click of a button, preview how your data-driven compositions look prior to rendering. You can cycle through previews of your render jobs to see how your rules treat different text, images, and colors. This process is especially useful in resolving problematic data and for After Effects template designers who need to see how different content looks in their compositions.

Batch processing

Templater churns out many unique renders very efficiently. Choose to render all the rows in your spreadsheet or just a range. You can apply your output modules and render settings templates to batch jobs and use any prefix for render output filenames. Keep things tidy by specifying any folder on your drive or network for saving render output files.

In addition to easily creating renders, Templater can generate new, unique, compositions within your project based on your spreadsheet data. With this feature, you can work your AE magic on a specific job before it renders. Generated comps are kept tidy and organized within a clean folder structure. You also have the option to send generated comps directly to AE's render queue or the Adobe Media Encoder.


We think you will find Templater easy to use and valuable for your workflow. If you have questions or trouble getting Templater to work for you, we are here to help. DataClay provides technical support to registered users through the help-ticket system here on aescripts.com. Simply submit a ticket with your question, and we will respond as soon as possible. For questions before purchase, feel free to use the comments tab on this page.

DataClay offers extensive written documentation for Templater as well as screencasts (under VIDEOS tab above) to get started quickly. With these resources you can learn everything from basic concepts to detailed step-by-step instructions for accomplishing specific tasks.

Purchasing a single license allows you to install Templater on a single machine for one user. Before purchasing, you should verify that Templater will help your workflow by using it in demo mode which gives you most of its functionality. The demo version adds watermarks to renders, and batch rendering and previewing is limited to three consecutive spreadsheet rows.

DataClay Consulting Services

DataClay offers consulting services for studios, agencies, broadcast networks, live event producers or any company with a need to produce customized video content from AE templates. Visit our author page to contact us if your team needs help to do the following:

  • Create an After Effects project file that is compatible with Templater.
  • Set up existing templates for efficient batch render processing.
  • Integrate data from a specific API for your template. For example, you want to create videos from your company's CRM system.
  • Architect rendering farms for use with Templater.
  • Distribute video content after performing batch rendering tasks.

© Copyright 2013–2014 DataClay. All rights reserved.
  • Templater Main Panel
  • Templater Settings Effect Controls
  • Google Spreadsheet Setup
  • Templater Preferences
  • Templater data source types
  • Map data to comp layers
  • Dynamic layer scale factor
  • Chainging dynamic layers
  • Aligning, attaching, and nesting dynamic layers
  • Setting source footages
  • Handling output locations

Teaser for Templater for Adobe After Effects

Templater turns the arduous task of customizing video content into an elegant workflow solution. Adobe After Effects users automate this customization through a streamlined interface that transforms text, footage, and solid layers into dynamic elements. With this tool, it is now possible to pipe external data from Google Sheets on a Google Drive account directly into compositions. This opens up the doors to using any web API data in within an AE composition. Templater’s engine is design aware, automatically adjusting dynamic elements to produce a finely crafted result just the way you like. It's brought to you by DataClay—a company focused on integrating big data with production workflow.

Use Twitter data with After Effects

Learn how you can integrate twitter feeds directly into your Adobe After Effects compositions. This examples makes use of a variety of Templater's features, and briefly shows how you can populate Google Sheets cells with data from Twitter's API. This may be useful if you are producing content for a news television station, or for live events where you want to create professional looking video of tweets based on a hashtag for that event.

Localizing Text, Google Translate, and Element3D

See how you can leverage Google Sheets' translate function to easily localize text appearing in your Adobe After Effects compositions. This is useful for rendering many comps out with different languages. In this example, we use Video Copilot's Element3D text extrusion and animation features.

Replace footage sources in slideshows

Use Templater to easily swap out footage sources for all dynamic footage layers in your Adobe After Effects compositions. You will see how the "Fit Image Style" parameter works and how to properly reference footage files on your drive from your Google Sheets document. If you are in the business of putting together professional slideshows this is the tutorial for you!

Customizing animated end tags

See how you can use Templater to generate many end tags containing procedural and keyframe animated end-tags. This tutorial shows you how Templater works with animated dynamic layers of all kinds.

Map data from your spreadsheet to layers

Learn how to pipe in data from your Google Sheets from your Google Drive directly to your After Effects project file. This is known as data mapping.

Design rule basics

Learn how to designate layers in your After Effects compositions as dynamic and apply design rules to them. After you designate layers as dynamic, you can then map data to them.

Layout rules applied to animated layers

Learn how Templater for Adobe After Effects applies layout rules to layers that have positional and scale animation. At face value it's not totally obvious how it handles this, but after watching this you'll understand the fundamentals.

Dynamic footage layers

Learn how to easily swap out layer footage sources very easily with Templater. Simply reference a source footage folder, then reference files in your Google Sheets document.

Attaching sibling layers

Learn about the concept of "Attaching" one layer to another sibling layer. This helps you direct the design of your final dynamic template. As new data comes into your layers, Templater can adjust the position of other layers in the same composition.

Attaching, chaining, and grouping dynamic layers

Learn about "Chaining" and "Grouping" dynamic layers within your Adobe After Effects compositions. Sometimes you may want one layer in your template to guide all sibling layers in their position or scale. Use this feature to create a "chain" based on attached layers.

Setting up dynamic color

Learn how you can convert regular solid layers into layers that provide dynamic color into you compositions. Use hex values in any of your spreadsheet columns to change the fill value of your solids.

Batch rendering unique videos

Learn how to specify a composition in your After Effects project to be processed against your spreadsheet's data. You'll understand the concept of "Target Compositions" and how Templater outputs movie files to your specified drive.

Batch replication of template compositions

Learn how you can create replicas of your compositions based on your linked spreadsheet data. You'll see how Templater names and stores replicated comps in your project panel. This feature is great for tweaking Templater's outputs before it performs a rendering task. You can also auto-load replicated compositions into After Effects' render queue or send the replicated comps to render out in the Adobe Media Encoder.

Advanced batch processing and output naming

Learn how you can target different compositions within the same batch operation using a special "target" column in your spreadsheet. Also, you will see how you can control the output name of a specific job in a batch operation by using the "id" column in your spreadsheet.
After Effects CC 2015, CC 2014, CC, CS6, CS5.5, CS5