Send email when a column is updated in Google Sheets

What it does

This automation watches a column you choose. When any cell in that column changes (and isn’t empty), it sends an email containing values from the same row. Great for status columns, assignments, new entries, and any column-as-trigger workflow — the right person hears about it the moment it changes.

How to set it up

1. Install Sheet Automation from the Google Workspace Marketplace and open it from your sheet.
2. Note the column you want to watch (e.g. A).
3. Pick the “Send email when a column is updated” template, set the column and recipient, and write the subject/body using {column_A} placeholders.
4. Save, then change a cell in that column to test — the email arrives instantly.

The ready-made template

Send email when a column is updated — trigger: a column is updated → condition: the cell isn’t empty → action: send an email with the row values. Edit it live below:

How to use this template

The builder above is a live preview of this automation. To run it in your own spreadsheet:

1. Click Add to Google Sheets to install Sheet Automation (free).
2. Open it from your sheet: Extensions → Sheet Automation → Open.
3. Open the Templates tab and choose “Send email when a column is updated”.
4. Set the watched column, recipient, and message to match your data, then click Save.
5. Change a cell in that column to confirm the email sends.

Related automations