Automate transcription and data storage from Google Drive to Google Sheets

• Automatically transcribe audio files from Google Drive.
• Store transcription results in Google Sheets for easy access.
• Monitor a specific folder in Google Drive for new files.
• Reduce manual data entry by automating transcription processes.

Trigger workflow when a new file is created in Google Drive. Upload the audio file to AWS S3 for processing. Initiate transcription using AWS Transcribe. Wait for transcription to complete and retrieve results. Store the transcription results in Google Sheets.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Configure Google Drive trigger with the correct folder ID.
3. 3
   Set up AWS credentials for S3 and Transcribe services.
4. 4
   Authorize Google Sheets access and specify the target sheet.
5. 5
   Test the workflow by uploading an audio file to the specified Google Drive folder.