I’m building a workflow in n8n to automate the weekly evaluation of French call recordings stored in a Google Drive folder. The flow should:
Trigger weekly
List all subfolders inside a master Google Drive folder (each subfolder = 1 week of calls)
For each subfolder:
List all .mp3 files
Check a Google Sheet to see if the file has already been processed
If new:
Download the file
Transcribe it (in French) using OpenAI Whisper
Translate to English using GPT
Score the call using a rubric (via GPT again)
Log all results (file name, rep name, transcript, translation, scores, etc.) into a Google Sheet
Goal:
Ensure no file is processed more than once. Fully automate transcription, translation, and evaluation of weekly calls.
What I Need Help With:
How to loop through subfolders and retrieve .mp3 files from each
How to prevent duplicate processing by checking the file name/ID against a Google Sheet
How to pass and parse audio files correctly for OpenAI Whisper in n8n
General structure sanity check — is this the right approach?
Any guidance or working examples would be amazing. Thanks in advance! 