Log in
Using google sheets to send sms
Download the latest version of the application
Option 1: Use the ready-made template
Recommended if you want the fastest possible setup.
1. Open the shared Google Sheet
Open the template and save your own copy to Google Drive.
2. Go to the config sheet
Fill in api_token, device_id and sim.
3. Add recipients and messages
Return to the main sheet and fill in phone numbers and message texts.
4. Refresh and run
Reload the page, open the SMS Gateway menu and run the sending function.
Option 2: Add the script manually
Recommended if you want full control over your spreadsheet structure.
1. Create a new Google Sheet
Create a blank spreadsheet in Google Sheets.
2. Add the required sheets
Create the main sheet and another sheet named exactly config.
3. Open Extensions → Apps Script
Delete the default code and paste the script from the repository into Code.gs.
4. Save, authorize and use
Save the project, refresh the spreadsheet, authorize the script and start sending messages.
How to set it up
A simple workflow to start sending SMS from Google Sheets.
1
Get the file
Open the template or create your own spreadsheet from scratch.
2
Add configuration
Insert token, device_id and sim into the config sheet.
3
Authorize the script
Google will ask you to grant permissions the first time you run it.
4
Run sending
Use the custom SMS Gateway menu to send messages from the sheet.
Required spreadsheet structure
Use the following columns in the main sheet and config sheet.
Main sheet
phone | name | message | timetosend | customerid | urgent | status | response | sms_id
Config sheet
key | value api_token | your_token_here device_id | 12345 sim | 0
SIM and channel values
Choose which channel will be used for sending.
0 — SIM slot 1 for SMS
1 — SIM slot 2 for SMS
2 — WhatsApp Business
3 — WhatsApp Personal
4 — RCS channel 1
5 — RCS channel 2
Important notes
A few things to check before you start using the spreadsheet in production.
Phone column format
Set the phone column format to Plain text so the + sign is preserved.
Do not share your token
Each user should work with their own private copy of the spreadsheet and their own config values.
Configuration is loaded from the sheet
The script does not hardcode api_token, device_id or sim in the code.
Recommended workflow
Create your own copy of the template, fill in the config sheet and manage all messages from the main sheet.
Ready to try?
Save your own copy of the Google Sheet template and start sending messages directly from the browser.
Works in the browser and is a convenient alternative to Excel macros.
Example data row
Example of one message row in the main sheet.
+4917660188224 | John Doe | Hello John, this is a test message | 2026-04-08 18:00:00 | 1001 | 1 | | |
Question and answer
The most important things to know before you begin.