Most teams that want to log SMS to Google Sheets need one of two things: a row for every text that arrives, or a way to answer those texts without leaving the spreadsheet they already work in. They are different jobs, and the tools that do one rarely do the other. This guide covers both, with the setup for the first and where a two-way inbox fits for the second.
The fastest way is a no-code automation: point a Twilio number at Zapier or Make, and each incoming text becomes a new row.
The shape is always the same. A trigger fires when a text arrives at your number, and an action writes a row. Zapier’s template uses the Twilio “New SMS” trigger, which fires when an SMS is sent to your Twilio number, followed by the Google Sheets “Create Spreadsheet Row” action. Make offers a ready-made
Twilio to Google Sheets template that adds a row each time you receive or send an SMS through Twilio.Texts that arrive on a personal iPhone number cannot be logged this way. Twilio can only forward messages sent to a Twilio number, so every route in this guide needs a business number that customers text.

You build a two-step Zap: Twilio “New SMS” as the trigger and Google Sheets “Create Spreadsheet Row” as the action. You need a Twilio account, a Google account and a sheet with a header row.
Received, From and Body. Mapping works best when the headers exist before you build the Zap.From, the message text to Body and the timestamp to Received.Two details matter. First, the Twilio trigger is a polling trigger, and on Zapier’s free plan Zapier checks for new messages every 15 minutes, so rows can lag behind the texts. Second, Zapier offers Filter and Formatter steps, but adding either makes a multi-step Zap, which Zapier’s Free plan (two-step Zaps) does not cover. On the Free plan you get the plain two-step log with no filtering. On a plan with multi-step Zaps, a Filter step can keep opt-out replies such as STOP out of the main log, and a Formatter step can turn the raw timestamp into a date your team can read.
Twilio also requires you to register a number before it can send SMS traffic to US and Canadian mobile numbers, and that applies to a number you set up for this too. Check the current rules in Twilio’s own documentation before you promise a go-live date.
In Make, you use the Twilio and Google Sheets apps in one scenario, or start from Make’s template and swap in your own sheet. The logic is the same as the Zap: a Twilio module watches for messages and a Google Sheets module adds a row.
The template’s description does not say whether the sheet records direction, because it handles messages you receive and messages you send. If you only want inbound texts, add a filter on the direction or recipient number, or add a Direction column so you can filter later. Make is worth a look when you want to branch, for example writing urgent keywords to a second tab.
Apps Script is the free option, and it asks the most of you. Twilio’s own Apps Script tutorial deploys a script as a web app and sets the number’s “A message comes in” webhook to its URL. It is a 2018 post, so check it against the current Twilio console.
Twilio also publishes a separate code route, a Code Exchange template that logs the message text, the sender and the time received. It is not Apps Script: it deploys as a Twilio Function app and needs a Google service account.
Choose the Apps Script route if you have someone who can read and fix a small script. It costs no automation subscription, but nobody on the ops team can adjust it without code. For a wider comparison of the build options, see our buyer’s guide to integrating Google Sheets with SMS.
If the goal is a permanent record, a row per message is right. If the goal is handling the conversation, a row log is a poor tool, because a sheet cannot show who owns a reply, which ones are unread or what was said last.
A two-way inbox covers that second job. Sheet Gurus SMS is a Google Sheets add-on (and works in Microsoft Excel too) that sends from a sidebar. Its inbox lets you:
The inbox is where replies to Sheet Gurus SMS messages are read and answered. If a spreadsheet row for every text is the requirement, use your own Twilio number with one of the automations above. The two are alternatives for different numbers or jobs, not one log fed by the other.
Yes. Users can see replies and answer them from the inbox on the Sheet Gurus website after signing in, including on an iPhone. That matters for field teams who are not at a desk. Our write-up of what actually works on iPhone goes into the details.
Automation tools charge for their own tasks and plans, while a two-way inbox charges for inbound messages by segment, so the sums differ. On Sheet Gurus SMS, inbound replies are billed at your plan’s per-segment rate on Starter and Growth and are free on Pro. Paid plans include no bundled credits.
Here is the monthly cost of receiving 500 and 3,000 single-segment replies, using the published rates. Plan fees are extra: Starter is $9, Growth $49 and Pro $99 a month.
| Plan | Per segment | 500 replies | 3,000 replies |
|---|---|---|---|
| Starter | $0.04 | $20 | $120 |
| Growth | $0.03 | $15 | $90 |
| Pro | free inbound | $0 | $0 |
The totals above assume one 160-character segment per reply and exclude the cost of the messages you send. Add the plan fee for the full picture: at 3,000 replies a month, Pro ($99) is below Starter ($9 plus $120) and Growth ($49 plus $90). At 500 replies, Starter ($29) and Growth ($64) both cost less than Pro. See the pricing explainer for how segments are counted. Zapier and Make price by tasks or operations, so check their current plans for your volume.
Pick the automation when you need every inbound text recorded, and pick the inbox when people need to answer. Here is a worked example for a plumbing office that gets about 500 texts a month from customers confirming appointments.
Replies tab with Received, From and Body, so the office manager can filter by number.Sheet Gurus SMS does not send anything automatically when a new row appears: it has no triggers yet, so every send is started or scheduled from the sidebar. If you are new to the sidebar, start with getting started with Sheet Gurus SMS or our guide to sending text messages from Google Sheets.
Can Google Sheets receive text messages on its own? No. Sheets has no phone number, so something must receive the text first, usually a Twilio number plus an automation or script.
Is there a free way to save incoming texts to Google Sheets? Yes. Zapier has a free plan, though it checks for new messages every 15 minutes and has no filtering, and Apps Script costs nothing beyond Twilio’s own usage charges.
Do replies appear as rows in the Sheet Gurus SMS inbox? Replies appear in the sidebar inbox and stay linked to the recipient’s row. The Zapier and Make setups above apply to texts sent to your own Twilio number.
Does Sheet Gurus SMS work outside the US and Canada? No. It supports the US and Canada only.
Want more guides on texting from spreadsheets? Subscribe to our newsletter for new articles by email.