What type of shooting are looking for? Trap, skeet, sporting clays? Also, what direction from the Cities are you interested in? For starters there is Minnesota Horse and Hunt in Prior Lake, Metro Gun Club in Blaine, South St. Paul gun club, Oakdale gun club, Minneapolis Gun club down I-35 in Rice County, St Francis and Minnetonka gun clubs in St Francis, Forest Lake gun club, Caribou Gun Club in LeSeuer, Wild Marsh in Becker, Wings North in Pine City. Blacks "Wing and Clays" has a very comprehensive list. I haven't been to any but I'm told there are several clubs just across the border in Wisconsin too. I know Hudson has a couple but can't think of their names. Some of the clubs are private but often have times open for the public. I've spent a fair amount of time in the Twin Cities and have visited all these clubs at least once. The majority are trap ranges but some have skeet and sporting clays is becoming more popular.
There are a number of web sites that have extensive lists of shooting clubs & ranges. Here's one that has a respectable number of listing for the whole nation, yet this link is just for Minnesota folks:
A forum community dedicated to Shotgun owners and enthusiasts including the Remington, Beretta, and Mossberg shotguns brands. Come join the discussion about optics, hunting, gunsmithing, styles, reviews, accessories, classifieds, and more!