Sustainable potable groundwater supplied by aquifers depends on the protective capacity of the strata overlying the aquifer zones and their thicknesses, as well as the nature of the aquifers and the conduit systems. The poor overburden development of the Araromi area of Akungba-Akoko, in the crystalline basement of southwestern Nigeria, restricts most aquifers to shallow depths. Hence, there is a need to investigate the groundwater quality of the tropically weathered and fractured gneissic aquifers in the area. A combined electrical resistivity tomography (ERT) and Schlumberger vertical electrical sounding (VES) technique were employed to assess the groundwater-yielding potential and vulnerability of the aquifer units. The measured geoelectric parameters (i.e., resistivity and thickness values) at the respective VES surveyed stations were used to compute the geohydraulic parameters, such as aquifer resistivity (\({\rho }_{o}\)), hydraulic conductivity (K), transmissivity (T), porosity (\(\phi\)), permeability (\({\Psi }\)), hydraulic resistance (\({\text{K}}_{R}\)), and longitudinal conductance (S). In addition, regression analysis was employed to establish the correlations between the K and other geohydraulic parameters to achieve the objectives of this study. The subsurface lithostratigraphic units of the studied site were delineated as the motley topsoil, weathered layers, partially weathered/fractured bedrock units, and the fresh bedrock, based on the ERT and the A, H, AK, HA, and KQ curve models. The K model regression-assisted analysis showed that the \({\rho }_{o}\), T, \(\phi\), \({\Psi }\), and S contributed about 81.7%, 3.31%. 96.6%, 100%, and 11.63%, respectively, of the determined K values for the study area. The results, except T and S, have strong high positive correlations with the K of the aquifer units; hence, accounted for the recorded high percentages. The aquifer units in the area were classified as low to moderate groundwater-yielding potential due to the thin overburden, with an average depth of <4 m. However, the deep-weathered and fractured aquifer zones with depths ranging from about 39–55 m could supply high groundwater yield for sustainable exploitation. The estimated S values, i.e., 0.0226–0.1926 mho, for aquifer protective capacity ratings rated the aquifer units in the area as poor/weak to moderately high with extremely high to high aquifer vulnerability index, based on the estimated low Log \({\text{K}}_{R}\) of about 0.01–1.77 years. Hence, intended wells/boreholes in the study area and its environs, as well as any environments with similar geohydraulic and vulnerability characteristics, should be properly constructed to adequately prevent surface and subsurface infiltrating contaminants.