Files & Documents

Capture Google Drive files and log transcriptions to Google Sheets

8 nodes 115 94 Automatic trigger
Download

Workflow Description

An automation that monitors a Google Drive folder for new audio files, transfers them to AWS S3 storage, processes them through AWS Transcribe to extract text, and records the transcription results with metadata in Google Sheets for centralized reference.

How it works

  1. 1.Monitor Google Drive folder for new audio file uploads
  2. 2.Transfer uploaded files to AWS S3 bucket for temporary storage
  3. 3.Process audio files through AWS Transcribe service for text extraction
  4. 4.Record transcription output and file details in Google Sheets

Use cases

  • Automatically archive incoming audio files while maintaining an organized searchable log
  • Create a centralized transcript database with timestamps and file references for compliance or knowledge management

Requirements

  • Google account with full access permissions to Drive and Sheets
  • Active AWS account with Transcribe and S3 services enabled and configured

Service Value

Ready-made workflow template for automation delivery and service execution.

Apps Used

Google Sheets Aws Transcribe Aws S3 Google Drive

Details

Trigger Automatic trigger
Nodes 8
Apps 4
Views 115
Downloads 94

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (8)

Google Sheets

Google Sheets

#1

AWS Transcribe 2

Aws Transcribe

#2

AWS Transcribe 1

Aws Transcribe

#3

AWS S3 1

Aws S3

#4

AWS S3 2

Aws S3

#5

Set

Set

#6

Google Drive Trigger1

Google Drive Trigger

#7

Wait

Wait

#8