In my previous role, I frequently used Google Sheets to automate reporting tasks. Let me clarify this: I utilized formulas and pivot tables to streamline data analysis and create dynamic reports. By using Google Apps Script, I automated data retrieval and report generation, which significantly reduced manual effort. For instance, I set up scripts to automatically pull data from various sources and update our dashboards in real-time. This approach not only saved time but also ensured accuracy and consistency in our reports. Additionally, I collaborated with different departments to tailor these automated reports to meet specific needs, thereby supporting data-driven decision-making across the organization.