Data Merge for After Effects
Please allow Data Merge from a spreadsheet, just like InDesign or Photoshop. I'm filling a template with 52 instances of text instead of designing and letting After Effects iterate for me.
Allan Barnwell commented
Dataclay's Templater plugin for After Effects does give you a simple way to accomplish a data merge in After Effects. You can use a Google Sheet as a data source and dynamically swap text, images, and video and change colors and other elements inside a composition. Use it to version hundreds of videos - you can even set it up as a fully automated backend for a website or app and let it create customized videos for your clients in your sleep! dataclay.com/templater
Have you looked into any of the new tools for data-driven animation? We support import of CSV, TSV and JSON data files, and it's pretty easy to link their values to a template with the property link pick whip.