API to create monster statblock

Is there a way to use an api to create a monster stat block, in this case i'm running a ocean sailing heavy campaign and i want a way to create ships with specific stats, i have all the stats on a spreadsheet and was hoping there was a way to write a formula to parse those stats into the right text to copy paste a s aa command/macro in roll20, i've doen this loads for creating tokens using token-mod but was hoping there was a version for creating a monster stat block character sheet?

What game are you playing?    There are over 300 different game systems on Roll20: E.g. D&D 5th Edition, Pathfinder, Call of Cthulu, etc. Which character sheet are you using for the game?    There are over 1,000 character sheets on Roll20: E.g. D&D 5E by Roll20 (2014 or 2024), Pathfinder 2e, Cyberpunk Red  There have been various scripts to create or import characters for D&D 5E on the D&D 5E 2014 by Roll20 character sheet.  5e NPC Importer , BeyondImporter  etc.  You could also use the ChatSetAttr  script to add attributes to a character. If you already have a spreadsheet then this is probably your best option.  But which script you use and how you use it depends on what game you are playing and which character sheet you are using.

i'm using D&D 5E 2014 by Roll20 character sheet, ChatSetAttr is a possibility I'm considering but you can't create the actual character sheet with it

What do you mean by “you can’t create the actual character sheet with it”?  Do you mean that you want a script that will create a character in the journal in addition to filling out attributes?