Using Google Sheets to send SMS

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.

Get the file

Open the template or create your own spreadsheet from scratch.

Add configuration

Insert token, device_id and sim into the config sheet.

Authorize the script

Google will ask you to grant permissions the first time you run it.

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 0 for SMS

1 — SIM slot 1 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.

Open Google Sheet template View script

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 |  |  |

Domanda e risposta

The most important things to know before you begin.

Do I need to edit the script to add token and device_id?

No. Your api_token, device_id and sim are loaded from the config sheet, not hardcoded in the script.

Where can I find token and device_id?

Why should I use my own copy of the template?

Each user should work with their own spreadsheet copy and private configuration values for security and easier maintenance.

Video tutorial

Watch how to configure Google Sheets and start sending SMS step by step.

SmsGateWay24 - Tutorial Di Youtube

Iscriviti e ti piace il video 😁

Canale ufficiale smsgateway24 su YouTube

Ready to start?

Open the Google Sheets template, add your configuration and send your first SMS campaign directly from the browser.

Open template View script

Works on any platform: Windows, macOS and Linux.

Accesso rapido

Using google sheets to send sms