How can I automate a audio file to transformations?
Bake Sound to FCurve

Add a single keyframe to the Y location,  open the graph editor and choose "Bake Sound to Fcurve" from the graph editors "Key" menu.

To change the range of the baked fcurve add an envelope modifier.

Combine F-Curve Modifiers with baked Sound

What&#39;s the range of values on a sound-baked f-curve?

Rescaling a baked F-curve to values between 0 and 1