Generate weekly summary report from Google Sheets data and add to designated spreadsheet

Generate weekly summary reports by retrieving data from Google Sheets, processing date information, and adding the summary to a designated spreadsheet for easy access and review.