Based on detrital monazite dating, mineral chemistry of tourmaline and rutile, bulk rock geochemistry, modal analysis of petrographic and palaeocurrent data, this study tracks the source of quartzose sandstone within the Cretaceous succession of the Cambay Basin primarily to rocks within the Aravalli‐Delhi Fold Belt. Monazite geochronology shows predominant peaks around 506 ± 11 Ma, 905 ± 12 Ma and a minor peak at 750 ± 20 Ma, 1485 ± 30 Ma relating sediment sources to the Aravalli‐Delhi orogeny and Pan‐African orogeny. The petrographic modal analysis of the moderate‐to‐well‐sorted Himmatnagar Sandstone indicates at least 91% quartz, with minor feldspar and rock fragments. The mineral chemistry of tourmalines in Himmatnagar Sandstone matches with Li‐ and Ca‐poor granitoid, pegmatites, metapelites and quartz tourmaline rocks. The trace element content of rutiles in sandstones corresponds to metapelitic sources. Detrital monazite dates and mineral chemistry of tourmalines and rutiles pinpoint the sediment source to the South Delhi Supergroup of rocks. The dominance of rounded zircons and tourmalines and abraded quartz overgrowth in the Himmatnagar Sandstone indicate the recycling of sediments, possibly from the Marwar Supergroup. Palaeoclimatic proxies based on mineralogy and geochemistry, particularly, the high value (93–97) of mineralogical index alteration, indicate intense chemical weathering of the source rocks under humid climatic conditions. Therefore, the combination of factors, including the quartzo‐feldspathic source rocks, intense chemical weathering under humid climatic conditions and the recycling of sediments facilitated the formation of quartzose sandstone within the Himmatngar Sandstone in the Cambay Basin.