Automated Transcription Archiving Workflow

This n8n workflow automates the process of transcribing audio files uploaded to Google Drive, storing the transcriptions in AWS S3, and logging details into Google Sheets for easy tracking. It streamlines handling new recordings, automatically transcribing them via AWS Transcribe, and then saving and cataloging the results for efficient project management.

Here’s a step-by-step overview:

1. **Google Drive Trigger**: Activates when a new file is uploaded to a specific Google Drive folder.

2. **Upload to AWS S3**: The new file is uploaded to an AWS S3 bucket for storage.

3. **AWS Transcribe (Initial and Follow-up Jobs)**: Initiates a transcription job on the uploaded audio file, retrieving the transcription after processing.

4. **Retrieve Transcription**: Fetches the transcription results from AWS.

5. **Data Processing and Logging**: Sets key data fields such as transcription date, recording name, link, and transcript content.

6. **Record Storage**: Saves the transcription data into an AWS S3 bucket for archival.

7. **Log Entry**: Appends the gathered information to Google Sheets, creating a log for easy access and management.

8. **Wait Step**: Ensures proper synchronization before finalizing the process.

This workflow is highly practical for teams recording interviews, meetings, or any audio content, automating manual transcriptions and keeping organized records for subsequent review or analysis.