Just a heads up – this is not a single tutorial. It’s more of a mini-project guide and breakdown of various techniques.

I put together 3x 30mins long videos, where I setup 8 sec long mini project with lots of data coming in from Spreadsheets. I tried to be slow and methodical and explain the whole setup with Figjam notes, breakdowns and examples. If you are in the space, where you need to create lots of similar animations, but swap text or images, then I think you will find this series useful.

Enjoy 🙂

Gumroad store contains all the spreadsheets, SVG logo + Cavalry project files used in creating this series. If you can’t afford the donation, just pause the video and re-create the spreadsheets on your end or use similar data. They are pretty simple ones. It’s about learning the methods and not about following this series 1:1.

In terms of images, feel free to use your own. Or download a copy of the ones I used from Unsplash:

• Baker
• Barista
• Bike Mechanic
• Barber
• Florist

KreditCat is a made up company name. As of January 2026, it does not exist on the internet, as far as I know 🙂 I decided to treat this project more like a spec corporate assignment, rather than just bunch of random concepts. I think it is easier to learn something complex, by following small steps towards end goal – social media video that we can deploy to many markets.

Overall, this project was inspired by Stink + Revolut + Cavalry case study on Medium blog. I read it few years ago and I was impressed by possibilities. But how do you even start, as a beginner Cavalry user?

Well, first of all, you gather all your data (Spreadsheets), all your assets (images) and branding (logo, colour palette, fonts etc). Then you want to put together a storyboard and layout “close enough copy”. This will let you see how everything will fit together and what can be automated, broken down into pieces. Or even how you need to store data.

It is up to you to decide how to structure data. I split it into 3 sections:

• Customer Data
• Technical Data
• Other Data

I found it easier to split it into pieces and use CSV files, rather than one big spreadsheet. At the end, Cavalry has String Generators, especially Formatted String, where you can “piece” this data together. Whatever you do, make sure you follow the same logic across spreadsheets, if you need to mix data from different spreadsheets. For example:

• Customer Data contained quotes, which were translated to 7 languages
• Other Data contained Call To Action, which was translated to 7 languages in the same order as Customer Data

This makes it easier to link things together and reuse Nodes / Layers in Cavalry. Same goes with images used and Image Smart Folder. Rather than trying to rig Spreadsheet with image names, I simply used Index to select correct images. This way, I can easily add more images and more quotes and render everything all at once.

If you are familiar with Digital Design or even Figma, then you are familiar with concept of Responsive Design. In essence, you want your layouts or design to respond to resolution changes or other objects. This is why, I used Math Nodes and Spreadsheet Height and Width to position elements on the screen. For example, introductory logo or size of the text boxes.

Make use of the data you have to resize / reposition or limit elements on the screen. Sometimes you may encounter “red noodles of no connection”. This happens, when there is a potential loop going on in the back end. You connect Comp Width to Box Width, and try to offset Duplicator by Comp Width divided by Box Width and so on. At some point, you may get a red no-connection warning. If this happens, you may have to rethink your setup. Or use other way to get what you need.

For example, you can use Background Shape and Bounding Box to capture Comp Size. This will allow you to calculate offsets or other changes, without potentially creating a loop.