Gmail

Use one row per person, then let the script send only the rows that have not already been marked as sent.

When someone changes a status dropdown in Google Sheets, email the address on that row, including on newly copied tabs.

Choose the email threads yourself by adding a Gmail label, then copy their attachments into an existing Drive folder.

Search your mailbox with GmailApp.search() for messages from one sender address, then call thread.addLabel() so those conversations are easy to find later.

Search your recent mail and add one row per message to a tab named Email log. A hidden ID column keeps a second run from adding the same message twice.

Give the script the file ID of a Doc. It makes a PDF copy and emails it as an attachment. The Doc itself is not changed.

Run the setup function once. Each Friday the script reads the Orders tab, counts the nonblank rows, totals column C, counts the rows that are not Done, and emails the account that installed it.

A setup function installs one daily trigger for the early evening. Each evening the script reads tomorrow on your main calendar and emails you the list.

Run the setup function once, then Apps Script calls the reminder function each day around your chosen hour.

Add a small response function, then install a form-submit trigger so each new answer produces a private email summary.

When the form collects verified email addresses, a form submit trigger can send the person who answered a short thank you that repeats their answers.

An hourly trigger fetches one address. The script remembers the last result in a script property, so a long outage produces one alert instead of one every hour.