In my previous role, I extensively used Google Sheets to automate reporting tasks. I created automated reports by leveraging formulas, pivot tables, and scripts to streamline data processing and ensure accuracy. For instance, I set up scripts that would automatically pull data from various sources, update the sheets, and generate reports without manual intervention. This automation not only saved time but also reduced the likelihood of errors. Additionally, I used conditional formatting and data validation to highlight discrepancies and ensure data integrity, which was crucial for maintaining high-quality standards in our reports.