n8n Workflow: Turn Voice Memos into Task Lists with Gemini & Sheets

Turn Voice Memos into Task Lists—Automatically

With this n8n workflow, you upload a voice memo through an n8n Form, have it transcribed by Google Gemini, and instantly receive an email summary plus a structured task list. Each task is also appended as a new row in Google Sheets—so your next steps are captured reliably without manual copy/paste.

What this workflow does

• Collect input via n8n Form trigger: receives a voice memo (audio file), a project name, and a recipient email address.
• Transcribe with Google Gemini: sends the uploaded audio to Google Gemini to generate a transcript. If transcription fails, the workflow emails the user to notify them.
• Generate structured task output: uses a Google Gemini chat model to convert the transcript into JSON containing a one-line summary and a tasks array with owner, due date, and priority.
• Email the results: formats the extracted tasks into an email-friendly list and sends the summary and task list using Gmail.
• Write tasks to Google Sheets: splits the tasks array into individual items and appends each task as a separate row in your selected worksheet (for example, a tab named “Tasks”).

Use cases

• Capture meeting action items by voice and turn them into an organized task backlog.
• Create project follow-ups when founders or operators record quick updates on the go.
• Centralize ownership, due dates, and priority for SaaS teams using Google Sheets.
• Reduce admin work by converting unstructured voice notes into structured tasks automatically.

Technical details

• n8n Form trigger for submitting audio, project name, and email
• Google Gemini (PaLM) for transcription and JSON task extraction
• Gmail to email the summary and formatted task list
• Code nodes for data formatting/field preparation
• Split out to process each task individually
• Google Sheets OAuth2 to append rows to a specified spreadsheet/worksheet
• Credentials required: Google Gemini (PaLM) API, Gmail OAuth2, and Google Sheets OAuth2

Supported audio formats include mp3, m4a, wav, and ogg.