/plushcap/analysis/twilio/keep-journal-special-moments-twilio-programmable-sms-google-sheets

Keep a Journal of Special Moments using Twilio Programmable SMS and Google Sheets

What's this blog post about?

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


By Matt Makai. 2021-2024.