Materials with photoswitchable electronic properties and conductance values that can be reversibly changed over many orders of magnitude are highly desirable. Metal-organic framework (MOF) films functionalized with photoresponsive spiropyran molecules demonstrated the general possibility to switch the conduction by light with potentially large on-off-ratios. However, the fabrication of MOF materials in a trial-and-error approach is cumbersome and would benefit significantly from in silico molecular design. Based on the previous proof-of-principle investigation, here, we design photoswitchable MOFs which incorporate spiropyran photoswitches at controlled positions with defined intermolecular distances and orientations. Using multiscale modelling and automated workflow protocols, four MOF candidates are characterized and their potential for photoswitching the conductivity is explored. Using ab initio calculations of the electronic coupling between the molecules in the MOF, we show that lattice distances and vibrational flexibility tremendously modulate the possible conduction photoswitching between spiropyran- and merocyanine-based MOFs upon light absorption, resulting in average on-off ratios higher than 530 and 4200 for p- and n-conduction switching, respectively. Further functionalization of the photoswitches with electron-donating/-withdrawing groups is demonstrated to shift the energy levels of the frontier orbitals, permitting a guided design of new spiropyran-based photoswitches towards controlled modification between electron and hole conduction in a MOF.