🎯 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
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
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.
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..
Hi!! so im using botpress for a clg prject! so the problem im facing is that when i integrate the botpress to a website using that export src code, the user input given is not getting stored in the google sheets? could you help us out!
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!
Thanks man, I'm one step closer to completing my school project thanks to you.
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 ❤
subscribed and liked
🎯 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
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.
Thank you so much for this video! straight to the point and easy to follow :)
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.
Hey Paul great video. When I added gsheetsuccess it came up as false
Where can I find the code to get data from Google Sheets and display to user in the chatbot? Worked really well, 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..
not working , lead data was in red
Hi!! so im using botpress for a clg prject! so the problem im facing is that when i integrate the botpress to a website using that export src code, the user input given is not getting stored in the google sheets? could you help us out!
interesting! can this be used to sync complete tables with Google Sheet ?
Yes, absolutely
God bless you with long life, you have saved me many sleepless nights, and money. Greetings from Equatorial Guinea, Central Africa
Thanks a mill!
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
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.
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!
Thinks
Can this be linked to whatsapp bot?
yes, but you you need a meta developer account.