In my previous role, I extensively used Google Sheets to automate reporting tasks. I started by setting up spreadsheets to organize and input data efficiently. To automate reports, I utilized various formulas and functions, such as VLOOKUP and pivot tables, to dynamically analyze and summarize data. I also employed Google Apps Script to create custom scripts that automated repetitive tasks, such as data entry and report generation. This allowed me to streamline processes and reduce manual effort. Additionally, I collaborated with team members by sharing these sheets and setting appropriate permissions to ensure data integrity and security. This approach not only improved the accuracy of our reports but also significantly saved time, enabling the team to focus on more strategic tasks.