In recent years, building stock models have been developed by researchers to examine the aggregate performance of stacks of buildings within large areas, thereby giving rise to the concept of urban building energy models (UBEMs). The input data for such models consists of geometric and non-geometric attributes of the buildings, in addition to meteorological information. In this perspective, the acquisition of precise and comprehensive data poses a challenge, as the existing datasets often lack certain parameters or are not in a standardized format. This study aims to address the challenges by proposing a workflow for generating an input data frame tailored for incorporation into UBEMs. The data frame should include all the essential parameters of the buildings, and its constitution should be reflective of the real-world data. Moreover, the proposed workflow should remain consistent with databases available at national or regional levels. Acknowledging this non-uniformity in databases across regions, the methodology proposed in this study strategically considers various alternatives. For this reason, the proposed automatized workflow ensures flexibility and adaptability to changes in data availability. The workflow proposed in this study is a QGIS based geographical calculation method. The method can combine data from various sources into one shapefile that can be used to simulate the energy performance of buildings in urban areas.