Automatically sends weekly waste summary emails from Google Form responses. Configurable schedule, recipients, and categorized item reporting.
Google Apps ScriptGoogle SheetsAuto-Emails
This is a Google Apps Script add-on for Google Sheets. It attaches to the spreadsheet that receives your Google Form responses and sends a formatted weekly summary email automatically.
Features
Reads weekly waste data from a Google Form response sheet
Sends a formatted HTML email with items grouped by category
Configurable send day, send time, and week start day
Primary recipient plus optional CC address
Duplicate-send protection — only sends once per week
Catches new or renamed form columns automatically in an “Other” section
Settings sidebar in Google Sheets — no need to edit the Config tab manually
Send Test Email button to preview without waiting for the scheduled day
Setup Steps
Open the Google Sheet that receives your waste form responses.
Create a new sheet tab named Config with these rows:
Column A
Column B
Send Day
Monday
Recipient Email
you@email.com
Week Start Day
Sunday
Last Sent
(leave blank)
CC Email
(optional)
Send Time
7 (24-hour format)
Open Extensions → Apps Script and paste the contents of Code.gs.
Run createDailyTrigger once to install the automation, or use the Waste Summary menu that appears in the toolbar.
Use Waste Summary → Settings to adjust the schedule and recipients without touching the Config sheet.
Use Waste Summary → Send Test Email Now to verify everything is working.