Create a Bot in Voiceflow: Dynamic Cards/Lead Generation with Google Sheets (no Zapier or Airtable)

[@franknillard]

Damn! Well done man. Genius move with the API GET Request!

[@FarthinkAI]

Thank you for your support!

[@franknillard]

@@FarthinkAI I need some help in one of the steps. I am not able to showcase the objects,I try to filter through and do JSON.stringify and even the methods you show, but I get a "0". Can we go in detail through the process?

[@FarthinkAI]

You may check if the API call has returned the expected data.

[@izielisakov3264]

Thank you!

[@FarthinkAI]

Thank you, too!

[@e-Course.]

@@FarthinkAI may I have that file please ,

[@FarthinkAI]

@@e-Course. All the requested templates have been sent. If you have not requested the template, please go to: forms.gle/8E7xfqccKvVPQxnr9

[@e-Course.]

@@FarthinkAI I did dear , but not recieve anything

[@FarthinkAI]

Just received your request, and the template has been sent to you.

[@e-Course.]

You are amazing

[@FarthinkAI]

Thank you very much!

[@MaliRasko]

thank you very much for this. Appreciate it

[@FarthinkAI]

You're very welcome!

[@ehoh16]

Hi, there, is it possible to send several variables in the "parameters" section of the API block? It works for 1 variable but when I send 2, the 2nd variable doesn't appear in the JSON response. Can you please help me? Thanks

[@FarthinkAI]

I am not sure if the API can take more than one parameter, because it then would return two or more different responses. To solve your problem, I would take a big trunk of the response, and use two local variables to save the data you need. This may give you a large response data including those you do not want, but I think it would work.

[@ehoh16]

@@FarthinkAI Thank you for your reply, ill test it

[@ArmandJensen-Bennet]

Amazing video! BTW, I've filled in the form, but I didn't receive any template. Thanks

[@FarthinkAI]

Sent.

[@ArmandJensen-Bennet]

@@FarthinkAI Thank you very much!

[@heshamhosny3549]

hi can i make the reverse ? send data from voice flow to sheet? like if i want to collect name and some data from user and send it to sheet can you guide me how ? i want to collect data on the block for example block 1 i asked for name and user replied , it automatic being send to sheet , i dont want the user to end the chat with chatbot to send all data

[@FarthinkAI]

You may use a form to collect the user information as shown in this video: kzbin.info/www/bejne/ppSwiqWihcZ8l5o

[@eeling9212]

what is the variable should i put for the order button, in order to save the pizza type to google sheet?

[@FarthinkAI]

You may create a variable to save the pizza type when clicking on the button. On your google sheet, you may have a column with the name of PizzaType, and in the API, you can pass the variable to save to the Google sheet.

[@ehoh16]

Hi, how do you get the GET URL on the dynamic cards first API call ?

[@FarthinkAI]

It looks like it is no longer available in their docs. But the GET URL still works.

[@SyedBukhari-n3o]

@@FarthinkAI It doesnt work for me, I get the message that I need to provide a sheet Id?

[@nagamanu4246]

Is it possible to use the get command and link it to the sheet and use a search function in the chat instead of pressing next and cycling along.

[@FarthinkAI]

Yes. After fetching the data, you may filter the data and display the related products.

[@gtxprime]

Is there any way to only fetch items which have 'money' word in description in Google sheets? Like only those types of items that user have searched for but not all

[@FarthinkAI]

Not sure. Will look into it.

[@gtxprime]

@@FarthinkAI please check it would be really helpful for me

[@FarthinkAI]

To get the free Voiceflow template, please click: forms.gle/8E7xfqccKvVPQxnr9

[@e-Course.]

I could make it work , same as you said

[@FarthinkAI]

Glad to hear that!

[@e-Course.]

@@FarthinkAI Hope to meet you in discord

[@mohdfaizankhan4000]

I don't understand API url? Please can you tell me about this.

[@FarthinkAI]

You may learn API from this webpage: docs.voiceflow.com/reference/api-overview

[@arsviedma]

❤

[@FarthinkAI]

Thank you! ❤

[@nagamanu4246]

Can qe use captia so that its not spammed for lead generation

[@FarthinkAI]

Yes, I think so. Good idea!

[@MaliRasko]

Could you make a video and show how to connect Voiceflow to Notion table/ database? that would be a bomb

[@FarthinkAI]

Yes. We will make more videos of this kind. Thanks very much!

[@eeling9212]

I have filled in the form request for templates. But I did not receive it.

[@FarthinkAI]

Did you use the same email? If yes, already sent.

[@sabrybelal695]

how can i get the api get link ? where do i get it from i can just get the primary key from integration step

[@FarthinkAI]

The GS "GET" API link was provided by Voiceflow. But it has been removed from their docs, and can not be found any more.

[@sabrybelal695]

@@FarthinkAI so there is no alternative to get a result like in the video

[@FarthinkAI]

I think the "get API" link still works, and it is very convenient. If you want, you may use the webhook to fetch data, too.

[@aimattant]

Great Video. Can I do this with BotPress?

[@FarthinkAI]

I am not familiar with BotPress. But I think if BotPress can make API call to a Google sheet, the data can be updated there, and BotPress may have similar card blocks to show products.