Direct detection of single photons at wavelengths beyond 2 microns under ambient conditions remains an outstanding technological challenge. One promising solution is frequency upconversion into the visible (VIS) or near-infrared (NIR) domain, where single photon detectors are readily available. Here, we propose a nanoscale solution based on a molecular optomechanical platform to up-convert THz and mid-infrared (MIR) photons into the VIS-NIR domain, and perform a detailed analysis of its added noise and conversion efficiency with a full quantum model. Our platform consists in doubly resonant nano-antennas focusing both the incoming long-wavelength radiation, and the short-wavelength pump laser field, into the same active region. There, infrared active vibrational modes are resonantly excited and couple through their Raman polarizability to the pump field. This optomechanical interaction is enhanced by the antenna and leads to the coherent transfer of the incoming low-frequency signal onto the anti-Stokes sideband of the pump laser. Our calculations demonstrate that our scheme is realizable with current technology and that optimized platforms can reach single photon sensitivity, at wavelengths reaching into the THz domain, with an added noise only limited by the thermal occupancy of the molecular vibration.