Analyze voice messages received on WhatsApp, extract key data, and store it in Google Sheets.

Stop wasting time typing out voice messages. Your WhatsApp audios become neat, structured data on Google Sheets—completely hands-off.

  • Instantly when the trigger is activated
  • Instantly when receiving a voice message (whatsapp_cloud_api → webhook_voice_message)
  • Get media URL (whatsapp_cloud_api → retrieve_media_url)
  • Create a Transcription (openai_whisper → transcription)
  • Send a Prompt for a structured response (chatgpt → completion_as_data)
  • Add a new row at the end of a sheet (gspreadsheet → add_row_to_end)
  • Send a text message (whatsapp_cloud_api → post_message)

Manually dealing with WhatsApp voice messages eats away at your productivity: listening to each audio, jotting down key details like names and dates, then transferring that info to Google Sheets is not just tedious, it’s easy to get wrong—or miss entirely if you’re swamped. If you skip automating this, you’re not only wasting hours every week, you’re also risking incomplete records, missed follow-ups, and a lack of real-time visibility into what matters most for your business or team.

This formula from Botize changes everything by automatically transcribing incoming WhatsApp voice messages, extracting all vital data points—who’s involved, what happened, when, where, and why—and neatly adding them to your chosen Google Sheet. You can further tailor the automation by setting the frequency (like hourly checks), applying message filters, and formatting the output to suit your workflow. The result? No more forgotten details, instant searchable records, and a system that keeps everyone on the same page—freeing up your time for high-impact work while ensuring you never miss a beat.

Ready to experience the confidence and control of automated voice message processing? Just follow the step-by-step instructions to set up this formula, or use the preconfigured Botize link where everything’s ready for you to customize and launch in minutes. Get started now and watch your workflow transform!

Start using this automation

It's ready to go. Choose how to set it up in your account.

Open it in the Botize editor

Load it into your account and customize it in the visual panel, with everything in view.

Open it in Claude or ChatGPT

Copy this and paste it into ChatGPT or Claude (with the free Botize connector): it'll load the automation, tailor it with you and save it to your account.

Not connected yet? Claude guide · ChatGPT guide


Turn WhatsApp Voice Notes Into Instant Google Sheets Gold

Drop a voice note on WhatsApp (the same way you always do). We’ll grab it, transcribe it, pick out important info like names and dates, and plop it directly into your Google Sheet. Your team stays updated, your records stay clean, and you never listen twice.

Manual Botize
Listen to each voice note and replay multiple times 5 0 Minutes
Transcribe audio and type it by hand 8 0 Minutes
Identify key info, tag names, dates, notes 6 0 Minutes
Log results into Google Sheets manually 4 0 Minutes
Send confirmation to sender 2 0 Minutes
Total 25 0 Minutes

Looking to instantly capture, transcribe, and organize WhatsApp audios into Google Sheets? You just found your fix—no tech headaches, no middleman.


Customer Orders on the Go

A bakery owner gets voice orders from clients on WhatsApp. The automation pulls client names, what they want, and delivery dates—no detail missed, ever—directly into their orders sheet.

Real-Time Magic

Voice notes land in Sheets before you blink. Stay ahead—no manual copying.

Nothing Gets Missed

Names, dates, and key details are pulled, structured, and easy to search.

Zero Tech Jargon

Simple setup—if you can send a voice note, you’ve basically got this handled.


Team Meeting Notes Without Typing

A project lead records quick voice updates for the team chat. Each update is instantly transcribed and key info (who, what, when) is dropped into the team’s Google Sheet tracker.

⌾︎ You’re drowning in WhatsApp audios that need sorting

⌾︎ You need fast access to client requests, reports, or updates—without transcription stress

🙃

✕ You never use WhatsApp voice notes

✕ You prefer chaos and manual data entry 😜


✓ Choose which details from each voice message get extracted and saved (names, dates, action items, etc.)

✓ Send summary confirmations via WhatsApp or email, and even tweak the format to suit your style

✓ Connect to different Google Sheets, or auto-sort into dedicated tabs for various team members or projects




This automation listens for new voice messages received on WhatsApp. It transcribes the audio, extracts key information such as names, dates, or events, and automatically logs the results into a structured Google Sheets file.

Related automations

Other ready-to-use automations you may find useful.