Connect Outlook to SMS in Make turn calendar events into automated, trackable messaging
Spend less time copying event details and more time communicating. This Make-powered workflow turns new Outlook events into personalized SMS via the D7 SMS API, alerts your team in Slack, and logs every interaction in Google Sheets so you get speed, accuracy, and full traceability.
Core Features:
- Delivery reports: Track real-time delivery receipts from D7 with message IDs, status codes, and timestamps. Use callbacks to update logs and alert on failures or retries.
- Personalization: Merge Outlook fields (attendee name, date, location, meeting link) into SMS templates. Support for Unicode, long-message concatenation, and configurable sender IDs.
- API flexibility: RESTful JSON API with token-based auth, rate control, scheduling, time-zone support, and webhooks. Map any Outlook field to D7 parameters inside Make, handle errors with retries or conditional branches.
Automation Flow:
1) Trigger: Outlook – New Event Created
- When a new event is added, Make pulls event data (subject, start time, attendees, location/online link).
2) Map and enrich
- Use Make’s field mapping to select the recipient’s phone number, format times, and build a dynamic SMS template with variables.
3) Action: D7 SMS – Send automated SMS message
- Send a personalized confirmation or reminder. Configure sender ID, schedule send-time (e.g., 24 hours before event), and capture the returned message ID for tracking.
4) Action: Slack – Notify team
- Post a structured message to a channel with event details, recipient, and D7 message ID so the team stays in sync.
5) Action: Google Sheets – Log entry
- Append a row with event ID, attendee, phone, message body, timestamp, and D7 message ID to create an auditable record.
6) Optional: Delivery report handling
- Add a Make webhook to receive D7 delivery callbacks, then update the Google Sheets row with final status and notify Slack on failures or delays.
Who It’s For:
- Developers: Need a robust, API-first SMS layer with delivery receipts, webhooks, and clean field mapping inside Make.
- Marketers: Want scalable, personalized reminders and confirmations triggered by calendar activity without manual sends.
- Ops teams: Require reliable, auditable SMS notifications with Slack visibility and spreadsheet-based reporting.
