Turn Google Drive events into instant, trackable SMS alerts with D7 + Make
Connect Google Drive to D7 SMS in Make to notify the right people the moment a file changes. Automatically send personalized SMS, alert your Slack channel, and log every detail in Google Sheets no manual updates, no missed handoffs.
Core Features:
- Delivery reports you can act on: Capture D7 delivery receipts via webhook in Make, update status from queued to delivered/failed, and store messageId, recipient, segments, and timestamps for full auditability.
- Personalization at scale: Merge Google Drive metadata (file name, owner, folder, link) and sheet fields into SMS templates, set sender IDs where supported, and send Unicode messages for multilingual audiences.
- API flexibility for real-world ops: Robust REST/JSON, status webhooks, clear error codes, concatenated messages, and retry-friendly responses—plugged into Make’s routers, filters, and error handling.
Automation Flow:
1) Trigger: Google Drive – New Event Triggered
- Watches a folder or drive for new files or specific changes (e.g., uploads, updates).
- Pulls metadata like fileName, fileId, owner, link, and timestamps.
2) Transform & target
- Optional parsing of file name/labels to determine audience.
- Map recipients from a sheet or predefined list and assemble a message template.
3) Action: D7 SMS – Send automated SMS message
- Sends a personalized message such as:
“New file {{fileName}} added by {{owner}}. Review: {{fileLink}}”
- Returns messageId and initial status for logging.
4) Action: Slack – Notify team
- Posts a structured message to a channel with the Drive link, recipients reached, and D7 messageId for traceability.
5) Action: Google Sheets – Log entry
- Appends a row: timestamp, fileId, fileName, recipients, messageId, initial status, and Slack message URL.
6) Optional status updates
- Use a Make webhook to receive D7 delivery reports and update the corresponding sheet row to delivered/failed with reason codes.
Who It’s For:
- Developers: Need a reliable, instrumented SMS API with clean webhooks and predictable error handling inside Make.
- Marketers: Want fast, personalized notifications tied to content workflows without engineering overhead.
- Operations teams: Require auditable, real-time alerts and delivery visibility across SMS, Slack, and Sheets.
