# Webex Recording Transcription and Case File Automation

> Automating meeting transcription storage, case identification, and record tracking using Zapier, Webex, Box, Calendly, Microsoft Excel, AI, and Google Sheets.

Section: Zapier Automations

Page: https://mburhan.com/case/webex-recording-transcription-and-case-file-automation

## Overview

This solution automates the process of retrieving Webex meeting transcripts, matching meetings with client cases, storing documents in Box, and tracking records in Google Sheets. It uses Calendly matching for direct case identification and AI-assisted matching when a usable case number is not available.

## The Problem

Meeting transcripts need to be associated with the correct client and case before they can be stored and tracked. Handling this manually requires staff to review meeting details, identify the relevant case, download transcripts, locate the correct Box folder, upload files, and update tracking records.

The process becomes more difficult when meeting information does not contain a usable case number. An automated approach was needed to support both direct case matching and matching through existing client records.

## How It Works

1. **Receive Meeting Data:** A Webhook triggers the automation when meeting-related information is received.
2. **Retrieve Webex Details:** The workflow fetches meeting information and checks whether a transcription is available.
3. **Collect Participants:** It retrieves participant details and formats meeting start and end times.
4. **Match Calendly Events:** JavaScript compares meeting information with scheduled Calendly events and retrieves the corresponding invitee details.
5. **Identify the Case:** The workflow checks whether a valid case number is available through the Calendly match.
6. **Use AI When Needed:** If direct matching does not provide a usable case number, the workflow downloads client records from Excel as CSV and uses AI by Zapier to identify a matching client and case number.
7. **Find the Box Folder:** The identified case number is used to search for the corresponding folder in Box.
8. **Download and Store the Transcript:** The Webex transcription is retrieved and uploaded to the relevant Box folder.
9. **Update Tracking Records:** Google Sheets logs the participant name, available case number, and Zapier run reference.

Image (https://mburhan.com/uploads/14f822816a4b6f46f4ca4698.png)

Image (https://mburhan.com/uploads/c0ef7f426e1a53fa476b35a8.png)

## Result

The automation brings meeting retrieval, case identification, transcript storage, and record tracking into one connected process. It supports both direct Calendly-based matching and AI-assisted client matching, allowing transcripts to be routed according to the information available.Box maintains the associated transcript documents, while Google Sheets provides a record of the processed meetings and their related references.

### Daily Processing Metrics

| Metric | Daily Volume |
| --- | --- |
| Meetings processed | 5 |
| Meetings with available transcripts | 3 |
| Transcripts uploaded to client folders in Box | 3 |

Image (https://mburhan.com/uploads/4496c9f74b17aaa0361ae367.png)

## Tech Stack

- **Zapier:** Connects applications and manages automation, filters, loops, and conditional paths.
- **Webex:** Provides meeting information and transcription access.
- **Calendly:** Supplies scheduled meeting and invitee information.
- **JavaScript:** Handles meeting matching and data processing.
- **Box:** Stores transcripts in the corresponding case folders.
- **Google Sheets:** Maintains meeting and case tracking records.

## Where This Pattern Applies

The same approach can be used wherever incoming documents or recordings need to be matched with existing client records and stored in the correct location.

- **Legal Services:** Match meeting recordings and transcripts with case files.
- **Healthcare:** Organize consultation recordings and related documents.
- **Insurance:** Associate recorded client statements with claim records.
- **Recruitment:** Match interview recordings with candidate profiles.
- **Customer Support:** Attach call transcripts to customer and support records.

The general pattern is to retrieve incoming information, identify its matching record, store the associated document, and update the tracking system. The matching logic and connected applications can be adapted to different business processes.
