Globally, there are different scientific methods being developed to support the provision of Impact-based Forecasts and Warnings. Impact data is critically valuable to many of these methods enabling the development of new hazard impact models and forecasting applications, and the evaluation of these different products. However, routine and consistent approaches to collect socio-economic impact information remain challenging, with traditional approaches being labour intensive, error prone and unsustainable. This paper describes the design of an automated workflow that can collect, standardise, and harmonise impact observations from a range of sources, routinely. The workflow is a 6-step process including web scraping, Natural Language Processing (NLP) and geoparsing. The workflow enables essential criteria (i.e., date, location, types and details of the societal impacts and the hazard(s) which led to them) to be captured faster than previous manual approaches. It also allows a wider range of hazard and impact types to be collected than was previously practical to do. Testing of the workflow indicates that it could benefit from further refinement of the NLP and geoparse modules to allow for the detection of finer scale impact locations. This in turn would allow for different scales of event detection to be developed and tested. Additionally, the applicability of the workflow for different types of impact data sources such as news and social media remains to be tested. Despite the need for further refinement, this workflow represents a step change in the speed and efficiency of impact data collection within the Met Office.