Automation of News Scraping and writing blog process

We are looking for an experienced automation developer to build a blog content automation system for RIDA Reports, a UK flood risk and drainage consultancy. The workflow should automatically collect content from approved industry and government sources, remove duplicates, identify relevant article ideas, research SEO keywords and real user questions, and prepare 3–5 complete topic packages for review. Once a topic is approved, the system should carry out deeper research, generate a technically structured article, run SEO/LLM quality checks and prepare the final content as a WordPress draft. Human approval points must remain in the process before research, publication and final release. Blog Automation Workflow.pdf The automation should also retain the SEO brief, sources, approval status and, after publication, allow us to monitor search impressions, clicks, ranking queries and enquiries. Blog Automation Workflow.pdf We need someone who can recommend and implement the best automation stack, ideally using tools such as Make.com, APIs, AI/LLM services and WordPress, while keeping the workflow reliable, easy to review and maintain.