How to Use SENDSMS Formula in Google Sheets

The SENDSMS formula lets you send SMS messages directly from your Google Sheet. Here’s how to use it:

1. Install the Sheet SMS add-on from the Google Workspace Marketplace.
2. Enable the add-on in your Google Sheet.
3. Use the formula: SENDSMS("Your message", "+1234567890")
4. Replace "Your message" with your text and "+1234567890" with the recipient’s phone number.
5. Press Enter. Your SMS will be sent automatically.

Tip: You can use cell references for dynamic messages and numbers, e.g. SENDSMS(A2, B2).

Back to Setup