How to set up Google Sheets integration?
With our free add-on, sending SMS notifications, reminders, alerts, invitations, and more directly from Google Sheets is fast and effortless. Download it now.
Here is a step-by-step instruction on how to use the SMS add-on in Google Sheets.
How to Install the Cellcast SMS Google Sheets Add-On
Step 1. Install the add-on from Google Workspace Marketplace to your Google Sheets account.
Step 2. Click ‘Allow’ to consent to permissions.
Send SMS from Google Sheets
Step 1. Open a Google Sheet from your Google Drive and look for Extensions / Add ons in the menu bar. Open Cellcast SMS - Sheets and click the Send option.
Step 2. You will be then required to add your Cellcast API credentials to connect.
– ‘username’ is the username you use in Cellcast
– ‘api_key’ is the API key found in the Cellcast dashboard here.
Save to connect.
Step 3. 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.
Step 4. 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.
Step 5. 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
Step 1. Under the Extension Settings you can update Sender Number to use for sending messages.
Step 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 Cellcast account.
That’s it! Now you can send individual or bulk text messages from Google Sheets.
Sign Out of Cellcast SMS
Sign out when you want to log off the add-on. This can also be found in Settings.
Reconnecting Cellcast 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 Cellcast 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.
Find out more: HERE
We hope this tutorial was helpful!
If you need further assistance, you can reach our customer support team on (03) 8560 7025, get on Livechat, or send us an email at support@cellcast.com.au