In this video, I show you how to automate your Retell AI → n8n → Google sheet workflow without using an AI agent inside n8n.
Retell AI sends a large and complex JSON payload when someone calls your clinic. Many people use an extra AI agent in n8n to summarize and extract key fields like:
Full name
Email
Phone
Appointment date & time
But that AI agent costs money.
Instead, I replaced it with a free JSON function inside n8n that extracts the exact fields you need — no AI usage, no credits, no cost.
What you’ll learn:
✅ How Retell AI sends data via webhook into n8n ✅ Why the n8n AI agent is not needed ✅ How to extract clean data using a simple JSON code function ✅ How to send the processed data to Google sheet ✅ Complete workflow explanation ✅ Free code included
This tutorial is perfect for clinics, agencies, and automators who want to save money and simplify their workflow.
💡 Click on below link to visit my official website to get JSON code:
00:00hi viewers in this video I'm going to show you how you can save your money
00:05while the retail AI data is processing through webhook in n at n so viewers
00:15watch this video till then my name is Sazam Anthanoli welcome to get
00:19information and knowledge YouTube channel let's get started
00:22viewers you can see that this is the script which I have given to the retail
00:28AI agent as a prompt this is for the inbound dendro clinic agent what the
00:35agent does is ask the caller for full name reason for visit schedule email and
00:46phone number so I have also created three functions you can see at the right side
00:55you have to create at least one function I have created three functions because it
01:03was the requirement the two functions which are created on cal I will show you
01:11also you can add the custom function also but I have created only on call it's
01:21basically for checking the availability of slot and booking the appointment so you
01:30can see that this is for booking the appointment in call and this is call you
01:36can see I have set it the 30 minute meeting schedule availability is from
01:45Monday to Wednesday from 9 a.m. to 1 p.m. to connect call with detail AI you have to
01:52go to settings and then you have to click on API keys then you have to click on the
02:00add button I have already created the API key so I will not create it you have to
02:05simply copy the API key and then paste it in retail AI then click on the event types
02:12in retail AI and then copy the number which will be in the URL of your browser address
02:19bar then you have to paste it here which is for event type ID call.com you have to
02:27paste the API key here you can see I have already pasted both of these but this was
02:35the setting for functions creating using cal.com so you can create your custom one
02:45also so then you can see that I have told the agent at the end that send only the
02:54JSON data through webhook I have added the webhook URL in the webhook settings the
03:00webhook URL is of n8n you can see if I click on the webhook and you can see that
03:07this is the webhook URL so I have pasted here but it's happening that the data is
03:13coming from retail AI in n8n right now I am using AI agent you see I have given this
03:20prompt which is you are an AI assistant your task is to analyze the following call
03:24transcript and extract structured information from it make sure the
03:29extracted details are accurate and based only on the information in the transcript
03:36if a field is missing or not mentioned return null for that field current date
03:42and time is colon curly open braces and closing braces inside I have typed dollar
03:51now here is the transcript colon opening curly braces and closing curly braces inside I
03:59have typed dollar json dot body dot call dot transcript and then you can also see
04:05that I have toggle on the required specific output format you I have used the
04:12chat model as well as output parser so the chat model which I have used is open AI
04:21chat model you can see I'm using GPT dash 4o dash mini as you know that chat GPT model utilizes credits and it works so when those are consumed so it's not for free I have used the structured output
04:40person you can see this also so basically it's outputting name email and meeting
04:47schedule so now if I go to the Google sheets you can see that the name email and
04:56schedule data will come here now if I go to retail AI and then click on the test button
05:03any personal details used in this demo are fictional and do not represent real individuals
05:10hello thank you for calling saas clinic how can I help you today
05:17my name is saas zaman I want to book an appointment
05:24thank you saas zaman can I please have your last name
05:30basically my first name is s double a d and last name is z a m a n it's saas zaman
05:39thank you for clarifying what's your preferred contact number it's plus nine two one two three four five six seven eight
05:49thank you could you share your email address and please spell it out for me it's
05:56it's November 26 2025 at 10 a.m is there anything else I can help you with today if not thanks again for calling saas clinic take care
06:05because you can see that the workflow has been executed successfully and the data has came in Google sheet so why I'm using an AI agent
06:14due to you can see that data which is coming through the webhook using the retail AI
06:18in the output you can see that data is too much so I have to
06:26expect that data which is required for example name email and schedule date and time so for that I have used AI agent you can see that it outputs the name email and schedule
06:45and then that data is sent it to Google sheet so now what I will do is simply replace the AI agent with the javascript code because as the AI agent consumes the AI agent
07:06credits so it's not for free so that's the reason with this what will happen that my workflow will execute the same data but for free so I will simply place the javascript code in the middle
07:25I'll connect the output of webhook to the code in javascript and output of javascript to Google sheet so now if I show you the code the code is this one simply visit my website and you can get this code there you have to simply copy it
07:43and just paste it in javascript you can modify it also for example if you want to add 1 2 3 4 or more fields so visit my website and you can get this code there I will place the link in the description
08:11one thing you have to do more also in the google sheet note what you have to do is simply remove the dot output from every field you can see you have to do the same so I have removed the dot output and now I will execute this workflow once again and you will see that the data
08:41will enter the google sheet will enter the google sheet will enter the google sheet the same name email and schedule will go to google sheet for free
08:56because you can see that the workflow executed successfully I can show you the output of the code in javascript you can see the output
09:04output output now if I show you the output of google sheet node you can see that in the output field only the name and email has came why
09:17because the scheduled field is not matching the input field which is right now time you can see which is coming from the code in javascript node so what I will do is simply remove the old
09:33the old scheduled field field and then drag the time field and drop in the schedule field now if I execute
09:40the workflow once again you will see that this time the name email and schedule will appear in google sheet
09:50you can see that the name email and schedule now has been appeared in the google sheet
09:57you can see that the name email and schedule now has been appeared in the google sheet
10:02viewers hope so you liked my this video if you are new on my youtube channel then don't forget to subscribe and click
10:09or tap on the notification bell on all to get the notification of my latest uploaded information and knowledge videos
Be the first to comment