- Twilio
- Google Apps Script
- Google Sheets
- Webhooks
- Real project
Twilio SMS Logging via Google Apps Script /Real Project
Logs every incoming Twilio SMS to Google Sheets in real time
Built a Google Apps Script webhook to capture and log Twilio messages into Google Sheets whenever they arrive. Implemented a custom webhook solution that creates a trigger URL, handles the webhook call, extracts relevant data, and adds it as a new row — bypassing errors from previous methods.
- Timeline
- 1 day
- Rating
- ★ 5.0
- Category
- Automations
At a glance
- Problem
- The client needed to capture and log every incoming Twilio SMS message into Google Sheets for tracking and reporting.
- What I built
- Built a custom Google Apps Script webhook that Twilio calls directly whenever a message arrives.
- Tools
- Twilio, Google Apps Script, Google Sheets, Webhooks
- Result
- Client rating ★ 5.0 out of 5
The problem
The client needed to capture and log every incoming Twilio SMS message into Google Sheets for tracking and reporting. Their previous integration method was throwing unknown errors consistently, causing missed messages and incomplete records.
How it works
- 01Google Apps Script deployed as a web app with a public webhook URL
- 02Twilio configured to call the webhook on every incoming message
- 03Script receives the POST request and parses sender, body, and timestamp
- 04Data is validated and formatted for the spreadsheet structure
- 05New row appended to Google Sheets with all message details
- 06Error logging captures any failed entries for review
What I built
Built a custom Google Apps Script webhook that Twilio calls directly whenever a message arrives. The script parses the incoming data, extracts the relevant fields, and appends a new row to Google Sheets — bypassing the broken integration entirely with a lightweight, reliable solution.
Stack
- Twilio
- Google Apps Script
- Google Sheets
- Webhooks