Hybrid structures combining metal oxides and organic molecules have shown promising potential for optoelectronic devices applications like photodetectors, photodiodes, and phototransistors. The idea behind introduction of two different kind of materials is to enhance its optical properties by supporting electronic phenomenon. The integration of these two materials leverages the unique properties of each, resulting in enhanced performance and functionality. Metal oxide narrowband photodetectors in the visible region are in demand for different applications such as image sensors. In this work, a narrowband photodetector is fabricated by coating a red-sensitive organic dye (Squaraine) on top of a metal oxide heterojunction consisting of zinc oxide (ZnO) and titanium oxide (TiO2). The formation of the heterojunction helps in effective charge separation at the interface, which in turn improves overall sensitivity of the photodetector. Electrical characterization studied under light illumination and external quantum efficiency measurements reveal that the photodetector has selective sensitivity in the red region with a peak position at 650 nm. The device shows a significantly low dark current (1.72 nA under 10 V bias) with a detectivity of 2.57 ×1010 Jones (under 1 V external bias). These characteristics suggest that SQ2 dye based red-light photodetectors are suitable for visible light communication (VLC) and other narrowband photoelectric applications like image sensor. The combination of different metal oxide heterojunctions and composites with different organic materials will be studied thoroughly to get an ultrasensitive photodetector for narrowband applications.