Speech-to-Text Transcription Tool with Google Workspace

This project automates speech-to-text transcription using Google Forms for audio input, Google Cloud Speech-to-Text for transcription, and Google Sheets for logging and email delivery via Google Apps Script. It provides a user-friendly and efficient solution for converting audio files to text.

The Problem/Need/Why:

Manual transcription of audio files is a time-consuming and tedious process. This project addresses this challenge by automating the transcription workflow, enabling users to quickly and easily convert audio to text, saving valuable time and resources. Using familiar Google Workspace tools makes the solution accessible to a wide audience.

AI-Generated Diagram: Cross-Functional Flowchart for Speech-to-Text Transcription Tool

Workflow/User Journey:

1. Audio File Upload (Google Forms): The user uploads their audio file through a Google Form. Specify any accepted audio file formats or size limits.

2. Transcription Triggered (Google Apps Script): The form submission triggers a Google Apps Script.

3. Speech-to-Text Conversion (Google Cloud Speech-to-Text API): The script sends the uploaded audio file to the Google Cloud Speech-to-Text API for transcription.

4. Text Extraction and Formatting: The script receives the transcribed text from the API and performs any necessary formatting or cleanup.

5. Email Delivery (Gmail API): The script sends an email containing the transcribed text to the user who submitted the audio file.

6. Google Sheet Logging: The script appends a new row to a Google Sheet, logging the transcription details (e.g., timestamp, filename, transcribed text). This provides a record of all transcriptions and can be useful for reporting or analysis. Mention any other data you’re logging, such as transcription duration or any error handling information.

The Client/Target Audience:

• it’s a personal project but it could be used as a reusable tool/solutions.

Technology Used:

• Google Apps Script: Core automation logic, API integrations, and data handling.

• Google Cloud Speech-to-Text API: Performing the audio transcription.

• Gmail API: Sending email notifications with the transcribed text.

• Google Forms API: Handling audio file uploads.

• Google Sheets API: Logging transcription data.

• Google Cloud Project Setup and Management: Setting up and managing the Google Cloud project, including API credentials and billing. (This highlights your ability to work with Google Cloud Platform.)

• OAuth 2.0 Authentication: Implementing secure authentication for accessing the Google Cloud APIs. (This emphasizes your understanding of security best practices.)

• Workflow Automation: Streamlining the transcription process.

Key Metrics/Achievements:

• Average transcription time.

• Accuracy of transcriptions.

• Number of audio files transcribed using the system.

• Any user feedback on the tool’s effectiveness.