Home › Automations › Send an SMS when a Google Sheet row is added
Trigger: Row addedAction: Send SMS

Send an SMS when a Google Sheet row is added

Some updates can't wait for email. When a new lead, order, or alert row hits your sheet, Sheet Automation texts the right person immediately.

Add to Google Sheets — free See the template

Installs in 30 seconds · No credit card · Works inside Google Sheets

★★★★★ 4.9/5 · 500+ reviews · 300,000+ installs

What it does

This automation watches a sheet for newly added rows and sends an SMS through your Twilio account, with row values merged into the message via placeholders like {column_A}. Use it for urgent lead notifications, on-call alerts from monitoring sheets, or delivery updates to customers whose numbers are in the row.

How to set it up

  1. Install Sheet Automation from the Google Workspace Marketplace and open it from any sheet.
  2. Create a free Twilio account and copy your Account SID, auth token, and sender number.
  3. Pick the “Send SMS when a row is added” template, paste your Twilio credentials, and write the message.
  4. Save. Add a row to test — the text arrives in seconds.

The ready-made template

Send SMS when a row is added — Trigger: a new row is added → Action: send an SMS with the row values via Twilio. Edit it live below:

Loading preview…

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 SMS when a row is added”.
  4. Adjust the fields to match your data, then click Save.
  5. Trigger it once to confirm the automation runs.

FAQ

Do I need a Twilio account?
Yes — SMS delivery goes through your own Twilio account, so you control the sender number and costs.
Can the recipient number come from the sheet?
Yes. Use a placeholder like {column_D} as the recipient to text the number stored in each row.
Can I only text for certain rows?
Yes. Add a condition, e.g. only when the priority column equals urgent.

Related automations

Send a Slack message when a row is added Send an email when a cell is updated Post to Google Chat when a row is added Send a reminder when a due date arrives