Workflow choices and using multiple programs for a project
I'm not 100% sure where to post this. I'm hoping for some general advice rather than something too technical.
I'm creating a card game (something I have done before) but I would like to use more digital tools this time to make life easier. My technical background is in video editing, so I know Premiere. Outside of video I know what kind of things are possible, but not which tools I should use for what.
What programs should I use?
Currently the imagery is all stock. But I need to design a card layout (text, image placement, stats) that I can then fill in like a template. However the only way I know how to do that is to make 1,000 copies of the same card and edit each one. I'd much rather create a system that can automate this. Especially if there is a layout change so I don't have to manually change each and every card.
Last time I created a database (collection of spreadsheets, nothing smart or linked) using googlesheets. Then I just copy-pasted that information into the cards Illustrator. Obviously not the best. Could anyone recommend a better system to make and propagate changes?
