Big hint: educate yourself about Spiratone's MacroDapter. Ask Google what it can find for you.
Bigger hint: buy copies of A. A. Blaker's book Field Photography, which guide number arithmetic very well, and Lester Lefkowitz' book The Manual of Closeup Photography, which will take you the rest of the way. If you know the flash's GN, calculating the aperture to set given flash-to-subject distance and magnification or flash-to-subject distance given GN and desired effective aperture is easy.
Nice that you want to use gear you already have, but it probably isn't the best solution to the problem. Two reasons: ring lights give flat lighting, controlling output (hint: ND gels) is harder with a ring light than with a couple of tiny flashes.
You don't need TTL autoflash. You need to understand what you're doing. If the mental arithmetic is too much for you, shoot calibration shots and keep the notes.