Nobel metal nanohole arrays have been used extensively in chemical and biological systems due to their fascinating optical properties. Gold nanohole arrays (Au NHAs) were prepared as surface plasmon polaritons (SPP) generators for the surface-enhanced sum-frequency generation (SFG) detection of 4-Mercaptobenzonitrile (4-MBN). The angle-resolved reflectance spectra revealed that the Au NHAs have three angle-dependent SPP modes and two non-dispersive localized surface plasmon resonance (LSPR) modes under different structural orientation angles (sample surface orientation). An enhancement factor of ~30 was achieved when the SPP and LSPR modes of the Au NHAs were tuned to match the incident visible (VIS) and output SFG, respectively. This multi-mode matching strategy provided flexible controls and selective spectral windows for surface-enhanced measurements, and was especially useful in nonlinear spectroscopy where more than one light beam involved. The structural orientation- and power-dependent performance demonstrated the potential of plasmonic NHAs in SFG and other nonlinear sensing applications, and provided a promising surface molecular analysis development platform.