Skip to main content

Automatically Transcribe Audio from Google Drive into a Zapier Table

Purpose​

This guide shows how to automatically transcribe audio files uploaded to Google Drive and store the transcription in a Zapier Table.

Requirements​

Zapier table template​

To store the transcription in a separate Zapier Table, first create a table template.

  1. Log in to Zapier and go to Zapier home

  2. Click on "Table" under "Start from Scratch"

    Zapier - Start from Scratch - Table

  3. Create a blank table called "Transcription Template"

  4. Configure the columns:

    NameTypeAlignmentIconDecimals
    IDNumberRighthashtag00
    StartNumberRightclock0.000
    EndNumberRightclock0.000
    LabelTextLefttag
    SpeakerTextLeftperson
    TextTextLeftmessage
  5. Sort the table by ID ascending (↑)

    Zapier - Tables - Transcription Template

Implementation​

Transcribe audio​

  1. Go to Zapier home

  2. Click on "Zap" under "Start from Scratch" Zapier - Start from Scratch - Zap

  3. Click on Trigger and pick the Google Drive app

  4. Trigger Setup

    1. Trigger event: New File in Folder
    2. Account: Your Google Drive account
    3. Click on "Continue"
  5. Trigger Configuration

    1. Drive: Your Google Drive
    2. Folder: The folder you want to upload audio files to
    3. Include Deleted Files?: Only return non-deleted files (recommended)
    4. Click on "Continue"
  6. Trigger Test

    1. Click on "Test Trigger"
    2. Click on "continue with selected record"
      • Note: this step requires having at least one file in that folder
  7. Action Setup

    1. App: Speech is Cheap (or view its Zapier App Directory listing)
    2. Action event: Transcribe Audio
    3. Click on "Continue"
  8. Action Configuration

    1. Input File:
      1. Click on the field
      2. Select File from Google Drive
    2. Leave Input URL blank
    3. Set Can Parse Speakers? to True so speaker IDs appear in the sample output and table.
    4. Set Can Label Audio? to True so audio labels appear in the sample output and table. Add-ons are billed per minute; see pricing for rates.
    5. Fill out any other optional fields, such as Language
    6. Click on "Continue"

    Zap - Transcribe Audio - Configuration

  9. Action Test

    1. Click on "Test step"
      • Note: "Data out" will contain a sample transcription

Populate the Zapier Table​

This guide populates one record per segment using line items. To save the entire transcription to a single record instead, omit the Looping step and map the Transcript field directly to a record's text column.

  1. Add a step by clicking on the plus below the "Transcribe Audio" action

    1. Choose "Zapier Tables" (or "Tables")
    2. Action event: Duplicate Table
    3. Click on "Continue"
  2. Action Configuration

    1. Table ID: "[Table] Transcription Template"
    2. Name:
      1. Click on the plus ([+])
      2. Select Title from Google Drive
      3. Type -transcription
    3. Description: (optional)
  3. Add a step by clicking on the plus below the "Duplicate Table" action

    1. Choose "Looping"
    2. Action event: "Create Loop From Line Items"
    3. Click on "Continue"
  4. Action Configuration

    1. Under "Values to Loop," click "Add value set" five times to loop on six values
    2. Fill out the following values:
      1. Type ids, click on the plus, search for "Output Segments ID"
      2. Type starts, click on the plus, search for "Output Segments Start"
      3. Type ends, click on the plus, search for "Output Segments End"
      4. Type labels, click on the plus, search for "Output Segments Label"
      5. Type speaker_ids, click on the plus, search for "Output Segments Speaker Id"
      6. Type texts, click on the plus, search for "Output Segments Text"
    3. Click on "Continue"
    4. Click on "Test step"

    Zap - Looping - Configuration

  5. Add a step by clicking on the plus inside the loop

    1. Choose "Zapier Tables" (or "Tables")
    2. Action event: "Create Record"
    3. Click on "Continue"
  6. Action Configuration

    1. Click on the vertical ellipsis (⋮) to the right of the "Table ID" field
    2. Click on "Custom"
    3. Click on the "Duplicate Table in Zapier Tables" step
    4. Click on "ID"
    5. Add the record values:
      1. ID: Ids
      2. Start: Starts
      3. End: Ends
      4. Label: Labels
      5. Speaker: Speaker Ids
      6. Text: Texts
    6. Click on "Continue"
    7. Click on "Test step"
    8. Click on "Publish"

    Zap - Create Record - Configuration

Verify the implementation​

  1. Upload an audio file to the Google Drive folder that's watched by Zapier
  2. Wait for the Zap to run. Zapier checks Google Drive on its polling interval, and transcription time depends on the length of the recording.
  3. Look for the newly created table in your Zapier Tables

Zapier - Tables - Transcription Output