See llms.txt for all machine-readable content.

Back to Templates

Route AI voice call webhooks to WhatsApp and Google Sheets with OpenAI

Created by

Created by: Jessy Mariau || fractional-hq
Jessy Mariau

Last update

Last update 8 hours ago

Categories

Share

Quick overview

Your voice agent ends a call, fires a webhook, and nobody reads it until the customer rings back annoyed. This one reads every call, works out which are actually urgent from the model's own fields, and puts those on the owner's WhatsApp. Everything gets logged.

How it works

  1. Receives a POST webhook when a voice call ends, containing the call metadata plus an optional transcript and summary.
  2. Normalizes the incoming payload into consistent fields (call ID, end reason, transcript/summary text, and caller phone) and checks whether the call has usable text based on known failure end reasons.
  3. If the call is unprocessable (for example no transcript/summary or a failure end reason), creates an “unprocessable” record and appends it to the Google Sheets “Call Log” tab.
  4. If the call has usable text, sends the transcript/summary to OpenAI to extract structured facts such as caller name/phone, intent, sentiment, urgency, summary, requested action, and any follow-up date.
  5. Decides whether the call is urgent using the extracted urgency/sentiment plus keyword matching against your configured urgent keyword list.
  6. Appends the call to Google Sheets as either an urgent or routine record, and optionally sends a WhatsApp message to the business owner with the urgent call details.

Setup

  1. Copy the webhook URL from the “Voice Call Ended” trigger and configure your voice agent platform to POST its end-of-call payload to that URL.
  2. Add an OpenAI credential for the extraction model and select the model you want to use.
  3. Add a WhatsApp Business Cloud credential, set your WhatsApp Business phone number ID, and fill in the business owner’s WhatsApp number in the handoff settings.
  4. Add a Google Sheets credential and replace the placeholder spreadsheet IDs and sheet/tab names for “Call Log”, “Urgent calls”, and “Routine calls” (or swap these logging steps for your CRM nodes).
  5. Review and customize the urgent keyword list and the WhatsApp auto-send switch in the handoff settings before activating the workflow.