Keep a Journal of Special Moments using Twilio Programmable SMS and Google Sheets
This article provides a tutorial on how to use Twilio Programmable SMS and Google Sheets to create a journal of special moments. The author suggests that it's easy to forget small but memorable events, especially when life is busy with children. To combat this, they recommend recording a memory every day in an Excel sheet or leather-bound journal. However, the author found this solution too time-consuming and instead opted for Twilio Programmable SMS, which allows users to set up a dedicated phone number that can record text messages to a Google sheet. The tutorial requires a free or paid Twilio account and a free Google account. It involves setting up a Google Sheet with columns for date, sender's phone number, and message content, then using the Script Editor to create a function that appends new rows to the spreadsheet when it receives POST requests from Twilio. The author also provides an optional security feature that allows only pre-approved phone numbers to add to the spreadsheet.
Company
Twilio
Date published
Oct. 22, 2021
Author(s)
Alina Libova Cohen
Word count
1002
Hacker News points
None found.
Language
English