Project Details

1. The process starts by connecting to a Google Sheet using a Python script to download the file and facilitate its manipulation. This file is used by the corresponding area and includes information and flags for specific actions. 2. A search is conducted in BH to gather additional information about each record in the file. This includes data such as phone number, email, address, employer, and IBC. Each piece of data requires accessing a different path and completing different forms in BH. 3.Once the data is obtained, personalized letters are generated based on the needs of each record. Depending on whether the situation is positive or negative, certain predefined formats are applied. For this task, the Python Docs library is used to replace the information obtained into the corresponding fields of the letter format. 4.Finally, the generated letters are sent via email to the recipients listed in the Google Sheet document. Each recipient receives their attached letter individually, along with a default email body. technology used: Python, SQL, AA, Good practices, web page, File management, Logs review: This process was assigned for development from scratch, and I assumed full responsibility for its implementation. This included the initial requirements gathering analysis, work planning, identification of process improvements, system development, user acceptance testing (UAT), code reviews, production implementation, system stabilization, and resolution of any errors reported by the client.