Human activities and climate change impact ecosystem services, thereby affecting economic and social sustainable development. Measuring the heterogeneity in space and time of how human activities affect ecosystem services poses a challenge for the sustainable management of land resources. Based on “human appropriation of net primary production (HANPP) - Fractional Vegetation Cover (FVC) - Soil Conservation Service (SCS)” cascading effect, first, a geographically and temporally weighted regression (GTWR) model was employed to assess the impact of HANPP in percent of potential NPP (hereafter HANPP%) on the FVC; second, changes in the FVC caused by human activities were quantified; and third, the potential soil conservation service (SCSp) and actual soil conservation service (SCSa) were estimated using the Revised Universal Soil Loss Equation (RUSLE) model, and the difference between them represented the changes in soil conservation service caused by human activities (SCSh). Taking the Qinghai-Tibet Plateau as a case study, we found that the GTWR model was well suited for analyzing the relationship between the HANPP% and the FVC (R2 = 0.897). The HANPP resulted in a decrease in the FVC from 0.222 in 2001 to 0.199 in 2019 and correspondingly resulted in a decrease in the ratio of SCSh to SCSp from 8.95% to 7.24%. This study provides a quantitative method that allows quantifying the influence of human activity on ecosystem services closely related to the FVC.