Forward SMS to Google Sheets one row for every text you receive.
To forward SMS to Google Sheets, pair your Android phone with SMS8 and connect it to a sheet with Zapier or Make: the SMS8 New Incoming SMS trigger, or Watch Incoming Messages in Make, adds a row with the sender and the message each time your phone receives a text. You get a live log of replies, opt-ins and survey answers that anyone on the team can sort and filter.
Prepare the sheet
Give the automation clear columns to fill.
Create a sheet
Make a new Google Sheet, for example "Incoming SMS".
Add headers
In row 1, add columns such as Received at, From, Message, Phone and SIM.
Keep row 1 fixed
Leave the header row in place so Zapier and Make can map each field to the right column.
Forward SMS to Google Sheets with Zapier
No code, a few minutes.
Add the SMS8 trigger
Create a Zap, search for SMS8.io and choose New Incoming SMS. Connect it with the API key from your SMS8 dashboard and test it with a text to your number.
Add the Sheets action
Add Google Sheets with the Create Spreadsheet Row action and pick your spreadsheet and worksheet.
Map the columns
Map the sender number to From and the message text to Message, and use the Zap run time for Received at.
Publish
Turn the Zap on. Each new text now adds a row.
Forward SMS to Google Sheets with Make
Best when you want the phone, SIM and timestamps too.
Add the SMS8 trigger
Create a scenario with the SMS8 Watch Incoming Messages instant trigger, connected with your API key.
Add the Sheets module
Add Google Sheets Add a Row and select your spreadsheet and sheet.
Map every field
Map the sender number, the message body, the device, the SIM slot and the timestamp to their columns.
Switch it on
Turn the scenario on and text your SMS8 number to see the first row appear.
Forward SMS to Google Sheets with n8n
In n8n, start with a Webhook trigger node and copy its production URL. In the SMS8 dashboard, open Webhooks, add that URL and tick the incoming message events. Then add a Google Sheets node that appends a row with data[0].number, data[0].message, data[0].deviceID, data[0].simSlot and data[0].sentDate from the webhook body. The payload is shown on forward SMS to a webhook, and the n8n side on the n8n SMS integration.
Sending from the same sheet
The SMS8 Google Sheets add-on works in the other direction: it sends a text to each row from your Android phone, by hand or on a trigger such as a new row or a changed cell. Use the add-on to send and a Zap or scenario to log the replies, and the whole conversation lives next to your list.
Useful sheets to build
- Reply log: every answer to a campaign, sorted by sender, so you can follow up with the people who replied.
- Keyword sign-ups: add a filter so only texts that contain a keyword, such as JOIN, become rows.
- Survey answers: ask a one-word question by SMS and count the answers with a pivot table.
- Codes and alerts: keep a record of verification codes and service alerts that reach a shared SIM.
What each row contains
The fields SMS8 hands to your automation.
From
The phone number that texted you.
Message
The body of the SMS as it arrived.
Phone and SIM
With Make, n8n or a webhook, the device and SIM slot that received it.
Time
Make and webhooks pass the timestamp; with Zapier, use the run time of the Zap.
Why choose SMS8 to log SMS in Google Sheets
Your own number feeding a sheet your team already uses.
Your own number
Texts arrive on the SIM in your own Android phone, the number customers already reply to.
02Flat price, unlimited messages
USD 29 a month for 1 phone, USD 89 for 5 and USD 229 for 20, with unlimited SMS and MMS and no fee per message. Yearly billing is half the price.
No A2P 10DLC filing
Messages go person-to-person from your SIM, so there is no brand or campaign registration.
Send and log in one place
Send from the sheet with the SMS8 Google Sheets add-on and log replies with Zapier or Make.
05Official apps and webhooks
Native SMS8 triggers in Zapier and Make, signed webhooks and a REST API.
Setup in minutes
Pair a phone, connect a sheet and the first row appears. 3-day trial with 30 messages, no card needed.
Related pages
The pieces behind this setup.
Google Sheets SMS add-on
Send texts from a sheet through your Android phone.
Open the Sheets pageZapier SMS integration
New Incoming SMS trigger and Send SMS action.
Open the Zapier pageSMS8 API documentation
Webhook events, payload and signature.
Read the docsPricing
Flat monthly plans per connected phone, unlimited SMS and MMS.
See pricingPair your Android phone with SMS8, then build a Zap with the SMS8.io New Incoming SMS trigger and the Google Sheets Create Spreadsheet Row action, or a Make scenario with Watch Incoming Messages and Add a Row. Each text becomes a new row.
The add-on is for sending texts from a sheet. To log incoming texts in a sheet, use Zapier, Make or n8n as described on this page. Replies are also kept in the SMS8 inbox.
Yes. Add a Filter in Zapier or a filter on the route in Make, for example to keep only texts that contain a keyword or come from one phone.
Yes. All paired phones on the account trigger the same Zap or scenario. Map the phone and SIM fields to a column in Make or n8n to tell them apart.
SMS8 is USD 29 a month for 1 phone, USD 89 for 5 and USD 229 for 20, with unlimited SMS and MMS. Zapier, Make and n8n plans are billed by those services.
Log every text in a sheet
Pair a phone, connect Google Sheets and each incoming SMS becomes a row. 3-day trial with 30 messages, no card needed.