In my previous role, I had the opportunity to use Google Apps Script to automate a complex reporting process. We had multiple Google Sheets containing data from various departments like sales, customer service, and inventory management. The challenge was to consolidate this data into a comprehensive report that could be easily interpreted by management. 

To address this, I wrote a script that automatically pulled data from these sheets, performed necessary calculations such as total sales, average order size, and stock turnover, and then compiled the results into a new summary sheet. This summary included visual elements like charts and graphs to highlight key metrics. 

I also set up a time-based trigger to run the script daily, ensuring that the report was always current. This automation significantly reduced the manual effort required to generate reports, minimized errors, and provided timely insights, which greatly improved our decision-making process. The experience taught me the value of leveraging technology to streamline workflows and enhance productivity.