Skip to content

Data & spreadsheets

Google Sheets

Send from a sheet with a few lines of Apps Script.

Apps Script can call the SMS Bridge API directly with UrlFetchApp, so a sheet can send one SMS per row. For large lists, the Campaigns page accepts pasted rows with variables.

How it connects: Google Sheets calls the SMS Bridge API itself — no extra tool needed. Your API base is https://api.99billingsolutions.com.

What you can do

  • Send one SMS per row
  • Personalise with values from other columns
  • Mark each row as sent

Setup

  1. Open Extensions → Apps Script and store your API key under Project Settings → Script properties as SMS_BRIDGE_KEY.
  2. Call UrlFetchApp.fetch(API_BASE + '/v1/messages/send', { method: 'post', contentType: 'application/json', headers: { 'x-api-key': key }, payload: JSON.stringify({ from_number, to_number, content }) }) for each row.
  3. Run it from a custom menu or a time-driven trigger. Mind the phone's pace of about 25 messages per 30 minutes.

Field names and error codes are in the send message reference; webhook payloads and signatures in Webhooks. Missing something? Tell us.