This will detail the process I went through to automate the process is much as possible as well as make it visually appealing so that…