Dynamic Hierarchical Data Visualization with Recursive CTEs

Create a Google Sheets dashboard that dynamically renders organizational hierarchy using a recursive Common Table Expression (CTE) from PostgreSQL. Design a script that pulls employee reporting structures, calculates depth levels, and generates a color-coded org chart with conditional formatting. Include functionality to expand/collapse nested reporting lines and display key metrics like team size, average tenure, and span of control.