How can I modulate a material with an audio file?

You can use the Sound Visualisations Plugin from Epic (You can find it under Built-In Plugins), giving you access to these blueprint nodes: Calculate Frequency Spectrum & Get Amplitude.
You can then use Custom Primitive Data to feed information directly into the material from your blueprints. You could also use Dynamic Material Instances.

Let me know if this helps =)