{"product_id":"vapi-legal-intake-log-calls-to-google-sheets-email-clio","title":"Vapi Legal Intake: Log Calls to Google Sheets + Email \u0026 Clio","description":"\u003ch3\u003eTurn every Vapi legal intake call into a logged enquiry, an email alert, and an optional Clio contact\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eVapi Legal Intake: Log Calls to Google Sheets + Email \u0026amp; Clio\u003c\/strong\u003e is an n8n automation workflow that receives \u003cstrong\u003eVapi end-of-call reports\u003c\/strong\u003e, extracts structured enquiry details, \u003cstrong\u003eappends them to Google Sheets\u003c\/strong\u003e, and \u003cstrong\u003eemails your law firm\u003c\/strong\u003e—with \u003cstrong\u003eURGENT\u003c\/strong\u003e handling. It can also \u003cstrong\u003ecreate a Clio contact\u003c\/strong\u003e with the enquiry note and send failure alerts if anything goes wrong.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a POST webhook from Vapi\u003c\/strong\u003e when your voice agent finishes a call.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters the payload\u003c\/strong\u003e to process only events where \u003ccode\u003etype = end-of-call-report\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts enquiry fields\u003c\/strong\u003e from Vapi Structured Output (filling missing values with \u003cem\u003e“Not provided”\u003c\/em\u003e), normalizes \u003cem\u003eurgency\u003c\/em\u003e, and builds a timestamp using your configured time zone.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a new row\u003c\/strong\u003e in the \u003cstrong\u003eEnquiries\u003c\/strong\u003e tab of a Google Sheets spreadsheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an email\u003c\/strong\u003e to the firm via \u003cstrong\u003eGmail\u003c\/strong\u003e (or \u003cstrong\u003eOutlook\u003c\/strong\u003e if enabled). The subject is prefixed with \u003cstrong\u003e“URGENT -”\u003c\/strong\u003e when flagged urgent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptionally creates a Clio Person contact\u003c\/strong\u003e and adds the enquiry details as a note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails an alert via Gmail\u003c\/strong\u003e if the Clio contact\/note creation fails.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCapture intake enquiries from a Vapi voice agent and keep a searchable \u003cstrong\u003eEnquiries\u003c\/strong\u003e log for legal teams.\u003c\/li\u003e\n  \u003cli\u003eInstantly notify staff via email, escalating \u003cstrong\u003eurgent\u003c\/strong\u003e leads with a clear subject line.\u003c\/li\u003e\n  \u003cli\u003eAutomatically sync calls into \u003cstrong\u003eClio\u003c\/strong\u003e so enquiries become actionable records with notes.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e (POST) secured with header auth: \u003ccode\u003ex-intake-secret\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes\/logic\u003c\/strong\u003e: \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003cstrong\u003eGmail\u003c\/strong\u003e (email), \u003cstrong\u003eOutlook\u003c\/strong\u003e (optional), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and a \u003cstrong\u003eClio note\u003c\/strong\u003e flow using a sticky note step.\u003c\/li\u003e\n  \u003cli\u003eRelies on \u003cstrong\u003eVapi Structured Output\u003c\/strong\u003e (e.g., \u003ccode\u003etemplate_intake_data\u003c\/code\u003e) to extract fields like caller name and enquiry data.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46359771938995,"sku":"N8N-22154","price":78.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/0iwR79J3TqDt_M5CPogrw_OHCOWu0i.png?v=1793697541","url":"https:\/\/buyflowscripts.com\/products\/vapi-legal-intake-log-calls-to-google-sheets-email-clio","provider":"N8N Commerce","version":"1.0","type":"link"}