Wired up an SMS to Notion pipeline today. Twilio ingests the message, Make orchestrates, a small PHP endpoint handles file uploads, and structured records land in a Notion database with attachments and extracted hashtags.
Ran into a couple of unexpected gaps. Twilio doesn't surface file extensions on media downloads, and Notion won't accept anything other than a valid public URL for attachments through the API. Fixed both by parsing the Content-Type header to derive the extension, and a small PHP script to handle uploads to a web server.
It has a single number in Twilio. If the sender is my number, it sends to my database; if it’s my wife’s number, it sends to her database. The only unrequested feature is that multiple pictures create multiple records for now, which is fine for the POC. Building it out to determine whether it is worth building a real product.
