How do I send a notification to my phone from Google Sheets?

Google Sheets can't buzz your phone on its own, but Apps Script can make an outbound HTTP request — and that's all Lert needs. Your unique Lert link is the credential, so there's no OAuth flow, no API key to store, and no library to import. You paste one URL into a script and you're done.

The entire setup — under 30 seconds

1. Download the app. Open it once. There's no account to create, and your private link is waiting on screen.
2. Copy your link. One tap copies something like https://lert.dev/p/your-id.
3. Add the Apps Script. In your sheet, open Extensions → Apps Script, paste the snippet below, and call it wherever you want a ping.

Then your phone buzzes — instantly, even locked in your pocket.

The Apps Script

function notifyPhone(title, body) {
  const url = "https://lert.dev/p/your-id";
  UrlFetchApp.fetch(url, {
    method: "post",
    contentType: "application/json",
    payload: JSON.stringify({ title: title, body: body })
  });
}

// Call it from onEdit, a time trigger, or a menu action:
function onEdit(e) {
  if (e.range.getA1Notation() === "B2") {
    notifyPhone("Sheet updated", "B2 changed to " + e.value);
  }
}

Wire notifyPhone into an onEdit trigger to ping when a cell changes, a time-driven trigger to ping on a schedule, or a custom menu item to fire on demand. No headers beyond content type, no auth token.

Related things people automate

• Get pinged when a price hits a target
• Send yourself a reminder from a script
• The easiest way to notify your phone from anywhere
• Alert on a database or spreadsheet value
• Notify when a scheduled job runs

It's free for one channel and 50 notifications a day; Lert Pro is $2.99/month for unlimited. See the docs for the full API, or the answers index for more recipes.