FFmpeg Mass video editing:
I want to automate the preparation of videos with print screens and pre-recorded audio files
Based on a spreadsheet file.
This spreadsheet will fulfill with CSV file with a report.
If the report says, Problem X is positive. It will trigger the link for the explanation of Problem X.
The FFMPEG should get this link for the audio of explanation of Problem X and assemble with a picture of a print screen related to Problem X.
That process can be repeated many times based on the report in CSV file that will fulfill the spreadsheet.
At the end of this process of putting together the relevant audio with relevant pictures in a video format. It all should edit in a larger video assembled in the order suggested by the spreadsheet file output.
The video format should be optimized and ready for fast youtube upload without compromising readability and audibility.
That process needs to be repeatable and scalable, only depending on the correct inputs and outputs of the spreadsheet file and the deliverability of the right images and audio files and correct naming.