Retell.ai: Get data from the call into a specific column of my google sheet

Questions
,
1

I want to build a scenario which enables me that if my retell.ai makes a call, ask a question, for example: “On a scale of 1 to 5, how is your day if one is worst, five is best?“ - and the person retell called answers 4 for example, then make parse the answer into my google sheet into the q1 column. - How should I build this?

I suspect that somehow I need to link a retell variable to the google sheet column, but I don’t really know how.

Thank you for any help and insight in this topic!

2

Hi and welcome to the community!

That’s certainly possible. Here’s what you’d need to do:

  • Create a Make Custom Webhook scenario with parameters matching the variables you want to log into your Google Sheet eg Caller name, ID, Time/Date, Answer (1-5)
  • Create a Custom Function in Retell that calls your Make Custom Webhook
  • Create a prompt for your Retell assistant that enable it to use the Custom Function you defined

There’s a bunch of YouTube videos that detail this end-to-end, like this one.

2 Likes
3

Thank you very much!

Just to clarify: If I understand correctly from the sources you provided, a custom webhook scenario providing me a link I can use in the retell assistant, I can paste it into the custom function URL section in retell, then make a test call, webhook will hook the data structure, and from there, I can add a google sheets module in make, and I can now see the red colored tokens in it from webhook, which I can map into whatever columns I want in my google sheet.

Also, I need to select the POST function in retell custom function for it, and create a JSON structure in there, because that will be the data structure webhook will get.

Is this correct?

Thank you if you can assure me!

4

You’ve got it.

Let us know how you get on!

5

Thank you David!

Well, I’m afraid I’m still doing something wrong. I list what I have, then I describe the problem.

1.) Here is my custom function in retell:

p1
p1998×865 32.1 KB

p2
p21005×798 35.6 KB

2.) This is how the part that should get the age of the customer looks like in retell:

p3
p31185×424 69.7 KB

3.) But when the call ends, I see this in the webhook:

p4
p4962×881 67.6 KB

So, no variable that I made, only basic ones that is sent anyway, regardless of anything. I used the test agent built in function for testing in retell.

I also gave the call assistant a global prompt saying that if the customer says their age, use the named custom function.

Currently, I don’t really see what am I doing wrong - but I’m certainly doing something.

I would be really grateful, if you could give me some insight on this problem.

Thank you, and sorry for the many asks.

6

What you’re seeing in your Webhook output is a Retell call event payload - in this case, call_started.

You set those up on the account or agent level. It’s not anything to do with a custom function.

I’d double check to see if you have call events configured, and what Webhook URL they’re linked with.

You won’t ever see your custom function variables in a call event - only in a custom function call.

I’d double-check all your webhook URLs and also check in the Retell assistant logs to confirm that it thinks it’s calling your custom function.