Groundwater is one of the most important resources that is gifted by nature to mankind, but as the world moves towards urbanization and industrialization, this valuable resource is being ignored, and people tend to misuse groundwater while irrigating and industrial requirements. In this study the problem of groundwater depletion in NCR regions of the Uttar Pradesh (UP) state is discussed. In this study, both primary and secondary data is used. The study is divided into two main objectives; first is to calculate the water demand of the districts in order to find which sector is consuming most of the water, whether it be a groundwater and surface water and for that Central Public Health and Environmental Engineering Organization (CPHEEO) manual guidelines are used and geospatial tools were used to, and second one is to find out the vulnerable zones and suggest recommendations. To achive the second objective, trend analysis of the 5 years Pre and Post monsoon groundwater data is used. By integrating geospatial data and analytical techniques, the research contributes significantly to the field, offering a comprehensive framework for addressing water scarcity challenges in the NCR regions of Uttar Pradesh and potentially serving as a model for other areas grappling with similar issues.