Tiered escalation logic and success notifications for wellness check in platform

TIERED SMS ESCALATION LOGIC & SUCCESS NOTIFICATIONS WELLNESS CHECK-IN PLATFORM UGOOD ABOUT UGOOD UGOOD is a live wellness check-in platform that sends automated SMS check-ins to subscribers through Twilio. If a subscriber does not respond to their check-in, the system must escalate through a tiered support network called Vanguards, Anchors, and Kinspersons until contact is confirmed. We are also adding an optional success notification feature that alerts a subscriber's tribe when they check in successfully. We are looking for an experienced developer to build both features and integrate them with our existing Twilio SMS backend and Airtable member database. FEATURE 1 :TIERED ESCALATION LOGIC TIER 1 : SUBSCRIBER CHECK-IN - UGOOD texts subscriber: "Hey [Name], UGOOD?" - Subscriber responds → escalation stops immediately - Subscriber does not respond after 3 attempts (30 minutes apart) → escalate to Tier 2 TIER 2 : VANGUARD - UGOOD texts Vanguard: "Hi [Vanguard Name], this is UGOOD. [Subscriber Name] has not responded to their check-in. Are you able to reach out to them to make sure they're good? Reply YES if you're willing to reach out or NO if you're unable to at this time." - Vanguard replies YES → UGOOD responds: "Thank you. Please reach out to [Subscriber Name]." → escalation stops immediately - Vanguard replies NO or no response received within 30 minute timeout → escalate to Tier 3 TIER 3: ANCHOR - UGOOD texts Anchor: "Hi [Anchor Name], this is UGOOD. [Subscriber Name] has not responded to their check-in and their Vanguard was unable to reach out at this time. Are you able to reach out to them to make sure they're good? Reply YES if you're willing to reach out or NO if you're unable to at this time." - Anchor replies YES → UGOOD responds: "Thank you. Please reach out to [Subscriber Name]." → escalation stops immediately - Anchor replies NO or no response received within 30 minute timeout → escalate to Tier 4 TIER 4: KINSPERSON - UGOOD texts Kinsperson: "Hi [Kinsperson Name], this is UGOOD. [Subscriber Name] has not responded to their check-in and previous contacts were unable to reach out. As their Kinsperson are you able to reach out to them immediately to make sure they're good? Reply YES if you're willing to reach out or NO if you're unable to at this time." - Kinsperson replies YES → UGOOD responds: "Thank you. Please reach out to [Subscriber Name]." → escalation stops immediately - Kinsperson replies NO or no response received within 30 minute timeout → Crisis flag triggered CRISIS FLAG - If all three tiers respond NO or don't respond within their 30 minute timeout - Subscriber is automatically flagged in Airtable admin dashboard - UGOOD admin team receives immediate alert - Full escalation chain is recorded in Airtable with timestamps FEATURE 2: OPTIONAL SUCCESS NOTIFICATIONS Overview: When a subscriber successfully responds to their check-in they have the option to notify their Tribe that they are good. This feature is optional and fully controlled by the subscriber through their member portal. How It Works: - In the member portal the subscriber sees a toggle: "Notify my Tribe when I check in successfully" default is OFF - Subscriber can turn it on or off at any time - Subscriber can choose which tier receives the notification, Vanguard only, all tiers, or any combination - Subscriber can choose notification frequency, every check-in or weekly summary Success Notification Message: "Hi [Tribe Member Name], just letting you know [Subscriber Name] checked in with UGOOD today and they're good. No action needed." Airtable Update: - Success notification preference recorded per subscriber - Which tiers are selected for notification recorded - Frequency preference recorded - Each successful notification logged with timestamp TECH STACK Our existing system runs on: - Twilio (SMS sending and inbound reply handling) - Airtable (member database — Vanguard, Anchor, Kinsperson fields already exist) - Modal (backend infrastructure) - Supabase (member authentication) AIRTABLE FIELDS ALREADY IN PLACE - Vanguard Name, Vanguard Phone, Vanguard Email - Anchor Name, Anchor Phone, Anchor Email - Kinsperson Name, Kinsperson Phone, Kinsperson Email - Active Status - Last Check-in Sent - Last Response DELIVERABLES - Fully functional three tier escalation system integrated with existing Twilio backend - YES and NO inbound reply detection for each tier - 30 minute timeout logic between each tier - Airtable updated in real time at each escalation stage recording tier notified, response received and timestamp - Crisis flag triggered in admin dashboard when all tiers are exhausted - Escalation chain resets automatically once a YES is received - No duplicate notifications sent once escalation is stopped - Optional success notification toggle in member portal - Subscriber controls which tiers receive success notifications - Subscriber controls notification frequency - All success notifications logged in Airtable with timestamps - Recorded walkthrough video showing full escalation flow and success notification feature end to end - 14 days post launch support COMMUNICATION REQUIREMENTS At minimum a weekly check-in call is required throughout the duration of the project. We remain open to all additional communication necessary for project clarity and successful completion. If you are not available for regular calls and responsive communication please do not apply. IDEAL CANDIDATE - Strong experience with Twilio inbound and outbound SMS handling - Experience building reply detection and keyword logic (YES and NO) - Comfortable working with Airtable API for real time updates - Experience with Modal and Supabase - Experience building member portal toggles and preference settings - Clear communicator with a track record of clean handovers - Portfolio showing similar automation or escalation builds preferred BUDGET Fixed price — $1500. TO APPLY Please include: - Examples of similar Twilio escalation or reply detection builds - Your approach to handling inbound SMS keyword logic (YES and NO detection) - Your experience building member preference toggles - Your estimated timeline - Confirmation that you have experience with Airtable API integration By applying to this position you agree to keep all proprietary information about UGOOD LLC including system architecture, subscriber data and business processes strictly confidential. Timeline is one month NDA is required