Automated SaaS User Metrics Dashboard with SQL-Driven Sheets

Create a dynamic Google Sheets dashboard that pulls real-time user engagement metrics from a PostgreSQL database for a SaaS platform. Design a script that automatically refreshes hourly, extracting key performance indicators like user login frequency, feature usage percentages, and subscription tier conversions. Implement custom conditional formatting to highlight critical thresholds, and develop a Google Apps Script that generates email alerts when specific metrics deviate from expected ranges. Include error handling for database connection issues and ensure the dashboard can scale with potential increases in data volume.