Daily Google Sheets Macro Automation

I have a small but important workflow housed in Google Sheets that I’d like to turn into an efficient, lightweight macro. While I’ll confirm the exact actions once we start—be it auto-filling new rows, refreshing calculations, or rolling up numbers into a summary tab—the key requirement is that the script fires every single day without me having to touch it.

I’m leaning on your expertise to choose the most reliable trigger method and to write clean, well-commented code so future tweaks are simple. You’ll also need to walk me through any one-time permissions or scheduling steps inside the spreadsheet so the job runs consistently.

Deliverable:
• A fully functional, commented script installed in my Google Sheet and set to run daily.
• A brief setup/read-me outlining how to adjust the schedule or edit the logic later.