Google Sheets

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.

Keep a person and a project note in a Sheet, then create one short Doc per unfinished row.

Use an onOpen() simple trigger and SpreadsheetApp.getUi().createMenu() to add a custom menu bar item that shows which cell is currently selected.

Change a status cell and the script stamps the same row with the current date and time. There is nothing to install beyond saving the script.

Check an Active checkbox on a Students tab and an onEdit trigger appends a tracking row to your Tracking tab once, then marks the source row Tracked so re-checking does not add a duplicate.

A Google Sheets custom function is a top-level Apps Script function you call from a cell like a built-in formula, with an optional @customfunction tag for formula autocomplete. This guide converts Celsius to Fahrenheit for one cell or a range.

The script reads your list, keeps the first row for each email address, and rewrites a tab named Clean. The source tab is never changed.

Rows with the status Done are copied to the bottom of an Archive tab and then removed from Tasks. This one deletes rows, so test it on a copy of the file first.

Each row that has no link yet gets its own copy of your template Doc, with the placeholders swapped for the values in that row. The link to the copy goes back in the last column.

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.

The script reads Open-Meteo once and replaces only Forecast!A1:C12 after checking the response and the destination. It preserves the source and licence links beside the forecast.

Keep one planned event per row in a tab named Events. The script creates the events that have no ID yet and writes the new ID back into the row.

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.

Run the setup function once. Every Monday morning the script copies the spreadsheet into a Drive folder and puts the date in the copy name. The original is never touched.