Case Study
Make.com Call Logging and Summary Automation
A two-phase Make.com automation system for call recording intake, call logging, summary processing, Google Sheets updates, and Slack notifications.
Book a Systems ConsultationBusiness Context
Call Operations Automation
This Make.com build connects call recording and call summary workflows into one operational process. The first phase receives call recordings, stores files in Google Drive, logs structured call data in Google Sheets, sends Slack notifications, and updates rows after matching records. The second phase receives call summaries, waits for the required processing window, aggregates text, retrieves matching sheet records, calls an HTTP message endpoint, parses the returned data, and updates the tracking sheet and Slack channel.
The Workflow Problem
• Call recordings and summaries needed to be captured without relying on manual spreadsheet updates
• The process required file storage, record matching, delayed summary handling, and team notifications
• Call activity needed to remain traceable across Google Drive, Google Sheets, and Slack
System Built
Call Recording Intake
A webhook receives the call recording event and starts the Phase 1 logging workflow.
File and Row Handling
Recordings are downloaded, stored in Google Drive, and logged into Google Sheets.
Summary Processing
The Phase 2 workflow waits, aggregates summary text, searches sheet records, and parses returned data.
Team Notification
Slack messages keep the operations team updated when call logs and summaries move forward.
Operational Outcomes
• Call recording and call summary events are routed through separate Make.com phases
• Google Drive, Google Sheets, HTTP, JSON parsing, text parsing, and Slack actions are coordinated from one workflow system
• Call records can be logged, matched, updated, and reported without manual spreadsheet handling