MySQL to Google Sheets Automation and vice versa

Description

I'm looking for a solution to automate the synchronization of patient information between a MySQL table and Google Sheets in real-time.
Requirements:- Synchronize in real-time- Triggered by data addition and data updates
Ideal Skills and Experience:- Proficiency in MySQL and Google Sheets- Experience with automation tools or scripts- Knowledge of data synchronization techniques