Formula guide

How to Send SMS from Google Sheets with the SENDSMS Formula

Send a text message directly from a Google Sheet using a simple formula. Keep the phone number and message in spreadsheet cells, then use SENDSMS for an immediate SMS send without API keys or code.

Install Sheet SMS Open Dashboard

Quick answer

=SENDSMS(message, phone_number)

Use the formula with cell references for repeatable spreadsheet workflows. Test one opted-in recipient first, then expand the workflow after the result is correct.

Step-by-step setup

  1. 1Install Sheet SMS from the Google Workspace Marketplace.
  2. 2Create columns for the message and phone number.
  3. 3Enter the formula in a new column and press Enter.
  4. 4Use an international phone format such as +14155550199 and confirm the send in your message history.

Examples you can copy

Text in the formula

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

Use spreadsheet cells

=SENDSMS(A2, B2)

Personalize from columns

=SENDSMS("Hi "&A2&", your appointment is tomorrow", B2)

What SENDSMS does

SENDSMS is the standard Google Sheets SMS formula for an immediate send. The first argument is the message body and the second argument is the recipient phone number. Cell references make it easy to fill the formula down a list of contacts.

SENDSMS versus SCHEDULESMS

Use SENDSMS when a message should go now. Use SCHEDULESMS when a reminder or campaign should be sent later at a specific date and time. For a branded business name where supported, use SENDSMSWITHSENDER.

Before sending

Use consented contacts, check the country code, keep promotional copy compliant, and make sure your account has SMS credits. Avoid repeatedly editing and re-entering a formula after a successful send because that can create a duplicate message.

Frequently asked questions

Can Google Sheets send SMS without coding?

Yes. Sheet SMS adds custom spreadsheet formulas so you can send from rows and columns without building an API integration.

Why is my SENDSMS formula not sending?

Check that Sheet SMS is enabled, the number includes an international prefix, your account has credits, and the formula has not already sent successfully.