Tutorial

Send SMS from Google Sheets with clear, separate steps

Start with SENDSMS, then move to scheduling and branded sender IDs when you need them.

1. Install the add-on2. Use `SENDSMS`3. Schedule messages4. Use sender IDs

1. Install the add-on

Install Sheet SMS from the Google Workspace Marketplace, then open any spreadsheet and launch it from Extensions > Sheet SMS.

  1. Visit the Sheet SMS Google Workspace Marketplace page.
  2. Click Install and approve the permissions.
  3. Open a sheet and launch the add-on from the top menu.

2. Send your first message with `SENDSMS`

`SENDSMS` is the main formula for sending a text message straight from your sheet. Use it when you want an immediate send, not a scheduled one.

=SENDSMS(message, phone_number)

Example

=SENDSMS("Your order is ready", "+14155550199")

Tip

You can also use cell references like =SENDSMS(A2, B2) when your message and number are stored in the sheet.

3. Schedule SMS for later with `SCHEDULESMS`

Use `SCHEDULESMS` when you want the message to go out at a specific date and time instead of immediately.

=SCHEDULESMS(message, phone_number, date, time)

Example: =SCHEDULESMS("Don't forget our meeting!", "+14155550199", "12/25/2026", "14:30")

4. Use a branded sender with `SENDSMSWITHSENDER`

If you want messages to appear from your business name, use the custom sender formula. This is useful for branded notifications and one-way alerts.

=SENDSMSWITHSENDER(message, phone_number, custom_sender)

Example: =SENDSMSWITHSENDER("Your delivery is ready!", "+447123456789", "ACMECO")

Custom sender IDs can be up to 11 characters and are approved before first use.

5. Check your spreadsheet timezone

Timezone matters for scheduled sends. If your sheet timezone is off, `SCHEDULESMS` will fire at the wrong time.

  1. Open your Google Sheet.
  2. Click File > Settings.
  3. Check the Time zone field in the General tab.
  4. Save the settings if you change anything.

Common questions

Can I send SMS in bulk from one spreadsheet?

Yes. Many teams keep phone numbers, variables, and message templates in one sheet, then send row by row.

Do scheduled sends require the sheet to stay open?

No. Once the schedule is registered, the backend handles delivery.

Next: read the pricing page, the SCHEDULESMS guide, and the opt-in requirements.