Source: Google Sheet

Watches rows and cells in one tab of a spreadsheet you have access to.

Setup

  1. Connect your Google account if you haven’t already.
  2. Choose a spreadsheet using the Google Drive picker.
  3. Optionally choose a sheet tab — defaults to the first tab if you leave it blank.

Saving takes a snapshot of the sheet as it is right now; the automation starts reacting on the next change.

Triggers

New row added

Fires when a new row appears at the bottom of the sheet. Built for append-only use — rows from a connected Google Form, a FileDrop form syncing in, or anything else added at the bottom. Rows inserted in the middle of existing data aren’t reliably detected as “new.”

Cell / status change

Fires when any cell in an existing row is edited. Optionally narrow it down:

  • Column (optional) — only fire when this specific column changes (letter like B, or a header name like Status).
  • Only when new value equals (optional) — only fire when the cell’s new value matches exactly, e.g. Approved.

Use both together for things like “only when the Status column changes to Approved.”

Scheduled {#scheduled}

Runs on a timer instead of reacting to edits — hourly, daily at a chosen time, or weekly on a chosen day and time, all in a timezone you pick. This is the only trigger available for sheet maintenance tasks: Remove duplicates and Backup sheet only run on a schedule, not on individual row changes.

Conditions

Filter by any column — type a letter (B) or a header name (Status, Priority). All the standard condition types are available: is/isn’t empty, equals/not equals, contains, starts/ends with, is one of/is none of a list.

Actions you can use

Most actions work with this source. The ones built specifically around a spreadsheet row are the most useful here: New row, Copy row, Move row, and Update cell. You can also send notifications (Email, Slack, Google Chat, Webhook), work with Drive files and folders (Create folder, Find/create Doc, Append Doc, Replace Doc), and send a Send invite. Remove duplicates and Backup sheet are available only when using the Scheduled trigger. See the actions guide for details.

Ideas

  • New row → notify your team: New row trigger, Email or Slack action pulling in values with {column:Name}, {column:Email}, etc.
  • Status change → notify + log it: Cell change trigger scoped to a Status column and value, Email action followed by Update cell to stamp a timestamp back into the row.
  • Route rows to different sheets: New row trigger, Copy row or Move row with the target spreadsheet set by {column:Region} so different rows land in different sheets automatically.
  • Weekly cleanup: Scheduled (weekly) trigger, Remove duplicates keyed on an email column.
  • Weekly backup (Pro and above): Scheduled trigger, Backup sheet action.