Automatically Transcribe Audio from Google Drive into a Zapier Table

Purpose

This guide will show you how to automatically transcribe any audio file by uploading it to Google Drive in order to create a Zapier Table with the transcription.

Requirements

I. Accounts & API Keys

• Google account for Google Drive
• Zapier account for the integration
• Speech is Cheap API key

II. Google Drive Upload Folder

1. Log in to Google Drive

2. Create a new folder or choose an existing one

3. Change the access settings since the file must be publicly accessible:

   1. Right-click on the folder, then click on Share ⯈ Share
   2. Under "General access," change from "Restricted" to "Anyone with the link"
      • "Viewer" permissions are sufficient

III. Zapier Table Template

In order to store the transcription in separate Zapier Table, you must first create a Zapier Table template.

1. Log in to Zapier and go to Zapier home

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

   

3. Create a blank table called "Transcription Template"

4. Configure the columns:

   Name	Type	Alignment	Icon	Decimals
   ID	Number	Right	hashtag	00
   Start	Number	Right	clock	0.000
   End	Number	Right	clock	0.000
   Label	Text	Left	tag
   Speaker	Text	Left	person
   Text	Text	Left	message

5. Sort the table by ID ascending (↑)

   

Implementation

Transcribe Audio

1. Go to Zapier home

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

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 use this link to find it)
   2. Action event: Transcribe Audio
   3. Click on "Continue"

8. Action Configuration

   1. Input URL:
      1. Type https://drive.google.com/uc?export=download&id=
      2. Click on the plus ([+])
      3. Select ID from Google Drive
   2. Fill out the remaining optional fields
   3. Click on "Continue"

   

9. Action Test

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

Populate the Zapier Table

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

   1. Choose "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"

   

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

   1. Choose "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"

   

Verify the Implementation

1. Upload an audio file to the Google Drive folder that's watched by Zapier
2. Wait about a minute, though it make take up to 15 minutes depending on the file's duration
3. Look for the newly created table in your Zapier Tables