Back to Free Tools

Google Sheets SMS Formula Generator

Construct custom Sheet SMS formulas for instant sending, custom branding, scheduling, or recurring messages.

Configure Your Formula

Enter a cell reference (e.g., A2) or custom text (e.g., "Hello World").
Enter a cell reference (e.g., B2) or a static number (e.g., "+123456789").

Your Custom Formula

Copy this formula directly into any cell of your Google Sheet or Excel file:

=SENDSMS(A2, B2)

Formula Tips

  • Make sure to install the Google Sheets add-on first.
  • Write formulas in uppercase.
  • Drag the bottom-right corner of the cell down to apply the formula to multiple rows.
  • Ensure numbers are formatted in standard international format (+1234567890).

How to Use Custom Formulas in Google Sheets

Once you have installed the Sheet SMS add-on from the Google Workspace Marketplace, you can start writing formulas directly in your grid cell rows. Google Sheets treats these functions exactly like native formulas (such as SUM or AVERAGE).

When you enter a formula like =SENDSMS(A2, B2), Sheet SMS will read the message content from column A, the phone number from column B, and dispatch the SMS. Once sent, the cell status will automatically update to "Sent" (or display an error code if the number is incorrect or account credits are low).

Formula Options Explained

  • SENDSMS: The simple, direct method. Just pass the message text and recipient number.
  • SENDSMSWITHSENDER: Sends messages displaying your custom brand name instead of a standard phone number. Perfect for corporate trust and higher click-through rates.
  • SCHEDULESMS: Schedules a message to go out on a specific future date and time. Ideal for appointment reminders.