Automate Twilio Call Transcription with Groq Whisper & Google Sheets

Automate Twilio Call Transcription with Groq Whisper & Google Sheets

Elevate your workflow efficiency by automating Twilio call transcription, donation detail extraction, and Google Sheets integration with this powerful n8n automation. Streamline the process of handling Twilio call recordings by capturing, transcribing, and organizing data seamlessly and accurately, avoiding any potential duplicate entries.

What this workflow does:

• Receives a Twilio Recording Status Callback via a webhook and responds with a TwiML XML.
• Collects critical call metadata like CallSid, caller number, recording URL/SID, and duration, continuing the process only if the recording exceeds a two-second threshold.
• Downloads the recording from Twilio using HTTP Basic Authentication, after ensuring its availability.
• Processes the audio through Groq Whisper to transcribe it into text.
• Leverages Google Gemini, with Groq as a fallback, to distill vital donation information including amounts and beneficiary details from the transcript, outputting it as JSON.
• Validates and parses this JSON; flags records needing review if parsing issues arise.
• Checks for existing records in a Google Sheets document to avoid duplications, appending new data when confirmed unique.

Use cases:

• Nonprofit Organizations: Automatically capture and process donation call transcripts to streamline donor relationship management.
• Customer Support Centers: Efficiently transcribe and log call details in Google Sheets for performance analysis and historical record-keeping.
• Sales Teams: Extract and manage customer interaction details to refine strategies and enhance client engagement.

Technical details:

• Integrations with Twilio for call handling and recording download using HTTP Basic Auth.
• Audio transcription powered by Groq Whisper.
• Donation detail extraction using Google Gemini with Groq as a fallback.
• Data storage and duplicate checking with Google Sheets.
• n8n nodes utilized include: if, set, code, wait, webhook, and sticky note.