Automatically Transcribe Audio from Google Drive into Google Sheets
Purpose
This guide shows how to automatically transcribe audio files uploaded to Google Drive and save the transcripts into Google Sheets.
Requirements
- Google account for Google Drive and Google Sheets
- Zapier account for the integration
- Speech is Cheap API key
- A Google Drive folder to upload audio files into
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 spreadsheet. - Set Can Label Audio? to
Trueso audio labels appear in the sample output and spreadsheet. 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"
Export to Google Sheets
This guide creates one spreadsheet row per segment with timestamps, speaker IDs, and text. To save the entire transcript into a single cell instead, map the Transcript field to a single spreadsheet row.
-
Add a step by clicking on the plus below the "Transcribe Audio" action
- Choose "Google Sheets"
- Action event: Create Spreadsheet
- Click on "Continue"
-
Action Configuration
- Title:
- Click on the plus (
[+]) - Select
Titlefrom Google Drive - Type
-transcription
- Click on the plus (
- Headers:
- Note: Zapier adds these values from the bottom
- Type "Text" (and click out)
- Type "Speaker ID"
- Type "Label"
- Type "End"
- Type "Start"
- Type "ID"
- Click on "Continue"
- Click on "Test step"

- Title:
-
Add a step by clicking on the plus below the "Create Spreadsheet" action
- Choose "Google Sheets" once more
- Action event: "Create Multiple Spreadsheet Rows"
- Click on "Continue"
-
Action Configuration
- Drive: Select your Google Drive from the dropdown
- Click on the vertical ellipsis (
⋮) to the right of the Spreadsheet field - Click on "Custom"
- Click on the "Create Spreadsheet in Google Sheets" step
- Click on "ID"
- Worksheet: Select "Sheet1" (ID: 0)
- Fill out the Rows:
- ID: click on the plus, search for "Output Segments ID"
- Start: click on the plus, search for "Output Segments Start"
- End: click on the plus, search for "Output Segments End"
- Label: click on the plus, search for "Output Segments Label"
- Speaker ID: click on the plus, search for "Output Segments Speaker Id"
- Text: click on the plus, search for "Output Segments Text"
- Click on "Continue"
- Click on "Test step"
- Click on "Publish"

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 spreadsheet at the root of your Google Drive
