Welcome to the community, @slothbear! :grinning_face_with_big_eyes: I haven’t used the Send SMS block yet, so this is pure speculation, but if it’s anything like the Sendgrid block (which sends emails), it must be kicked off manually. It’s not a trigger-based system that will automatically respond to changes in views. In fact, I don’t think that any of Airtable’s blocks operate that way. They may build content automatically, but nothing is delivered (i.e. emails, SMS messages) without user intervention.
To do that kind of automatic triggering, you’ll need to use a third-party service like Zapier or Integromat. Both systems let you tie into various SMS delivery services, though Zapier has the slight advantage of having a built-in “new record in view” trigger, which would tie into your proposed system nicely, and you probably only need a two-step zap, so this could be done with the free Zapier account.
To pull this off in Integromat, you would need to start the scenario with an Airtable search module, tailor the search to find some data in a meeting record that indicates when it’s 5 days away (perhaps via a formula field), and schedule the scenario to run daily.