Want a searchable spreadsheet of every SMS your iPhone receives? With Fwrdly’s webhook feature and a free Zapier or Make account, you can automatically log every text message to Google Sheets — sender, message body, and timestamp.
Why Log SMS to Google Sheets?
- Track OTP and verification codes with timestamps for compliance
- Monitor delivery and shipping notifications in one place
- Log customer texts from a business number for CRM-style tracking
- Build reports on SMS volume, frequent senders, or keyword patterns
- Share a live sheet with your team — everyone sees incoming messages
What You’ll Need
- iPhone with Fwrdly installed
- A Google account (for Sheets)
- A free Zapier or Make account
- 10 minutes
Method 1: Fwrdly + Zapier + Google Sheets
Step 1: Create the Zap
- Go to zapier.com and create a new Zap
- Trigger: Webhooks by Zapier → Catch Hook
- Copy the webhook URL Zapier gives you
Step 2: Connect Fwrdly
- Open Fwrdly → Add destination → Webhook / API
- Paste the Zapier webhook URL
- Send a test message to train Zapier’s data structure
Step 3: Add Google Sheets Action
- In Zapier, add an action: Google Sheets → Create Spreadsheet Row
- Connect your Google account
- Select your spreadsheet and sheet
- Map fields: Column A = Sender, Column B = Message, Column C = Timestamp
- Turn on the Zap
Now every SMS lands in your spreadsheet within seconds.
Method 2: Fwrdly + Make + Google Sheets
- Create a new scenario in Make
- Add a Webhooks module → Custom webhook → copy URL
- Paste into Fwrdly as a Webhook destination
- Send a test SMS to define the data structure
- Add a Google Sheets module → Add a Row
- Map sender, body, and timestamp fields
- Activate the scenario
Filtering What Gets Logged
Use Fwrdly’s keyword filters to only send specific messages to your sheet:
- Only log messages containing “delivered” or “shipped” for package tracking
- Only log messages from your bank’s number for financial records
- Only log OTP codes by filtering for “code” or “verification”
Example Sheet Layout
| Sender | Message | Time |
|---|---|---|
| +1 555-0123 | Your package has been delivered | Apr 1, 2:30 PM |
| BankAlerts | Withdrawal of $500 from checking | Apr 1, 3:15 PM |
| Your verification code is 847291 | Apr 1, 4:02 PM |
Frequently Asked Questions
Is there a row limit? Google Sheets supports up to 10 million cells. For most SMS logging, you won’t hit this for years.
Can I log to multiple sheets? Yes — create multiple Webhook destinations in Fwrdly, each pointing to a different Zapier/Make webhook that writes to a different sheet.
Does this work in real time? Yes. Messages typically appear in the sheet within 5-15 seconds of arriving on your iPhone.
Is my data private? Messages pass through Zapier/Make servers to reach Google Sheets. If privacy is critical, consider Fwrdly’s direct Email forwarding instead.
