Home
Install for SheetsInstall for Excel
Guide
Log SMS to Google Sheets: Zapier, Make or Two-Way Inbox
Sheet Gurus SMS Team
Sheet Gurus SMS Team
November 17, 2026
6 min

Log SMS to Google Sheets: Zapier, Make or Two-Way Inbox

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.

What is the fastest way to log SMS to Google Sheets?

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.

a phone showing a text conversation beside a Google Sheet where each message has become a row

How do you save incoming text messages to Google Sheets with Zapier?

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.

  1. In the sheet, name the first row’s columnsReceived, From and Body. Mapping works best when the headers exist before you build the Zap.
  2. In Zapier, create a Zap and choose Twilio, then “New SMS”, and connect your Twilio account.
  3. Add the action Google Sheets, “Create Spreadsheet Row”. Pick the spreadsheet and the tab.
  4. Map the sender number to From, the message text to Body and the timestamp to Received.
  5. Send a test text to your Twilio number, confirm the row appears, then turn the Zap on.

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.

How do you log incoming texts with Make?

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.

What about Apps Script instead of Zapier or Make?

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.

Do you need a log of every message, or a way to reply?

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:

  • tag conversations and filter by unread
  • search by phone number
  • assign a conversation to a team member
  • keep each reply linked to the recipient’s row in the sheet

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.

Can you read and answer replies from an iPhone?

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.

What does it cost to receive texts at volume?

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.

PlanPer segment500 replies3,000 replies
Starter$0.04$20$120
Growth$0.03$15$90
Profree 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.

Which setup suits which team?

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.

  • If the office needs an audit trail: it gives customers a Twilio number, and a Zap writes each text to a Replies tab with Received, From and Body, so the office manager can filter by number.
  • If dispatchers need to answer: they send appointment reminders from Sheet Gurus SMS and handle the replies in its inbox, assigning urgent ones and filtering for unread.
  • Cost check for the inbox route: at 500 replies on Growth, inbound is $15 on top of the $49 plan.

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.

FAQ

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.


Tags

save incoming text messages to google sheetssms to google sheets integration

Share

Related Posts

Are Text Appointment Reminders HIPAA Compliant? BAA Guide
November 05, 2026
7 min

Quick Links

HomeContact Us