Automated TikTok Slide Builder

I want to create an automation to generate TikTok slides. I already have a template format, slide design, and content, and I’d like to automate the process.

slides (check attachment):
1- showing a car listing
2- build legitimage story
3- showing app screenshot of analysis
4- calculations
5- this is a fixed image with no changes

The automation would work like this:
1. I manually add the car listing screenshot (I simply take the screenshot myself from the listing or app, then upload it to the sheet. The automation will then place it directly into the slide in the right position.)
2. The workflow pulls the data and fills in each slide automatically
3. Slide 5 stays fixed as always

Note
- Current slides are designed with Figma. (check attachment)
- Also attached the content sheet example, not final

Deliverables
• Working automation script or workflow with clear setup instructions
• A short README or Loom walkthrough showing me how to add new listings and trigger the export
• One test run using the sample sheet I’ve attached, so I can confirm the PNG output matches the reference design exactly

If anything is unclear in the attachments, let me know and I’ll clarify before you start coding.