Spreadsheets are my best friend for automating the basics. Since my powercards all follow a standard layout initially I used a combination of a lot of concatenation and if statements to allow for me to use csv data from my pcgen to give me the majority of it... I then ran a few macros to turn the range calculations into roll20 friendly inline rolls (as well as a few other in built calculations). Then I applied that to all of the spells and as I need them I 'tidy up' which involves trimming the description if its a bit wordy, telling it what sound effect to call, fx to use if any, things to summon if needed (including my AoE templates) as well as telling it if an attack is required and what type it is. I also have a column to add additional custom powercards rows if needed and one for other api calls (tokenMod, chatSetAttr etc etc). The whole thing took me a fair few hours to set up but I can put ANY spell into my game, fully fleshed out and all singing/dancing, in less than a minute. Perfect for dealing with divine casters! Oh, and I'm a massive nerd with borderline OCD who can't resist the mental exercise of semi-automating something even if it takes me as long as it would to manually do in the first place anyway lol.