Skip to content

boxlinknet/kwtsms-googlesheets

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

kwtSMS for Google Sheets

Version Google Sheets Apps Script License kwtSMS Arabic

Send bulk SMS from your Google Sheets spreadsheet using kwtSMS. The first Arabic-native SMS add-on for Google Workspace Marketplace.

About kwtSMS

kwtSMS is a Kuwait-based SMS gateway providing reliable A2P messaging across the GCC and 80+ countries. Trusted by businesses for bulk SMS, OTP delivery, and transactional notifications with Arabic-first support, competitive regional pricing, and 12 official client libraries.

Features

  • Bulk SMS from sheet rows with {Column Name} placeholders
  • Arabic and English UI with full RTL support
  • Phone validation for 83+ countries with per-country rules
  • Phone normalization (Arabic digits, country code prepend, format cleanup)
  • Message cleaning (emoji, hidden Unicode, HTML auto-stripped)
  • Smart batching (200 numbers/call, groups identical messages)
  • Delivery tracking per row (Status, Error, Message ID columns)
  • Sent message logs in a dedicated "kwtSMS Logs" sheet tab
  • Test mode support (no real delivery, credits recoverable)
  • Collapsible sidebar sections for clean workflow

How It Works

  1. Open the sidebar from Extensions > kwtSMS for Google Sheets
  2. Login with your kwtSMS API credentials
  3. Select the phone number column
  4. Compose your message with {Column Name} placeholders
  5. Preview, then send

Results are written back to your sheet: Status, Error, and Message ID for each row.

Requirements

  • A kwtSMS account with API credentials
  • Google Sheets

Development

npm install -g @google/clasp
clasp login
clasp create --type sheets --title "kwtSMS for Google Sheets" --rootDir src
clasp push
clasp open

Project Structure

src/
  Code.gs          Entry points, menu, sidebar handlers
  Api.gs           kwtSMS REST API client
  Phone.gs         Phone validation (83+ countries)
  Message.gs       Message cleaning + placeholders
  Send.gs          Bulk send with smart batching
  Logs.gs          Log sheet tab management
  Store.gs         PropertiesService wrapper
  i18n.gs          EN + AR translations
  Sidebar.html     Sidebar layout
  SidebarCss.html  Branded styles + RTL
  SidebarJs.html   Client-side logic
  Test.gs          Integration tests

Links

Security

To report a vulnerability, please open an issue.

License

Proprietary. All rights reserved.

About

Send bulk SMS from your spreadsheet. Arabic & English UI, column placeholders, delivery tracking. Free Google Workspace Marketplace Add-on.

Topics

Resources

Security policy

Stars

Watchers

Forks

Packages

 
 
 

Contributors