Create a free bot for your AAA using Google Sheets & Botpress (no Zapier Needed)

[@stewiegriffin8332]

Thanks man, I'm one step closer to completing my school project thanks to you.

[@aimattant]

It worked like magic. I am now a magic Excel sheet magician. You are the best. Subscribed. Keep it coming ❤

[@stussmith614]

This is brilliant Pete. Saved my budget massively. Thanks very much. I'll keep an eye out for more of your stuff. Good Work!

[@ai-edream]

That was the idea, there is also another way of using google sheets directly, I may make that video at a later time.

[@MugishaHassan-js2mb]

subscribed and liked

[@natanribeiro6536]

🎯 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

[@javieramunoz5742]

Thank you so much for this video! straight to the point and easy to follow :)

[@stablegpt]

thanks man. amazing video. very helpful 🔥🔥🔥🔥🔥

[@ai-edream]

thanks for the + comment

[@SebasKampfmann]

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.

[@tharunrokzz3080]

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..

[@MartinaCutajar]

Thanks a mill!

[@SebasKampfmann]

Hey man great tutorial but on minute 7:15 where can i find that field where you put the variable?

[@SebasKampfmann]

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.

[@ai-edream]

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 }

[@SebasKampfmann]

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

[@SebasKampfmann]

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

[@aimattant]

BotPress is updating all the time.

[@billmclellan3483]

Where can I find the code to get data from Google Sheets and display to user in the chatbot? Worked really well, thank you!

[@jj3hd101]

Hey Paul great video. When I added gsheetsuccess it came up as false

[@anonymously-k5j]

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!

[@awakenwithoutcoffee]

interesting! can this be used to sync complete tables with Google Sheet ?

[@ai-edream]

Yes, absolutely

[@FelicianoBUERIBERIIÑANG-o2g]

God bless you with long life, you have saved me many sleepless nights, and money. Greetings from Equatorial Guinea, Central Africa

[@LuminysAI]

Great video, I've been looking for a solution that didn't use Zapier or third-party bridging

[@ai-edream]

Thanks, Part 2 coming next week 11 sept to 16 th depending on how long it takes me to edit the video

[@idatascience630]

Thinks

[@viveks4617]

not working , lead data was in red

[@charlesdavidsuico4209]

Hello! It's giving me a error 400 when trying to install Webhook for Sheets

[@ai-edream]

do you have a gmail account? its far easier to use if you do.

[@albertlawandos8674]

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?

[@ai-edream]

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!

[@pulendlovu3245]

Can this be linked to whatsapp bot?

[@ai-edream]

yes, but you you need a meta developer account.