To design a solution for automating a weekly IT infrastructure utilization report in Google Sheets, I would start by identifying all the data sources involved, such as databases, APIs, or other spreadsheets. Next, I would determine the specific data points needed for the report and establish a method for accessing and extracting this data, ensuring that any necessary permissions or credentials are in place. I would then use Google Sheets' built-in functions, such as IMPORTDATA or IMPORTRANGE, to pull in data from these sources. For more complex data manipulation, I would leverage Google Apps Script to automate data fetching and processing. This script could be scheduled to run at regular intervals, ensuring the report is updated automatically each week. Additionally, I would use pivot tables and charts within Google Sheets to organize and visualize the data effectively. Throughout the process, I would ensure data accuracy and integrity by implementing validation checks and error handling. Finally, I would collaborate with relevant stakeholders to refine the report format and ensure it meets their requirements.