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
- Google account for Google Drive
- Zapier account for the integration and Zapier Tables
- Speech is Cheap API key
- A Google Drive folder to upload audio files into
Zapier table template
To store the transcription in a separate Zapier Table, first create a table template.
-
Log in to Zapier and go to Zapier home
-
Click on "Table" under "Start from Scratch"

-
Create a blank table called "Transcription Template"
-
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 -
Sort the table by ID ascending (↑)

Implementation
Transcribe audio
-
Go to Zapier home
-
Click on "Zap" under "Start from Scratch"

-
Click on Trigger and pick the Google Drive app
-
Trigger Setup
- Trigger event: New File in Folder
- Account: Your Google Drive account
- Click on "Continue"
-
Trigger Configuration
- Drive: Your Google Drive
- Folder: The folder you want to upload audio files to
- Include Deleted Files?: Only return non-deleted files (recommended)
- Click on "Continue"
-
Trigger Test
- Click on "Test Trigger"
- Click on "continue with selected record"
- Note: this step requires having at least one file in that folder
-
Action Setup
- App: Speech is Cheap (or view its Zapier App Directory listing)
- Action event: Transcribe Audio
- Click on "Continue"
-
Action Configuration
- Input File:
- Click on the field
- Select File from Google Drive
- Leave Input URL blank
- Set Can Parse Speakers? to
Trueso speaker IDs appear in the sample output and table. - Set Can Label Audio? to
Trueso audio labels appear in the sample output and table. Add-ons are billed per minute; see pricing for rates. - Fill out any other optional fields, such as Language
- Click on "Continue"

- Input File:
-
Action Test
- Click on "Test step"
- Note: "Data out" will contain a sample transcription
- Click on "Test step"
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.
-
Add a step by clicking on the plus below the "Transcribe Audio" action
- Choose "Zapier Tables" (or "Tables")
- Action event: Duplicate Table
- Click on "Continue"
-
Action Configuration
- Table ID: "[Table] Transcription Template"
- Name:
- Click on the plus (
[+]) - Select
Titlefrom Google Drive - Type
-transcription
- Click on the plus (
- Description: (optional)
-
Add a step by clicking on the plus below the "Duplicate Table" action
- Choose "Looping"
- Action event: "Create Loop From Line Items"
- Click on "Continue"
-
Action Configuration
- Under "Values to Loop," click "Add value set" five times to loop on six values
- Fill out the following values:
- Type
ids, click on the plus, search for "Output Segments ID" - Type
starts, click on the plus, search for "Output Segments Start" - Type
ends, click on the plus, search for "Output Segments End" - Type
labels, click on the plus, search for "Output Segments Label" - Type
speaker_ids, click on the plus, search for "Output Segments Speaker Id" - Type
texts, click on the plus, search for "Output Segments Text"
- Type
- Click on "Continue"
- Click on "Test step"

-
Add a step by clicking on the plus inside the loop
- Choose "Zapier Tables" (or "Tables")
- Action event: "Create Record"
- Click on "Continue"
-
Action Configuration
- Click on the vertical ellipsis (
⋮) to the right of the "Table ID" field - Click on "Custom"
- Click on the "Duplicate Table in Zapier Tables" step
- Click on "ID"
- Add the record values:
- ID: Ids
- Start: Starts
- End: Ends
- Label: Labels
- Speaker: Speaker Ids
- Text: Texts
- Click on "Continue"
- Click on "Test step"
- Click on "Publish"

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