January 22, 2026

Google Sheets + Twilio: qualify leads, follow up fast

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your lead sheet fills up. Then real life happens. And suddenly that “call them today” plan turns into “maybe tomorrow,” with half-finished notes and no clear status.

This is where Sheets Twilio follow-up automation helps. Marketing managers trying to prove pipeline impact feel it first, but business owners and client success leads get burned by the same lag and inconsistency.

This workflow qualifies new leads from Google Sheets with outbound calls, analyzes what happened, updates your sheet, and sends a follow-up email so warm prospects don’t drift away.

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: Google Sheets + Twilio: qualify leads, follow up fast

Click to explore

flowchart LR

    subgraph sg0["Message a model Flow"]
        direction LR
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Webhook1"]
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Code"]
        n5@{ icon: "mdi:robot", form: "rounded", label: "Message a model", pos: "b", h: 48 }
        n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
        n7@{ icon: "mdi:database", form: "rounded", label: "Get row(s) in sheet1", pos: "b", h: 48 }
        n8@{ icon: "mdi:swap-vertical", form: "rounded", label: "Edit Fields", pos: "b", h: 48 }
        n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/merge.svg' width='40' height='40' /></div><br/>Merge"]
        n12@{ icon: "mdi:database", form: "rounded", label: "Update Call Data", pos: "b", h: 48 }
        n14@{ icon: "mdi:message-outline", form: "rounded", label: "Send Schedule Request", pos: "b", h: 48 }
        n6 --> n9
        n4 --> n5
        n9 --> n7
        n3 --> n4
        n8 --> n12
        n8 --> n9
        n5 --> n6
        n5 --> n8
        n7 --> n14
    end

    subgraph sg1["Message a model1 Flow"]
        direction LR
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Webhook"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>Respond to Webhook"]
        n10@{ icon: "mdi:robot", form: "rounded", label: "Message a model1", pos: "b", h: 48 }
        n11@{ icon: "mdi:swap-vertical", form: "rounded", label: "Edit Fields1", pos: "b", h: 48 }
        n13@{ icon: "mdi:database", form: "rounded", label: "Look up Customer Data", pos: "b", h: 48 }
        n1 --> n11
        n11 --> n13
        n10 --> n2
        n13 --> n10
    end

    subgraph sg2["Google Sheets Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Google Sheets Trigger", pos: "b", h: 48 }
        n15["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Outbound Call"]
        n0 --> n15
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0 trigger
    class n5,n10 ai
    class n6 decision
    class n7,n12,n13 database
    class n3,n1,n2,n15 api
    class n4 code
    classDef customIcon fill:none,stroke:none
    class n3,n4,n9,n1,n2,n15 customIcon

Why This Matters: Slow lead follow-up kills momentum

Lead follow-up is one of those tasks that feels “simple” until you’re doing it at volume. You copy a phone number from Google Sheets, start a call, scribble notes somewhere else, then try to remember what to email and when. One distraction and the thread snaps. And because the “system” is really just a spreadsheet plus someone’s memory, the next person has no context. The cost isn’t only time. It’s missed intent, repeated questions, and leads that cool down while you’re still figuring out what happened.

The friction compounds. Here’s where it breaks down in day-to-day work.

You end up calling too late because the sheet isn’t actively reminding you, and warm leads turn lukewarm fast.
Call outcomes live in scattered places, which makes reporting messy and handoffs awkward.
Follow-up emails get delayed or written inconsistently, so prospects receive mixed messaging.
Status fields don’t stay accurate because updating them is boring, and boring tasks get skipped.

What You’ll Build: A lead-qualifying call + follow-up engine

This n8n workflow turns a simple “new row in Google Sheets” into a consistent, documented qualification touchpoint. When a lead lands in your sheet, it triggers an outbound call through your telephony provider (Twilio via an HTTP request, with ElevenLabs commonly used for the voice agent). During the call, your agent uses lead context pulled from Google Sheets to sound like it actually knows why it’s calling. After the call ends, a webhook receives the post-call data and transcript. OpenAI analyzes that transcript to extract intent and key details, then the workflow updates the original lead record with clean fields and an appropriate status. If the lead is a fit or needs next steps, Gmail sends a follow-up email (like a meeting link or recap) without you hunting for templates.

The workflow starts with a new lead in Sheets. Then it runs a call, captures the result, and has AI turn messy conversation into structured notes. Finally, your Google Sheet (and your inbox) reflects what happened so you can act quickly.

What You’re Building

What Gets Automated

What You’ll Achieve

Detect new leads added to Google Sheets and kick off outreach automatically.
Generate a personalized call opener using lead fields and an OpenAI Chat Model.
Place outbound calls via HTTP Request to your telephony stack (Twilio/ElevenLabs).
Analyze transcripts and write back structured notes and statuses to Google Sheets.

Turn a 20-minute manual process into about 5 minutes of setup time per lead.
Keep lead status consistent (“Qualified,” “Needs follow-up,” “Unreachable”) without relying on memory.
Get cleaner handoffs because every call has a recap, not a vague “called, no answer.”
Follow-up emails go out faster, which usually lifts reply rates in practice.
Build a basic audit trail for reporting, coaching, and team accountability.

Expected Results

Say you get 10 new leads a day in Google Sheets. Manually, you might spend about 10 minutes calling, 5 minutes writing notes, and 5 minutes sending a follow-up, which is roughly 20 minutes per lead (over 3 hours daily). With this workflow, you’re mainly confirming the sheet columns and your prompts, then letting calls + transcript analysis run in the background. Day to day, you’re often just reviewing outcomes and replying to engaged leads, which can be closer to 30–45 minutes total.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for your lead intake and status tracking
Twilio to place outbound calls (often via HTTP Request)
OpenAI API key (get it from the OpenAI dashboard)

Skill level: Intermediate. You’ll connect accounts, map a few fields, and test webhooks end-to-end.

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

A new lead lands in Google Sheets. The Sheets Row Trigger watches your lead intake sheet and starts the workflow the moment a new row appears (name, phone, service of interest, and anything else you capture).

Lead context is fetched and normalized. The workflow looks up the lead details, cleans up the called number, and prepares the data your voice agent needs so it doesn’t sound robotic or generic.

An AI opener is created, then the call is initiated. OpenAI builds a short opener based on the lead’s details, and an HTTP Request node triggers the outbound call through your Twilio/ElevenLabs setup.

Post-call events come back through webhooks. When the call ends, the provider posts results and transcript data to your n8n webhook. A transcript formatter cleans it, OpenAI analyzes it, and your Google Sheet gets updated with status plus structured notes. If appropriate, Gmail sends the meeting or next-step email.

You can easily modify the status rules and the follow-up email content based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Google Sheets Trigger

Set up the lead intake trigger so new rows in your Google Sheet initiate outbound calls.

Add and open Sheets Row Trigger.
Credential Required: Connect your googleSheetsTriggerOAuth2Api credentials.
Set Event to rowAdded.
Select the Document with Lead Qualification Voice Agent Demo v1 (Responses) and Sheet Form Responses 1.
Keep the polling schedule at Every Minute.
Connect Sheets Row Trigger to Initiate Outbound Call.

Tip: Ensure your sheet has a column named Phone Number (Please enter + country code) because downstream nodes reference it.

Step 2: Connect Google Sheets

These nodes read and update lead records as the workflow progresses.

Open Find Lead Row and set the filter lookupValue to ={{ $('Postcall Webhook').item.json.body.data.conversation_initiation_client_data.dynamic_variables.system__called_number }} and lookupColumn to Phone Number (Please enter + country code).
Credential Required: Connect your googleSheetsOAuth2Api credentials in Find Lead Row.
Open Lookup Lead Details and set the filter lookupValue to ={{ $json.body.called_number }} with the same lookupColumn.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Lookup Lead Details.
Open Update Lead Record and confirm Operation is appendOrUpdate.
Verify mapped columns in Update Lead Record, including Budget ={{ $('AI Transcript Analyzer').item.json.choices[0].message.content.budget }} and Lead status ={{ $('AI Transcript Analyzer').item.json.choices[0].message.content.leadStatus }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Lead Record.

⚠️ Common Pitfall: If the phone number format in your sheet doesn’t include a leading + country code, the lookup filters will not match.

Step 3: Configure Webhooks and Data Normalization

Capture inbound and post-call data, then normalize caller details for lookups.

Open Inbound Webhook and keep HTTP Method as POST and Response Mode as responseNode.
Connect Inbound Webhook to Normalize Called Number.
In Normalize Called Number, keep Include Other Fields enabled and set country_code to ={{$json.body.called_number.match(/^\+(\d{1,2})/)[1]}} and phone_number to ={{$json.body.called_number.replace(/^\+\d{1,2}/, '')}}.
Open Postcall Webhook and keep HTTP Method as POST.
Connect Postcall Webhook to Transcript Formatter.
In Transcript Formatter, keep the JavaScript formatter code as provided to output clean_transcript.

Tip: Use the production URLs from Inbound Webhook and Postcall Webhook in your voice platform so requests reach the workflow.

Step 4: Set Up AI Analysis and Parallel Logic

Analyze transcripts and branch the workflow to update records and decision logic.

Open AI Transcript Analyzer and confirm the Model is gpt-4o-mini and JSON Output is enabled.
Credential Required: Connect your openAiApi credentials in AI Transcript Analyzer.
Verify the user message uses ={{ $json.clean_transcript }} and the system message contains the JSON schema for lead analysis.
Confirm parallel execution: AI Transcript Analyzer outputs to both Lead Status Check and Parse Caller Fields in parallel.
In Lead Status Check, set the condition to equals with left value ={{ $json.choices[0].message.content.leadStatus }} and right value Qualified.
In Parse Caller Fields, confirm country_code is ={{$('Postcall Webhook').item.json.body.data.metadata.phone_call.external_number.match(/^\+(\d{1,2})/)[1]}} and phone_number is ={{$('Postcall Webhook').item.json.body.data.metadata.phone_call.external_number.replace(/^\+\d{1,2}/, '')}}.
Confirm parallel execution: Parse Caller Fields outputs to both Update Lead Record and Combine Streams in parallel.
In Combine Streams, keep Mode as combine and Combine By as combineByPosition.

Step 5: Configure Outbound Call and Email Actions

Trigger calls, build voice openers, send meeting emails, and respond to the webhook.

Open Initiate Outbound Call and set URL to https://api.elevenlabs.io/v1/convai/twilio/outbound-call with Method POST.
Set to_number in Initiate Outbound Call to ={{ $json["Phone Number (Please enter + country code)"] }}.
Credential Required: Connect your twilioApi credentials in Initiate Outbound Call.
Credential Required: Connect your httpHeaderAuth credentials in Initiate Outbound Call for the ElevenLabs header authentication.
Open AI Opener Builder and confirm the user message is =Hi {{ $json['First Name'] }}, your request: {{ $json['Service Request'] }} and the system prompt labels output as Voice Opener.
Credential Required: Connect your openAiApi credentials in AI Opener Builder.
Open Return Webhook Reply and keep Respond With as json and Response Body as ={ "type": "conversation_initiation_client_data", "dynamic_variables": { "voiceopener": "{{ $json.choices[0].message.content['Voice Opener'] }}" } }.
Open Send Meeting Email, set Send To to ={{ $json.Email }}, and keep the message body and subject as provided.
Credential Required: Connect your gmailOAuth2 credentials in Send Meeting Email.

⚠️ Common Pitfall: The webhook reply from Return Webhook Reply must be returned immediately; ensure Inbound Webhook uses responseNode mode.

Step 6: Test and Activate Your Workflow

Validate each path and confirm that qualified leads receive email follow-ups.

Click Execute Workflow and add a new row in your Google Sheet to trigger Sheets Row Trigger.
Send a test request to Inbound Webhook and verify Normalize Called Number and Lookup Lead Details populate the lead details for AI Opener Builder.
Send a post-call payload to Postcall Webhook and confirm AI Transcript Analyzer outputs leadStatus, budget, and timeline.
Verify parallel flow: AI Transcript Analyzer outputs to both Lead Status Check and Parse Caller Fields in parallel, and Parse Caller Fields outputs to both Update Lead Record and Combine Streams in parallel.
Confirm that qualified leads pass Lead Status Check, merge at Combine Streams, and reach Find Lead Row → Send Meeting Email.
When tests succeed, toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials panel and confirm the connected Google account still has access to the target spreadsheet.
If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.

Quick Answers

What’s the setup time for this Sheets Twilio follow-up automation?

About 45 minutes if your accounts, sheet columns, and webhooks are ready.

Is coding required for this lead follow-up automation?

No. You’ll mostly map fields, connect credentials, and test the call + webhook loop.

Is n8n free to use for this Sheets Twilio follow-up workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (often a few cents per analyzed transcript) plus Twilio/voice provider call charges.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I modify this Sheets Twilio follow-up workflow for different use cases?

Yes, and you should. You can swap Google Sheets for Airtable or a CRM by replacing the “Sheets Row Trigger” and “Lookup Lead Details” nodes, then remapping fields into “Parse Caller Fields.” Common changes include different qualification statuses, a new email template in the Gmail node, and a tighter prompt in “AI Transcript Analyzer” so it extracts exactly what your team cares about.

Why is my Twilio connection failing in this workflow?

Usually it’s the HTTP Request step pointing at the wrong endpoint or missing auth headers for your Twilio/voice agent setup. Regenerate your API key (or token), update it in n8n credentials or headers, then re-test with one known phone number. Also check your Twilio number configuration and webhook URLs, because a single typo can stop post-call events from ever reaching n8n. If you’re testing fast, rate limits can show up too.

What volume can this Sheets Twilio follow-up workflow process?

If you self-host, there’s no execution cap (it mostly depends on your server and your call provider). On n8n Cloud, the practical limit is tied to your plan’s monthly executions, and this workflow typically uses multiple executions per lead because it has trigger, call initiation, and post-call webhook handling.

Is this Sheets Twilio follow-up automation better than using Zapier or Make?

For this workflow, n8n has a few advantages: more complex logic with unlimited branching at no extra cost, a self-hosting option for unlimited executions, and native AI + webhook patterns that are awkward (and pricey) elsewhere. Zapier or Make can still work for simpler “new lead → send email” flows, honestly. Once you add transcript handling, status logic, and multiple write-backs to Sheets, n8n tends to feel more in control. If you want help deciding, Talk to an automation expert.

Once this is running, every new lead gets a consistent first touch and a clean paper trail. You stop babysitting the spreadsheet and start working the opportunities that actually deserve attention.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "bd1883b130c2f1e54342198ab569d6c54940cd75a819952352eaa81c90e69197",
"templateId": null,
"templateCredsSetupCompleted": null
},
"name": "Automated Lead Qualification System",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-9862",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
15,
28
],
"parameters": {
"color": 7,
"width": 1375,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "36381180-1a71-435f-ba1d-8c2d64ec53a6",
"name": "Sheets Row Trigger",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
20,
140
],
"parameters": {
"event": "rowAdded",
"options": [],
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Form Responses 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Lead Qualification Voice Agent Demo v1 (Responses)"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "206d9715-ee90-4a40-8f1e-ddc5978674bf",
"name": "Inbound Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
15,
322
],
"webhookId": "030f0967-0d16-43db-aa72-ad2d5909f945",
"parameters": {
"path": "030f0967-0d16-43db-aa72-ad2d5909f945",
"options": [],
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2.1
},
{
"id": "8ca3c8e3-55a1-4785-8619-74e6cb1722ff",
"name": "Return Webhook Reply",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
930,
295
],
"parameters": {
"options": [],
"respondWith": "json",
"responseBody": "={\n  \"type\": \"conversation_initiation_client_data\",\n  \"dynamic_variables\": {\n    \"voiceopener\": \"{{ $json.choices[0].message.content['Voice Opener'] }}\"\n  }\n}\n"
},
"typeVersion": 1.4
},
{
"id": "f2d03e6c-a85f-4a11-9bf4-d1a57cfbccf8",
"name": "Postcall Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
30,
560
],
"webhookId": "37e8d818-8265-43e9-803e-00119da5f3cb",
"parameters": {
"path": "37e8d818-8265-43e9-803e-00119da5f3cb",
"options": [],
"httpMethod": "POST"
},
"typeVersion": 2.1
},
{
"id": "7ef04ab0-ee54-4ff7-b23b-178b1519a33e",
"name": "Transcript Formatter",
"type": "n8n-nodes-base.code",
"position": [
250,
545
],
"parameters": {
"jsCode": "// Get the webhook data from the input\nconst webhookData = $input.item.json;\n\n// Access the transcript array\nconst transcript = webhookData.body.data.transcript;\n\n// Format the transcript into a clean string\nconst formattedTranscript = transcript.map(entry => {\n  // Capitalize the role for better readability\n  const role = entry.role.charAt(0).toUpperCase() + entry.role.slice(1);\n  return `${role}: ${entry.message}`;\n}).join('\\n'); // Join each line with a newline\n\n// Return the formatted transcript\nreturn {\n  json: {\n    clean_transcript: formattedTranscript\n  }\n};"
},
"typeVersion": 2
},
{
"id": "7dde1ba5-34f2-44ec-b244-2c93aec36b57",
"name": "AI Transcript Analyzer",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
480,
565
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "GPT-4O-MINI"
},
"options": [],
"messages": {
"values": [
{
"content": "={{ $json.clean_transcript }}"
},
{
"role": "system",
"content": "=You are an expert AI assistant specializing in analyzing sales call transcripts for \"ThinkSpire,\" a custom AI agency. You will be given the full transcript of a conversation between an AI agent named Sarah and a potential client.\n\nYour task is to carefully read the transcript and extract the key information. You MUST respond ONLY with a valid JSON object and nothing else. Do not include any introductory text, backticks, or explanations.\n\nThe JSON object must have the following structure:\n\n{\n  \"callSummary\": \"A concise, one-paragraph summary of the entire conversation, written in the third person.\",\n  \"leadStatus\": \"Analyze the conversation and classify the lead's status. Must be one of the following strings: 'Qualified', 'Not Qualified', 'Follow-up'. 'Qualified' means they explicitly agreed to a follow-up call. 'Not Qualified' means they explicitly said no or were a bad fit. 'Follow-up' means the call was inconclusive or they asked for more information via email first.\",\n  \"projectDetails\": \"Summarize the core requirements and features of the AI solution the client wants to build.\",\n  \"budget\": \"Extract the client's stated budget. Must be one of the following strings: '< INR 50k', 'INR 50k - INR 200k', 'INR 200k - INR 500k', 'INR 500k+', or 'Not Mentioned'.\",\n  \"timeline\": \"Extract the client's stated timeline. Must be one of the following strings: 'ASAP', '1-3 weeks', '3-6 weeks', '6+ weeks', or 'Not Mentioned'.\",\n  \"painPoints\": \"List the key business problems or pain points the client mentioned they are trying to solve.\"\n}"
}
]
},
"simplify": false,
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "f24c1e5f-8b7d-4d36-bead-5a24841bd1f1",
"name": "Lead Status Check",
"type": "n8n-nodes-base.if",
"position": [
710,
550
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1526b36e-0225-48b5-9839-71b4f4a2e017",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.choices[0].message.content.leadStatus }}",
"rightValue": "Qualified"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "7e85f631-f7c9-48b1-a215-d1780d4a2628",
"name": "Find Lead Row",
"type": "n8n-nodes-base.googleSheets",
"position": [
1090,
590
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupValue": "={{ $('Postcall Webhook').item.json.body.data.conversation_initiation_client_data.dynamic_variables.system__called_number }}",
"lookupColumn": "Phone Number (Please enter + country code)"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Form Responses 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Lead Qualification Voice Agent Demo v1 (Responses)"
},
"combineFilters": "OR"
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7,
"alwaysOutputData": true
},
{
"id": "f03074cd-cb71-455e-a58e-93df49da4f84",
"name": "Parse Caller Fields",
"type": "n8n-nodes-base.set",
"position": [
475,
705
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "f90161bd-2afe-472c-bb45-22b2da435bb9",
"name": "country_code",
"type": "string",
"value": "={{$('Postcall Webhook').item.json.body.data.metadata.phone_call.external_number.match(/^\\+(\\d{1,2})/)[1]}}"
},
{
"id": "fe128657-11d8-457f-b31e-27806ae3ab3f",
"name": "phone_number",
"type": "string",
"value": "={{$('Postcall Webhook').item.json.body.data.metadata.phone_call.external_number.replace(/^\\+\\d{1,2}/, '')}}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "ec82a8cd-ade2-4692-a04d-6e945e3d4d32",
"name": "Combine Streams",
"type": "n8n-nodes-base.merge",
"position": [
900,
600
],
"parameters": {
"mode": "combine",
"options": [],
"combineBy": "combineByPosition"
},
"typeVersion": 3.2
},
{
"id": "f6990d40-3847-4fbb-98ac-9226dbe93707",
"name": "AI Opener Builder",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
700,
310
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini",
"cachedResultName": "GPT-4O-MINI"
},
"options": [],
"messages": {
"values": [
{
"content": "=Hi  {{ $json['First Name'] }}, your request: {{ $json['Service Request'] }}"
},
{
"role": "system",
"content": "=Your name is Anika. You work with Thinkspire AI. You are an expert in following up with potential leads.\n\nWrite a friendly, yet concise, outbound call opener using the lead\u2019s {{ $json['First Name'] }} and referencing their requested service: {{ $json['Service Request'] }} . Make sure the sentence is grammatically correct.\n\nLabel the output as \"Voice Opener\""
}
]
},
"simplify": false,
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1.8
},
{
"id": "6319684e-a732-4643-8840-21ff133caa29",
"name": "Normalize Called Number",
"type": "n8n-nodes-base.set",
"position": [
245,
305
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "e726c247-bf1a-451a-910c-49beee3fe548",
"name": "country_code",
"type": "string",
"value": "={{$json.body.called_number.match(/^\\+(\\d{1,2})/)[1]}}"
},
{
"id": "058cde1e-76ba-4dee-9da8-141e154f6a8c",
"name": "phone_number",
"type": "string",
"value": "={{$json.body.called_number.replace(/^\\+\\d{1,2}/, '')}}"
}
]
},
"includeOtherFields": true
},
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "757c530d-0864-4ad9-8b0d-44d8c9817fb2",
"name": "Update Lead Record",
"type": "n8n-nodes-base.googleSheets",
"position": [
705,
720
],
"parameters": {
"columns": {
"value": {
"Budget": "={{ $('AI Transcript Analyzer').item.json.choices[0].message.content.budget }}",
"Timeline": "={{ $('AI Transcript Analyzer').item.json.choices[0].message.content.timeline }}",
"Transcript": "={{ $('Postcall Webhook').item.json.body.data.analysis.transcript_summary }}",
"Lead status": "={{ $('AI Transcript Analyzer').item.json.choices[0].message.content.leadStatus }}",
"Call summary": "={{ $('AI Transcript Analyzer').item.json.choices[0].message.content.callSummary }}",
"Phone Number (Please enter + country code)": "={{ $('Postcall Webhook').item.json.body.data.conversation_initiation_client_data.dynamic_variables.system__called_number }}"
},
"schema": [
{
"id": "Timestamp",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "First Name",
"type": "string",
"display": true,
"required": false,
"displayName": "First Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Last Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Last Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone Number (Please enter + country code)",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Phone Number (Please enter + country code)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Service Request",
"type": "string",
"display": true,
"required": false,
"displayName": "Service Request",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Budget",
"type": "string",
"display": true,
"required": false,
"displayName": "Budget",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Timeline",
"type": "string",
"display": true,
"required": false,
"displayName": "Timeline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Call summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Call summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead status",
"type": "string",
"display": true,
"required": false,
"displayName": "Lead status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Transcript",
"type": "string",
"display": true,
"required": false,
"displayName": "Transcript",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Voice opener",
"type": "string",
"display": true,
"required": false,
"displayName": "Voice opener",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Modified At",
"type": "string",
"display": true,
"required": false,
"displayName": "Modified At",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Phone Number (Please enter + country code)"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Form Responses 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Lead Qualification Voice Agent Demo v1 (Responses)"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7
},
{
"id": "b7277703-20a6-4360-9499-dd09d6cc4bdb",
"name": "Lookup Lead Details",
"type": "n8n-nodes-base.googleSheets",
"position": [
470,
330
],
"parameters": {
"options": [],
"filtersUI": {
"values": [
{
"lookupValue": "={{ $json.body.called_number }}",
"lookupColumn": "Phone Number (Please enter + country code)"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Form Responses 1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultName": "Lead Qualification Voice Agent Demo v1 (Responses)"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.7,
"alwaysOutputData": true
},
{
"id": "81bc117a-acfb-485d-9ebe-2fd4b6e60361",
"name": "Send Meeting Email",
"type": "n8n-nodes-base.gmail",
"position": [
1290,
610
],
"webhookId": "2ae2636b-48c1-49bd-9aac-8fb23ba202a7",
"parameters": {
"sendTo": "={{ $json.Email }}",
"message": "=Hi {{ $json['First Name']}},\n\nIt was great talking to you, below is our meeting calendar - https://calendar.app.google/Zs7VjMjbwWeaPvAH7 \n\nJust click the link, pick a time that works best for you, and we will see you in the meeting!\n",
"options": {
"appendAttribution": false
},
"subject": "Thinkspire Meeting",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 2.1
},
{
"id": "832bf94b-659e-4c74-8367-aba68c34a167",
"name": "Initiate Outbound Call",
"type": "n8n-nodes-base.httpRequest",
"position": [
255,
128
],
"parameters": {
"url": "https://api.elevenlabs.io/v1/convai/twilio/outbound-call",
"method": "POST",
"options": [],
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "agent_id",
"value": "[YOUR_ID]"
},
{
"name": "agent_phone_number_id",
"value": "[YOUR_ID]"
},
{
"name": "to_number",
"value": "={{ $json[\"Phone Number (Please enter + country code)\"] }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"twilioApi": {
"id": "credential-id",
"name": ""
},
"httpHeaderAuth": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.2
}
],
"active": false,
"pinData": [],
"settings": {
"callerPolicy": "workflowsFromSameOwner",
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Lead Status Check": {
"main": [
[
{
"node": "Combine Streams",
"type": "main",
"index": 1
}
]
]
},
"Transcript Formatter": {
"main": [
[
{
"node": "AI Transcript Analyzer",
"type": "main",
"index": 0
}
]
]
},
"Combine Streams": {
"main": [
[
{
"node": "Find Lead Row",
"type": "main",
"index": 0
}
]
]
},
"Inbound Webhook": {
"main": [
[
{
"node": "Normalize Called Number",
"type": "main",
"index": 0
}
]
]
},
"Postcall Webhook": {
"main": [
[
{
"node": "Transcript Formatter",
"type": "main",
"index": 0
}
]
]
},
"Parse Caller Fields": {
"main": [
[
{
"node": "Update Lead Record",
"type": "main",
"index": 0
},
{
"node": "Combine Streams",
"type": "main",
"index": 0
}
]
]
},
"Normalize Called Number": {
"main": [
[
{
"node": "Lookup Lead Details",
"type": "main",
"index": 0
}
]
]
},
"AI Transcript Analyzer": {
"main": [
[
{
"node": "Lead Status Check",
"type": "main",
"index": 0
},
{
"node": "Parse Caller Fields",
"type": "main",
"index": 0
}
]
]
},
"AI Opener Builder": {
"main": [
[
{
"node": "Return Webhook Reply",
"type": "main",
"index": 0
}
]
]
},
"Find Lead Row": {
"main": [
[
{
"node": "Send Meeting Email",
"type": "main",
"index": 0
}
]
]
},
"Sheets Row Trigger": {
"main": [
[
{
"node": "Initiate Outbound Call",
"type": "main",
"index": 0
}
]
]
},
"Lookup Lead Details": {
"main": [
[
{
"node": "AI Opener Builder",
"type": "main",
"index": 0
}
]
]
}
}
}