AI Automation from data sheet to report

I have created a Python script that scrapes data from specific websites and have also created the report template. I am now looking for help to automate the process of taking the scraped data and inserting it into the report automatically, either through a Python script, n8n workflow, or a similar automation tool. The main issue I am having is getting the scraped data to populate the specific sections of the report correctly and consistently. The PDF attatched is an example of the report I want to be fully automated. The Excel attatched is an example of the raw data I have scraped