I'll have to check those out, one thing I was worried about was not having a lot of spare space in this ROM can the automated ones work with that or so they function primarily through rom expansion?
I'm not aware of any general-purpose script insertion utility that will expand a ROM for you (and even if it did, making use of the new space typically requires other game-specific data and/or ASM changes), except maybe if you tell it to write beyond the end of the original file. It's not super-relevant in cases like translation where you're changing all of the game's text anyway, but depending on the utility and the game's text encoding, you can sometimes actually get a slightly better text compression ratio from using a utility than the original game's text achieved.
Any good tutorials for atlas or abcde i could check out or just trial by fire
The Atlas documentation is reasonably decent and contains several examples to get you started. For script extraction, you'll also want to look at Cartographer, which can output files that are pretty close to what Atlas wants for input, so they sort of work together. abcde tries to improve on Atlas/Cartographer (more features, better co-operation between extract and insert file formats, etc.), but its documentation is pitched at people who already know Atlas and Cartographer, so it's probably harder to start with.
After that, I would look for translations that have released their production assets; then examine those assets and try to import/export their them using the tools.
+1 for this too. If somebody else happens to have published any tools for your specific game, then yeah, definitely check those out to see if they'll work for you and do what you want them to.