Hi, garyritchie!
There is no way to use the camera shake, since this effect does not use the position and rotation values directly. He somehow does it artificially.
There can be two options.
Solution 1. Make a real shake using 3D programs, such as 3DS max, and record an animation of the camera shaking. Then apply the shake to your UE4 camera.
Solution 2. You can try to create a postprocessor that shakes.