Automate Twilio Voice Donations with Groq & Google Sheets

Revolutionize Your Donation Collection Process with Twilio and Google Sheets Automation

Transform the way you handle phone-based donations with our innovative workflow that seamlessly integrates Twilio, Groq, and Google Sheets. Specifically designed to automate the transcription and processing of voice donations, this solution ensures your data is organized and readily accessible, allowing you to focus on what truly matters: engaging with your supporters.

What This Workflow Does

• Efficiently starts by responding to a Twilio Recording Status Callback webhook using TwiML (<Response/>), ensuring smooth initial interaction.
• Secures call metadata, including CallSid, caller number, recording URL/SID, and duration, and proceeds only if there's a valid recording of at least 2 seconds.
• Pauses momentarily to allow Twilio to finalize the media, then retrieves the MP3 recording utilizing Twilio HTTP Basic Auth.
• Dispatches the audio file to Groq’s Whisper transcription service, obtaining a precise text transcript.
• Uses a sophisticated LangChain prompt with Google Gemini and Groq LLMs to systematically extract donation specifics like donation amount, fee, beneficiary name, and currency, while also marking any transcript needing review.
• Parses the structured data as JSON, with a fallback error summary flagged for review upon parsing issues.
• Searches Google Sheets for a pre-existing record of the call, appending a new entry with extracted details only if an identical record isn't found, thereby maintaining a robust database.

Use Cases

• Non-profit organizations automating donation intake from voice calls efficiently.
• Fundraising teams needing streamlined processing of audio-recorded donations.
• Businesses and SaaS operators looking to enhance their contribution tracking systems using automation.

Technical Details

• Integrations: Twilio, Google Sheets, Groq Whisper, Google Gemini
• n8n Nodes Used: If, Set, Code, Wait, Webhook, Sticky Note
• Credential Setup: Google Sheets OAuth2, Google Gemini (PaLM) API key, Groq API access, Twilio HTTP Basic Auth

By adopting this comprehensive workflow, you not only elevate the accuracy and efficiency of your donation processes but also lay the groundwork for a more responsive and organized fundraising approach.