My understanding is that you have three levels of gabled roof with the planes facing roughly east-west, and all your gable vents face north. Correct?
In that case I like your idea, but there may be better passive options to get airflow that don't burn electricity all the time. If you could install a few square feet of soffit vents, you might find that makes a huge difference in the way air flows into the attic and out of the existing vents. Right now, air is only exchanged when the attic gets so hot the air flows out of the higher vent and outside air is sucked into the lower one. All vents are facing the same direction as I understand, so wind can interfere, especially since wind speeds are generally higher at the higher elevations.
Take a look at your soffits. If they are just painted wooden boards, you can easily hack out 5-6 rectangular holes and tack on some inexpensive soffit vents like these:
https://www.lowes.com/pd/Master-Flow-Undereave-16-in-L-White-Aluminum-Soffit-Vent/999972080If the soffits are solid siding, explore whether you could replace a few soffit pieces with perforated siding material and open up an air channel into the attic. If the home was originally built with siding, it will probably not be solid wood under the existing siding. So this scenario is an especially easy fix. If the siding was added later, you might remove the solid soffit while being careful not to tear up the channel pieces, saw out the old underlying soffit boards to expose the attic, and then replace the soffit with perforated material. You might even find that siding was added and covered up the old vents!
I suggest focusing your vent additions on the upwind west side of the house, so the house itself scoops incoming air up into the soffit vents, the air blows through the attic, heats up, and exits through the existing north-facing gable vents. If it seems simpler and you have a west-facing porch, consider putting a several of these vents in the ceiling there. A porch will act as a natural air scoop too, although it won't distribute the airflow across the hot roof deck as well as soffit vents.