Part of the guide SMS Integrations: Zapier, Make, n8n, WordPress, Google Sheets
On this page
Key takeaways
- Put a Number column and a Message column in a Google Sheet, then send each row through SMS8 with a short Apps Script or the built-in Google Sheets connector.
- Messages go out from your own phone and SIM, so recipients see your real number, not a short code or a rented line.
- Use merge tags like
{Name}to personalize every row from other columns in the sheet. - There is no per-message fee. The cost is your normal phone plan, so a 2,000-row send costs the same as texting from your own pocket.
- Sending runs at a natural pace from the phone, which keeps your SIM clear of carrier spam filters on larger lists.
A spreadsheet is where most small teams already keep their contacts. So the shortest path to texting those people is to send straight from the sheet, without exporting a CSV or pasting numbers into another tool. With SMS8 you pair an Android phone once, add two columns to your sheet, and every row becomes a personalized SMS from your own number. This guide shows the simple no-code route, a copy-paste Apps Script for full control, how merge tags work, and an honest note on limits and cost.
If you would rather send from a page with a drag-and-drop uploader, the bulk SMS guide covers the dashboard flow. For wiring sheets into other steps, see forwarding replies back into a sheet.
Why send from a sheet instead of a cloud SMS tool?
| From your own phone (SMS8) | Cloud SMS provider | |
|---|---|---|
| Sender number | Your real mobile number | A rented number or short code |
| Per-message cost | None, it uses your plan | A fee per message, plus carrier fees |
| Registration | None, pair the phone and send | Carrier registration for many routes |
| Where contacts live | Stay in your sheet | Usually uploaded into their system |
| Replies | Come back to one shared inbox | Depend on the plan and number type |
The practical upshot: if your list is a few thousand people you already have a relationship with, texting them from your own number from the sheet is cheaper, simpler, and lands as a message people recognize.
Set up the sheet
Make a sheet with a header row. Only Number is required. Everything else is optional and becomes a merge tag.
| Number | Name | City |
|---|---|---|
| +14155550100 | Alex | New York |
| +447911123456 | Jane | London |
Write numbers in international format with the country code, like +14155550100. A column called Message can hold a different message per row, or you can send one message to everyone and pull names from the other columns.
Option 1: the no-code Google Sheets connector
In the SMS8 dashboard, open Integrations and connect Google Sheets. Pick your sheet, map the Number column, write one message with merge tags, and send. SMS8 reads each row and queues a personalized SMS from your phone. This is the right choice if you do not want to touch code.
See the step-by-step connector guide on the integrations page.
Option 2: a copy-paste Apps Script
If you want the send button to live inside the sheet, use Apps Script. In your sheet open Extensions → Apps Script, paste the code below, set your API key, and run sendSheet. Each row with a number gets one SMS from your paired phone.
const SMS8_API_KEY = 'YOUR_API_KEY'; // from app.sms8.io → Developers → API
const SMS8_ENDPOINT = 'https://app.sms8.io/api/v1/messages';
function sendSheet() {
const sheet = SpreadsheetApp.getActiveSheet();
const rows = sheet.getDataRange().getValues();
const header = rows.shift().map(h => String(h).trim());
const iNum = header.indexOf('Number');
const iMsg = header.indexOf('Message');
rows.forEach(row => {
const number = String(row[iNum] || '').trim();
if (!number) return;
// Build the message: use the Message column, or a template with merge tags.
let message = iMsg >= 0 ? String(row[iMsg] || '') : 'Hi {Name}, a quick note from us.';
header.forEach((col, i) => {
message = message.replace(new RegExp('\\\\{' + col + '\\\\}', 'g'), String(row[i] || ''));
});
UrlFetchApp.fetch(SMS8_ENDPOINT, {
method: 'post',
headers: { 'X-Api-Key': SMS8_API_KEY },
payload: { number: number, message: message },
muteHttpExceptions: true,
});
Utilities.sleep(1200); // gentle pace, kinder to your SIM
});
}
The Utilities.sleep line spaces messages out. SMS8 also paces sends from the phone, so your SIM is not hit with a burst that trips a carrier filter. For the full list of fields you can add, like type=mms or a schedule time, see the API documentation.
How do merge tags work?
Any column header can be used as a tag in curly braces. If your sheet has a Name column and a City column, a message like this:
Hi {Name}, your order ships to {City} tomorrow.
becomes "Hi Alex, your order ships to New York tomorrow." for the first row. Keep tags spelled exactly like the header, including capital letters. A tag with no matching column is sent as written, so check the preview before a large send.
What does it cost to send from a sheet?
Nothing per message. SMS8 charges a flat subscription for the gateway, and the messages themselves ride your phone's own plan. A cloud provider charges for each text: Twilio lists USD 0.0083 per outbound US SMS segment before carrier fees, as listed on their site in November 2026, so a single 2,000-message send is about USD 16 in message fees alone, every time you run it. From your own SIM on an unlimited-texts plan, the same send is included in what you already pay.
For a full breakdown, the cost of per-message SMS article does the math across list sizes.
Limits worth knowing
- Carriers rate-limit personal SIMs. Very large lists should be spread over hours, not minutes. SMS8's natural pacing handles this, and a daily cap per phone keeps you safe. Add more paired phones to send more in a day.
- Keep the phone online. The SMS8 app sends in the background, but the phone needs signal and should stay powered. On Android, exclude the app from battery optimization so it is not put to sleep.
- Respect consent. Text people who expect to hear from you, and offer a way to opt out. It keeps your number healthy and your list clean.
FAQ
Can I send to a few thousand rows at once?
Yes. Queue the whole sheet and SMS8 sends them at a natural pace from your phone, spreading a large list over time and across any extra phones you have paired. Nothing is dropped.
Do I need Zapier or Make for this?
No. The Google Sheets connector and the Apps Script both talk to SMS8 directly. You can still use Zapier or Make if a sheet change should trigger a text as part of a bigger flow.
Will replies come back to the sheet?
Replies land in your SMS8 shared inbox, and you can forward them into a sheet with the reply-to-Sheets integration, so a conversation stays in one place.
Which phone should I use?
Any Android phone with a SIM and the free SMS8 app. An old spare phone on a cheap unlimited-texts plan is a common setup. See the old-phone gateway guide.