Send SMS with Google Sheets

Updated 1 month ago

Easily and quickly send SMS notifications, reminders, alerts, invitations - anything directly from Google Sheets. Get the free add-on here.

This article will guide you how to use the SMS add-on in Google Sheets:

How to Install the ClickSend SMS Google Sheets Add-On

  1. Install the add-on from Google Workspace Marketplace to your Google Sheets account.
  2. Click 'Allow' to consent to permissions.

Send SMS from Google Sheets

  1. Open a Google Sheet from your Google Drive and look for Extensions / Add ons in the menu bar. Open ClickSend SMS - Sheets and click the Send option.
  1. You will be then required to add your ClickSend API credentials to connect.
    - 'username' is the username you use in ClickSend
    - 'api_key' is the API key found in the ClickSend dashboard here.
    Save to connect.
  2. To start sending, compose your message. To save time, the most recent sent message will be saved by default.
    Pick up the phone numbers you want to send SMS to and click Next.
Users can only pick 1,000 phone numbers at a time. If sending more than that volume, use Send SMS Campaigns in ClickSend dashboard.
  1. The add-on calculates the cost depending how long your message and what countries you are sending to.
    If you want to change your selection of phone numbers, reselect cells and click the refresh / update button to pick them up and re-calculate cost.
    You can choose to schedule when your message is to be sent. Or select Send Now to send immediately.
  2. Click 'Confirm Send SMS' when done.
    You will be see a confirmed status, showing that your SMS has been sent.
    You can monitor your sent messages in the SMS History.
    Click Send another SMS to send new batch of messages.

Sender Number Settings

  1. Under the Extension Settings you can update Sender Number to use for sending messages.
    Here's how to go to Settings.
  2. Sender Number is a text input field. It means it allows alphanumeric not exceeding 11 characters without space. Also it acts as a dropdown to fetch the dedicated numbers you have purchased on your ClickSend account.

That's it! Now you can send individual or bulk text messages from Google Sheets.

Sign Out of ClickSend SMS

Sign out when you want to log off the add-on. This can also be found in Settings.

Reconnecting ClickSend account is done under Send option.

Installation Troubleshooting

There's a google limitation on which you can only install the add-on on a single account only. If you would like to install the ClickSend Add-On to multiple accounts within a single browser, try one of the following solutions:

  • Log out of all your Google Accounts and only log in to the one that has the add-on.
  • Open an incognito window in Google Chrome, or an equivalent private browsing window, and log in to the Google Account that has the add-on.

More info


How Did We Do?


Powered by HelpDocs (opens in a new tab)