Create a free bot for your AAA using Google Sheets & Botpress (no Zapier Needed)
HTML-код
- Опубликовано: 19 авг 2023
- How to use google sheets FREE in botpress, these can be used for lead generation. A free bot for you to use, no zapier required!
free code here:
docs.google.com/document/d/1T...
#AIChatbots
#ChatbotTutorial
#ArtificialIntelligence
#BotDevelopment
#AIProgramming
#ChatbotDevelopment
#TechTutorial
#MachineLearning
#NaturalLanguageProcessing
#AIInnovation
#TechInnovations
#AutomationRevolution
#ChatbotRevolution
#AIAssistant
#CodingSkills
#AIChat
#TechTips
#AIForBusiness
#AIProgrammingLanguage
#LearnAI
#zapier
#ChatbotDesign
#ProgrammingTutorials
#AIChatSolutions
#AIChatSupport
#ChatbotApplications
#AIChatDevelopment
#ConversationalAI
#TechBreakthrough
#aiinnovations
#chatgpt
#voiceflow
Thank you so much for this video! straight to the point and easy to follow :)
This is brilliant Pete. Saved my budget massively. Thanks very much. I'll keep an eye out for more of your stuff. Good Work!
That was the idea, there is also another way of using google sheets directly, I may make that video at a later time.
It worked like magic. I am now a magic Excel sheet magician. You are the best. Subscribed. Keep it coming ❤
Thanks a mill!
subscribed and liked
God bless you with long life, you have saved me many sleepless nights, and money. Greetings from Equatorial Guinea, Central Africa
Thank you very much for the video. very helpful
Are you releasing a sequel?
In any case, I would appreciate it if you could direct me to learning sources, to do more complex things.
Both to do GET operations and to edit cells and more.
Thank you!
Its a wonderful content, seeing for the 1st time, its amazing thankyou, i had a query how to add payment gateway into botpress bot? A detailed video about payment gateway will be very amazing..
thanks man. amazing video. very helpful 🔥🔥🔥🔥🔥
thanks for the + comment
Hey man, maybe you can help me with that. In my case it picks only phone numbers in google sheet, i tried everything out yesterdas for 8 hours, it never works with names or email adresses only with telephonenumbers it works.
Thinks
🎯 Key Takeaways for quick navigation:
00:12 💻 Pete Webster has over 30 years of IT experience, including computer programming and network management.
00:41 📑 The video focuses on using Google Sheets for lead generation without Zapier.
01:32 🔌 Installing web hooks in Google Sheets requires specific permissions.
02:23 🔄 Each new Google Sheet requires unique setup for web apps.
03:37 ⚙️ Enabling the API and renaming the sheet are crucial steps.
04:59 🤖 The chatbot creation starts with a blank template.
06:16 📲 Multiple fields like name and phone number can be collected.
07:44 ✅ Boolean variables are used to verify successful data transmission.
09:33 ⚠️ Attention to details, such as text color, can prevent errors.
10:55 📚 A mini-series will be launched to teach coding principles that enable non-coders to program bots.
Made with HARPA AI
Where can I find the code to get data from Google Sheets and display to user in the chatbot? Worked really well, thank you!
Great video, I've been looking for a solution that didn't use Zapier or third-party bridging
Thanks, Part 2 coming next week 11 sept to 16 th depending on how long it takes me to edit the video
Hey Paul great video. When I added gsheetsuccess it came up as false
Hey man great tutorial but on minute 7:15 where can i find that field where you put the variable?
okay got it, but i have always the problem that it always exports only the telephonnumber. I have 1. Name 2. email. 3. Telephonenumber 4. Userinput but at the userinput i cant choose any variable. so how can i also export the user input? Thanks.
at 6:58 in the video in this section, you need to add ALL the variables you want to store! here is an example for anyvarname and anothervarname
const leaddata = {
name: workflow.name,
anyvarname : workflow.anyvarname,
anothervarname: workflow.anothervarname
}
Thanks for your help, but look there, i got it like that: workflow.gformsuccess = false
const leadData = {
name: workflow.name,
phone: workflow.phone,
email: workflow.email, and it always sends me only the telephone number to google sheet. Never the name and never the email. I tried it 8 hours yesterday and all the raw inputs has their correct variables. @@ai-edream
I already resolved the problem. The problem was, that i had to use a new sheet. In the old sheet it never showed up any changes.@@ai-edream
BotPress is updating all the time.
interesting! can this be used to sync complete tables with Google Sheet ?
Yes, absolutely
hey, thanks for this video, it really helped, but i have an issue after 1 API call. it's giving me this error: too many requests (error 429), is there a way to fix it?
I've never heard of this problem before, did it resolve itself? maybe google was busy. If not did you try making another one? If anyone else has had this problem, please let me know in the comments!
Hello! It's giving me a error 400 when trying to install Webhook for Sheets
do you have a gmail account? its far easier to use if you do.
Can this be linked to whatsapp bot?
yes, but you you need a meta developer account.