A daily habit of checking rates became an email that arrives on its own

Project Description: This project solves a personal challenge of staying updated on the Policy Interest Rate set by the Bank of Canada without relying on mainstream media. Using automation, it retrieves the latest rates, processes the information, and delivers it via email in an easy-to-read HTML table format. This system is not only time-saving but also ensures that vital financial updates are accessible daily, without manual effort. Achievements: Simplified Daily Updates: - Built a system that sends automated email updates with the most recent Bank of Canada rates. Dynamic Data Parsing: - Successfully addressed the challenge of dynamically reading and formatting rows from complex HTML tables. Effortless Communication: - Designed a workflow that organizes and delivers data in a visually clear HTML format. Fully Automated Notifications: - Removed the dependency on manual checks by creating automated notifications. Tools Used: Make : - The central platform for creating and managing the entire workflow. Methodology: Retrieve Data (HTTP Request): - The process begins with an HTTP request to the Bank of Canada’s website to fetch the page containing the latest interest rate information. Convert Data (HTML to Text): - The HTML content of the webpage is converted into plain text to make it easier to process and extract relevant information. Extract Relevant Details (Text Parser - Match Patterns): - Pattern-matching modules identify and isolate the specific rows and columns that contain the interest rate data. Organize Data (Text Aggregator): - The extracted elements are aggregated into a structured format, ensuring that all necessary information is neatly organized. Format Output (Compose a String): - The structured data is formatted into an HTML table, making it visually appealing and easy to read in an email. Deliver Update (Send Email): - The final HTML table is emailed directly to the user, ensuring they receive daily updates on the interest rate without manual intervention. Learnings: Dynamic Data Extraction: - Gained hands-on experience in parsing and formatting complex HTML tables dynamically. Enhanced Communication Design: - Learned how to present financial data in a way that is clear, concise, and user-friendly. Automation Benefits: - Realized the value of automation in reducing repetitive tasks and ensuring consistency in updates. Workflow Optimization: - Improved troubleshooting and error-handling skills to refine the workflow for maximum reliability. Relevant URLs: - Bank of Canada Official Website Conclusion: This project showcases how automation can simplify daily tasks by delivering critical financial updates directly to users in an accessible format. By combining efficient data retrieval, dynamic parsing, and automated notifications, it eliminates the need for manual checks and ensures timely delivery of essential information. The Mindvalley AI Mastery Program was instrumental in the success of this project, providing the tools, guidance, and confidence needed to design and execute this innovative solution. It stands as a testament to how AI and automation can empower individuals to stay informed and make proactive decisions effortlessly.