AI Voice Call Webhook to WhatsApp & Google Sheets (OpenAI, n8n)

Turn every finished voice call into an instant WhatsApp alert (and a Google Sheets log)

This AI Voice Call Webhook to WhatsApp & Google Sheets (OpenAI, n8n) workflow automatically reads the end-of-call payload from your voice agent, determines whether the call is truly urgent, and logs everything to Google Sheets—optionally pinging the owner via WhatsApp so nothing slips through unnoticed.

What this workflow does

• Receives a POST webhook when a voice call ends, including call metadata plus optional transcript and/or summary.
• Normalizes the payload into consistent fields (call ID, end reason, transcript/summary text, and caller phone).
• Detects unprocessable calls using known failure end reasons (e.g., missing/usable text). These are saved as “unprocessable” records in the Google Sheets Call Log tab.
• Uses OpenAI to extract structured facts when text is available—such as caller name/phone, intent, sentiment, urgency, summary, requested action, and any follow-up date.
• Classifies urgency using the model’s extracted urgency/sentiment plus keyword matching against your configured urgent keyword list.
• Appends to Google Sheets as either urgent or routine, and optionally sends WhatsApp with urgent call details.

Use cases

• Customer support lines where urgent requests should be seen immediately by the business owner via WhatsApp.
• Appointment or sales calls where intent and requested action should be captured and logged for follow-up.
• Operational reviews—every call (including unprocessable ones) is recorded in Google Sheets for auditing.

Technical details

• n8n Webhook trigger: “Voice Call Ended” endpoint to accept end-of-call payloads.
• OpenAI for structured extraction (intent, sentiment, urgency, summary, follow-up date).
• WhatsApp node to message the owner for urgent calls.
• Google Sheets integration (logs into the Call Log tab: urgent, routine, and unprocessable).
• Logic and transformations using nodes such as if, set, and code (plus workflow steps like sticky note for clarity).

Setup: Copy the webhook URL from the “Voice Call Ended” trigger and configure your voice agent platform to POST the end-of-call payload to it. Then connect OpenAI credentials and your Google Sheets/WhatsApp settings.