Scheduled transcription and data entry from audio to Google Sheets

• Automate meeting summaries from audio recordings to Google Sheets
• Extract key metrics from interviews for analysis
• Streamline documentation of audio content for reporting purposes

Triggers every 18 minutes using a cron job Transcribes audio recordings into text Analyzes transcribed text to extract key metrics Appends extracted metrics to Google Sheets as new rows

1. 1
   Import the workflow template into n8n
2. 2
   Configure the cron node to set the desired schedule
3. 3
   Set up the transcription service with necessary credentials
4. 4
   Define the OpenAI model and prompt for metric extraction
5. 5
   Connect the Google Sheets node to specify the target spreadsheet