Retrieve previous month date, look up rows in Google Sheets, and create multiple rows

Retrieve previous month’s data weekly, format it, and look up multiple rows in Google Sheets to create new entries. Achieve efficient data management and enhance reporting accuracy with this streamlined process.