Opens in a new tab
Tutorial

Automate After Effects Videos from a Google Sheet with Templater

Published October 7, 2024Last modified November 16, 2026

Yes, you can automate After Effects from a spreadsheet. Templater, our plugin for Adobe After Effects, connects a Google Sheet to a rigged composition, and every row in the sheet becomes one finished video. You set the template up once, you fill in the sheet, and the rendering follows the data. That is the whole idea behind personalized video from a spreadsheet, and the rest of this page shows how the four steps work, what to check before you trust a batch, and where this approach stops being the right fit.

We wrote this for the person who has been handed a job that sounds like weeks of manual editing. A set of videos that all look the same but carry different names, images, dates or offers. You already work in After Effects. You do not want to learn a second video tool, and you do not want to retype text into a timeline row after row. A sheet that your colleagues can edit, plus a template that reads it, is a much calmer way to work.

How a spreadsheet drives an After Effects template

Templater is a plugin that lives inside After Effects as a panel. You build your composition the way you always have. Then you rig it, which means you tell Templater which layers should change and which column of your data should drive each one. After that, Templater pairs the template with a data source and applies the data. Text changes, images swap, and footage gets replaced. One template becomes as many videos as you have rows.

Google Sheets is one of the data sources Templater reads directly. It sits alongside JSON files and feeds, and tab-separated files exported from other spreadsheet tools. The sheet is a good place to start for a simple reason: the person who knows the facts can edit them. A copywriter owns the headline column and a coordinator owns the dates. Nobody has to open After Effects to fix a typo, because the video draws on whatever the sheet says when the job runs.

Here is a hypothetical example, so the steps below have something to hang on. A training coordinator needs a short welcome video for each new cohort of learners. Each video shows the learner’s name, the course title, a start date and a photo of the instructor. The design is the same every time. Only those four pieces of information change. The coordinator keeps one sheet with a row for each video, and a motion designer keeps one After Effects project with a single rigged template. That is the entire setup.

Before you start, you need an Adobe After Effects license and Templater. Our free trial includes every feature, with a watermark on rendered layers, so you can try your own sheet end to end before you decide on anything. One more thing about versions. Templater 3.7 and later connect to Google Sheets with the current method, and earlier versions lose that connection entirely. If a connection that used to work has stopped, read our post on the required Templater update for Google Sheets users, then check the version shown in Templater’s About dialog.

The four steps, from sheet to rendered video

The process has four stages. We keep them in order because each one depends on the one before it, and most trouble comes from skipping ahead.

1. Prepare your After Effects project

Set up the composition with placeholders for everything that will change. In the hypothetical welcome video, that means a text layer for the name, a text layer for the course title, a text layer for the date and an image layer for the instructor photo. Build the design the way you would for a single finished video, using a real name that is a realistic length. Then think about the other lengths. A template that looks perfect with a short first name can fall apart on a long one, and you want to find that out now, while the design is still easy to change.

This is also where Time Sculpting comes in. It is the method covered by U.S. Patent No. 10,515,665, and it lets you author a timeline that reconfigures itself when an element changes duration. If one learner’s introduction runs longer than another’s, the composition adjusts to the new length instead of leaving a gap or cutting off. Our post on Time Sculpting in Templater explains the four techniques, and you only need them when your content varies in length. A template where every element is fixed in duration does not need any of it.

2. Link to your Google Sheet

Create a Google Sheet that holds the data for your videos. Put one video on one row, and give each column a header that says what it feeds, such as “learner_name” or “start_date” or “photo_link”. The headers become the vocabulary you use when you map the data to layers, so a clear name saves you time every time you open the project. The sheet can hold names, dates, prices written as words, image links, or any other information that needs to change from video to video.

Templater maps data to one worksheet, so the tab you connect has to carry everything the template needs. If your information is spread across several tabs, build one combined tab and connect to that. In the Templater panel, you sign in to Google, pick the sheet with Dataclay’s Google Drive file picker, and Templater reads the rows. If you hit authorization trouble, resetting After Effects preferences is the step to try, and Adobe documents how.

3. Map data to placeholders

Now you map the columns to the layers. In the welcome video, “learner_name” goes to the name layer, “course” goes to the course layer, and “photo_link” goes to the image layer. This tells Templater which data goes where in your composition. Once the mapping is done, you can step through the rows inside After Effects and watch the template change as each row is applied. Templater Rig, the entry edition, includes this preview, so a designer can check a whole data set without importing or retyping anything.

Use the preview on purpose. Look at the first row, and then look at the worst row: the longest name, a name with an accent, a row where the photo link is missing. Real data is messier than the sample row you designed with. Two minutes of previewing the awkward rows is cheaper than finding them in a finished batch.

4. Automate the render process

With the sheet linked and the data mapped, Templater updates your After Effects project with the data from each row and renders the videos. In Pro, you press Render and it works through the rows. Bot goes further. It checks the data source on a schedule, notices when new rows are ready, and starts the renders on its own. When the data changes, a new version of the video can be produced without anyone editing it by hand. The three editions stack, so each one includes everything in the one before it. We have a longer guide if you want the details: Templater, the complete guide to automating After Effects from data.

Edition choice

Pro vs. Bot: what each edition does

How renders start
ProPress Render and it works through the rows
BotChecks the data source on a schedule and starts renders on its own
New-row handling
ProRequires manual start
BotNotices when new rows are ready automatically
Includes Pro features
ProYes
BotYes, the three editions stack

When the data changes, a new version of the video can be produced without anyone editing it by hand.

One trap deserves a plain warning. Rig can replicate only when the user has QUE credits in their QUE Meter; with pay-as-you-go QUE credits Rig effectively acts like Pro and Bot. It can render single jobs with After Effects’ own render options, but without QUE credits its Render and Replicate buttons are disabled. The free trial includes Bot-only features, and it is easy to fall for a function in the trial that a Rig license will not give you without QUE credits. Choose the edition by the job you have, not by what you saw while trying it out.

Three editions

Rig, Pro and Bot at a glance

Edition Batch output Scheduling
Rig Cannot batch output; Render and Replicate buttons disabled None, previews data in After Effects only
Pro Renders each row when you start it Manual start only
Bot Renders all rows automatically Checks data source on a schedule

Keeping the sheet honest as it grows

A sheet is forgiving, which is exactly why it gets messy. The habits below are general practice rather than documented Templater behavior, apart from the places where we name a feature. They are worth adopting before the sheet has a hundred rows, because they are much harder to introduce afterward.

Give the sheet one owner. One person is responsible for the structure, meaning the tab, the headers and the status column. Everyone else edits values and nothing else. When two people each add a column just for themselves, the mapping in After Effects breaks on the next run, and nobody can tell why. A sheet with an owner is a data source. A sheet without one is a shared whiteboard.

Keep data and instructions apart. Sheets collect notes: a comment in the last column, a highlighted cell, a row somebody wanted to skip. Highlighting does nothing for Templater. If a row should be skipped, say so in a column the process reads. Bot reads a render-status column to decide whether to render a row, and if you set a Bot Name in preferences, it looks for a column headed “bot”. Our documentation lists the reserved column names, so check them before you name a column something Templater would treat as an instruction. Our post on the reserved column name problem shows what happens when a name collides.

If you want the full list of how the connection behaves, which errors come up, and where the limits are, we put it all in one place in Using Templater with Google Sheets: the complete reference. That page is the deeper companion to this one. We do not repeat it here. This page is the first project, and the reference is what you keep open afterward.

Preview before every large run. Move through the first row, the worst row and a few rows from the middle. In Pro and Bot, you can generate spot checks, which are stills or short clips of chosen frames from the merged compositions, so you can see how the data lands across many jobs. Our post on preview modes and spot checks covers the setup.

Before you batch

Check these before running a large batch

  • Preview the first row, the worst row, and a few rows from the middle
  • Check the longest name, a name with an accent, and a row where the photo link is missing
  • Confirm Templater version is 3.7 or later before connecting to Google Sheets
  • Check reserved column names in documentation before naming a column
  • Run the smallest version of the job, a copy of the sheet with only a handful of rows, before the real one
Two minutes of previewing the awkward rows is cheaper than finding them in a finished batch.

A note on the other kinds of data. If your information starts life in a spreadsheet file rather than a Google Sheet, our post on data sources in Templater lays out the options, and moving the file into a Google Sheet gives you shared editing and a cloud connection. If you want a video to start itself when a new row appears, we cover that in our post on triggering a video when a row is added to a spreadsheet.

Automation without AI, and where it does fit

Templater automates video editing without artificial intelligence. That is a design choice, and it has consequences you can use. You control exactly how your data is used and how your videos are rendered. There is no model to train and no output to second-guess. A row that says “Jordan” produces a video that says “Jordan”. The same data and the same template give the same result, and you can check any video against the row that made it.

We are not against AI tools. They solve a different problem. An AI service can produce text or classify an image, and you can feed what it produces into a sheet like any other data, and then Templater places it into your finished design. Templater AI, available in version 3.7 and later, is a narrower thing. It fills a text layer from a prompt when your data source has nothing for that layer, which is useful for designing a template with believable words before the real words exist. It does not clean or correct the data that you supply. Our post on what Templater AI does and doesn’t do draws that line carefully. If you want to understand the broader question of where templates and generative tools each belong, the same idea applies: use the tool that fits the job.

Where does a spreadsheet stop being enough? Templater maps to one worksheet and one data source. It reads a font, size and weight per text layer, so the data cannot mark up a single word in bold. Large teams and large volumes strain a sheet. Our QUE product is a JSON-based, cloud-based data source with API endpoints that can receive data from anywhere, and you can enter information in the QUE Dash without knowing JSON. You can use a sheet and QUE together. Our post what is QUE in Templater explains how, and it is the page to read if your sheet is starting to feel like software.

The same approach fits many kinds of work. Marketing teams can produce personalized video ads for different audience segments, with the text, images and offers drawn from each segment’s row. Training teams can make a video for each learner, as in our hypothetical above. Event teams can update dates, locations and speakers as they change. Social teams can refresh short videos when the data behind them moves. In each case the template stays put and the sheet does the changing. If your starting point is a customer list rather than a sheet you maintain by hand, see personalized video for every customer from a CRM export.

One practical habit helps a first project more than any setting. Run the smallest version of the job before the real one. Make a copy of the sheet with only a handful of rows, including the longest name and the row with the missing photo, and render those. You learn how the template behaves on awkward data, you see how long a render takes on your own machine, and you find a mistyped header while the cost of fixing it is a minute. Then point the template at the full sheet and run the real batch with much less worry.

The bottom line is simple. Use Google Sheets when your data is modest, several people edit it, and you want to see changes quickly. Prepare the project, link the sheet, map the columns, and render. Keep one tab, one row per video, clear headers and a status column that Bot respects. Preview your worst row before you run a batch. When the sheet turns into a program, move the data to QUE or a JSON feed and keep the sheet as the place people edit. Our Templater page has the free trial, and Dataclay’s CEO, Arie Stavchansky, covers the basics of using Templater with Google Sheets and other data sources in the video that accompanies this post.

Still deciding whether this fits your project? These are the questions people bring us most when they first connect a sheet.

Frequently Asked Questions

Can I automate After Effects videos from a spreadsheet?

Yes. Templater is a plugin for Adobe After Effects that reads a data source and applies it to a rigged composition. Google Sheets is one of the sources it supports directly. You rig the template once, connect the sheet, map the columns to layers, and Templater renders one video for each row. You do need an After Effects license and Templater, and our free trial lets you test your own sheet first.

What tool connects a spreadsheet to an After Effects template and generates videos automatically?

Templater does this inside After Effects. You map the columns of your Google Sheet to the layers in your composition, then render. Pro renders each row when you start it, and Bot checks the data source on a schedule and starts renders when new rows are ready. Rig is the entry edition. It previews the data in After Effects but cannot batch output.

How do I make personalized videos from a spreadsheet?

Build one template with placeholders for the parts that change, such as a name, an image and a date. Put one video on each row of a Google Sheet, with a clear header on every column. Map the columns to the placeholders in Templater, preview the first row and the worst row, and then render. Every row produces its own version of the same design, so the personalization lives in the sheet, not in the timeline.

Do I need AI to automate video editing with Templater?

No. Templater automates video production without artificial intelligence. It places the data you give it into the template you designed, so the same data produces the same video every time. If you want AI-generated content, you can produce it with another tool and put it in your sheet. Templater AI, available in version 3.7 and later, can also fill empty text layers from a prompt, but it does not clean the data you supply.

Why did my Templater connection to Google Sheets stop working?

Templater versions earlier than 3.7 lose their connection to Google Sheets, because the legacy Google integration method was scheduled for retirement. Check your version in the About dialog, opened with the “i” icon in the lower left corner of the Templater Preferences dialog. If it is earlier than 3.7.0, sign out of the Google connection, download the latest Templater, and follow the updated steps. If you see authorization problems, resetting After Effects preferences may help.

What is Time Sculpting, and do I need it for a spreadsheet project?

Time Sculpting is the method covered by U.S. Patent No. 10,515,665. It lets a composition timeline reconfigure itself when an element changes duration, like a ripple edit built on rules you define. You need it when your content varies in length from row to row, such as footage clips of different durations. If every element in your template has a fixed duration, you can build the project without using it.

When should I move from Google Sheets to QUE?

Move when the sheet starts to feel like software. Templater maps to one worksheet and one data source, and spreadsheets become unwieldy as the volume and complexity of your production grows. QUE is a cloud-based, JSON-based data source with API endpoints and a dashboard that shows job status and the use of your rendering machines. You can also keep the sheet as an editing surface and bring it into QUE through the QUE API.

Allan Barnwell

Allan Barnwell leads Sales and Marketing at Dataclay, bringing extensive experience as a creative professional and thought leader in media creation tools. With a strong entrepreneurial spirit, Allan has a diverse background in live broadcasting, film production, writing, graphic design, illustration, web and database development, technology consulting, and marketing. His passion for empowering creative professionals drives his mission to provide innovative solutions that elevate media workflows across industries.

Leave the first comment

Sign up

Stay up to date with Datclay's newsletter. We won't spam your inbox.

Newsletter Signup
Name
Name
First
Last

By submitting your email, you agree to our Terms and Privacy Policy. You can opt out at any time.