Skip to content

Mentor Mock Lessons Audio Transcription from Google Drive

This workflow automatically processes audio recordings of mentor mock lessons stored in Google Drive, transcribes them using Google's Gemini AI model, and stores the transcriptions in Airtable for analysis and review.

Purpose

No business context provided yet — add a context.md to enrich this documentation.

How It Works

  1. Search for Audio Files: The workflow searches a specific Google Drive folder for audio files with .m4a or .aac extensions
  2. Download Files: Each found audio file is downloaded from Google Drive
  3. Transcribe Audio: The audio is processed through Google Gemini 2.5 Pro model to generate text transcriptions
  4. Format Data: The transcription is combined with file metadata (name, ID, link) into a structured format
  5. Store Results: The transcription and metadata are saved to an Airtable database for further analysis

Workflow Diagram

graph TD
    A[Manual Trigger] --> B[Search files and folders]
    B --> C[Download file]
    C --> D[Transcribe a recording1]
    D --> E[Format Output1]
    E --> F[Create or update a record]

    G[OpenRouter Chat Model] -.-> H[AI Agent]

    style A fill:#e1f5fe
    style F fill:#e8f5e8
    style H fill:#fff3e0

Trigger

Manual Trigger: This workflow is executed manually by clicking the "Execute Workflow" button. It processes all eligible audio files found in the specified Google Drive folder during each run.

Nodes Used

Node Type Node Name Purpose
Manual Trigger When clicking "Execute Workflow" Starts the workflow execution
Google Drive Search files and folders Finds audio files (.m4a, .aac) in a specific folder
Google Drive Download file Downloads the audio files for processing
Google Gemini Transcribe a recording1 Converts audio to text using AI transcription
Set Format Output1 Structures the data with filename, transcription, file ID, and link
Airtable Create or update a record Stores transcription results in database
OpenRouter Chat Model OpenRouter Chat Model Provides AI language model (currently disconnected)
AI Agent AI Agent AI agent functionality (currently disconnected)

External Services & Credentials Required

Google Drive

  • Credential: Google Drive OAuth2 API
  • Purpose: Access and download audio files from specific folder
  • Permissions: Read access to Google Drive files

Google Gemini AI

  • Credential: Google Palm API (Waringa Voice)
  • Purpose: Audio transcription using Gemini 2.5 Pro model
  • Permissions: API access for audio processing

Airtable

  • Credential: Airtable Token API (EXP Training Bot)
  • Purpose: Store transcription results
  • Database: "Mock lessons transcript analysis" (appGhyv6izijYsFtp)
  • Table: "Table 1" (tblyOTCS9oqO16XtL)

OpenRouter (Optional)

  • Credential: OpenRouter API (OpenRouter Org)
  • Purpose: Access to Claude Sonnet 4.5 model (currently unused)

Environment Variables

No environment variables are required for this workflow. All configuration is handled through node parameters and credentials.

Data Flow

Input

  • Audio files (.m4a, .aac) stored in Google Drive folder ID: 1fnelIRAyA2muOUKlmqqqOjL6EnHqIdNJ

Processing

  • File metadata extraction (name, ID, web link)
  • Audio file download as binary data
  • AI-powered transcription to text

Output

  • Airtable records containing:
    • File Name: Original filename
    • File ID: Google Drive file identifier
    • Link: Direct web link to the file
    • Transcription: Full text transcription of the audio

Error Handling

The workflow does not include explicit error handling nodes. Potential failure points include: - Network connectivity issues when accessing Google Drive - Audio files that cannot be processed by Gemini AI - Airtable API rate limits or connection failures - Invalid or corrupted audio file formats

Known Limitations

  • Only processes .m4a and .aac audio formats
  • Transcription quality depends on audio clarity and Google Gemini's capabilities
  • Manual execution only - no automatic scheduling
  • No duplicate detection - may create multiple records for the same file
  • AI Agent and OpenRouter components are present but not connected to the main workflow

No related workflows specified in the current context.

Setup Instructions

  1. Import Workflow: Import the JSON into your n8n instance

  2. Configure Google Drive Credentials:

    • Set up Google Drive OAuth2 API credentials
    • Ensure access to the target folder (1fnelIRAyA2muOUKlmqqqOjL6EnHqIdNJ)

  3. Configure Google Gemini Credentials:

    • Set up Google Palm API credentials for Gemini access
    • Verify access to Gemini 2.5 Pro model

  4. Configure Airtable Credentials:

    • Set up Airtable Token API credentials
    • Verify access to the "Mock lessons transcript analysis" base
    • Ensure the target table has the required fields: File Name, File ID, Link, Transcription

  5. Test the Workflow:

    • Place test audio files in the specified Google Drive folder
    • Execute the workflow manually
    • Verify transcriptions appear in Airtable

  6. Optional - Configure OpenRouter (if planning to use AI Agent):

    • Set up OpenRouter API credentials
    • Connect the AI Agent to the main workflow if additional processing is needed