AI analytics build

AI-Powered Call Transcript Insight Extraction & Sheets Integration

AI workflow that digests 20-minute calls, summarizes the themes, and syncs action items to Google Sheets.

Overview

I engineered a Python + Flask backend with a lightweight UI that ingests lengthy support or sales calls, runs them through custom OpenAI prompt chains, and returns structured insights within minutes. The system cleans raw transcripts, extracts topics, action items, sentiment, and customer feedback, then pipes everything automatically into Google Sheets so ops teams can filter, share, or trigger follow-up workflows without touching the raw audio.

Key Features

  • Transcript preprocessing pipeline that chunks 15–20 minute calls for accurate LLM analysis.
  • OpenAI-powered extraction of key topics, action items, concerns, suggestions, and sentiment.
  • Automated Sheets integration so every call lands as a structured row for dashboards or alerts.
  • Configurable tagging so teams can adapt the model to different call types or verticals.
  • Skills: Python, Flask, OpenAI API, AI Data Analytics, AI Content Detection.

Gallery

Project Reviews

Kunoichi

April 15, 2023

I am thoroughly impressed with the exceptional service I received while working with this talented Al expert on my project, The level of expertise, commitment, and attention to detail demonstrated throughout the development process was truly outstanding. Not only did they consistently provide update but he 8also went above and beyond to ensure that all technical aspects were addressed with precision and creativity. Communication was seamless; he were always available to answer questions and provide updates. The final product exceeded our expectations, functioning flawlessly and efficient....

Helpful

Vike

November 23, 2025

Everything was fine, Did a solid job.

Helpful

Manuel

January 10, 2024

I had an exceptional experience working with Mallahim. His professionalism and punctuality were truly commendable. He demonstrated a deep understanding of programming skills, which was evident throughout the project. Even after the project was completed, he remained available and helpful, always ready to assist with any questions or additional needs. Highly recommended!

Helpful