Automated Credit Risk Assessment Spreadsheet Pipeline

Create a Python data pipeline that automatically transforms raw credit scoring data into a comprehensive Google Sheets dashboard. Utilize scikit-learn for predictive modeling, implement machine learning classification algorithms to predict default probabilities, and design an automated data refresh mechanism using Google Apps Script. The solution must handle data cleaning, feature engineering, model training, and real-time risk score generation.