Build a CRM with Google Sheets + PostgreSQL + Stripe API Tutorial (Ecommerce Course)
Вставка
- Опубліковано 24 лип 2024
- Build a CRM (Customer Relationship Management tool) using the Retool low-code platform. We will be learning how to use the Google Sheet API, Stripe API, SMTP API as well as a PostgreSQL database.
✏️ Ania Kubów created this course. Check out her channel: / aniakubow
🔗 Google sheet data: docs.google.com/spreadsheets/...
🔗 Postgresql data: github.com/harryho/db-samples...
This course was made possible in part by a grant from Retool. Learn more about them here: retool.com/
⭐️ Course Contents ⭐️
⌨️ (0:00:00) Introduction
⌨️ (0:04:10) Getting started
⌨️ (0:06:24) Getting Data using the Google Sheets API
⌨️ (0:08:57) Creating Tables
⌨️ (0:38:05) Adding Data using the Google Sheets API
⌨️ (1:01:00) Deleting Data using the Google Sheets API
⌨️ (1:05:10) Processing refunds with the Stripe API
⌨️ (1:26:20) Sending emails with SMTP
⌨️ (1:45:21) Migrating to PostgreSQL
🎉 Thanks to our Champion and Sponsor supporters:
👾 Raymond Odero
👾 Agustín Kussrow
👾 aldo ferretti
👾 Otis Morgan
👾 DeezMaster
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news
I had such a fun time teaching this course! I hope everyone enjoys the video. Big love as always to the amazingly supportive freeCodeCamp community. I am always so touched by your kindness and support, not just to me, but to one another. :)
I ❤ 😍 💖 ❣ 💕 u
Hello I need to know more about retool
Best of course
Since FreeCodeCamp is like a open source project, you might have used APPSMITH instead of RETOOL. By the appsmith link is here www.appsmith.com/
Always a pleasure seeing your face on the vide thumbnail here
Started off with HTML, CSS and JavaScript. Delved into backend through Python, stupendously fell in love with Django and PostgreSql then you guys upload this just when I was thinking about it for my personal project. Everything I have learnt, I have learnt through this channel and documentation follow-up. Thank you.
@@dimtim7829 I've used them for a little over a year, and like I said, I supplement their videos by reading through documentation.
learnt is not a word.... It's learned.
@Dheeraj Kukkadapu Learn Learned Learnt was what was taught in school. As present tense past tense and past participle respectively. Now I'm confused ??
@@BelowAverageRazzleDazzle you are incorrect, sir. Learnt is a word, and it is used more frequently than learned outside of the US and Canada.
@@jacobsiddall8476 apparently it is... in English-GB. But not in English-US.
I would like to thank the entire freecode camp team from bottom of my heart ❤️, you guys are unsung Hero's, May God bless you all Abundantly 🙌🏻
I built a CRM after someone told me it couldn't be done. Right now I have about 10,000 customer accounts listed and it is growing daily. It's for office services ( Copiers / IT Services / VOIP ) and is a lot more basic than this one, but contains all the information I need broken down by service terms dates / alphabetically / industry and includes all company and contact information. I've been working on it daily since 2014 - when at the time I barely knew how to create/edit an Excel spreadsheet. My best advice to anyone is to create 'the perfect format' for your business and make sure all new information is input in that format.
Hey, can you give a bit more brief on how you did it (tech stack). Plus, it would be great if you can share the necessary functions one must add to make it professional
Nice work Lori. thanks for sharing. Hard work and determination wins again.
So awesome! The best YT channel with great instructors! Thank you Ania for your time and amazing teaching skills! 😍
This is super kind of you to say! Thank you so much for the kind words and support. 💚
I'm halfway through the tutorial. LOVED IT. I know 0 SQL, 0 Javascript and was able to build the CRM thank you so much!!!!
This was so exciting to watch and learn from. Thank you!
Amazing Content and I have learn so much from you and hope to see more projects like this in future 😊
I am looking forward to this course.
Your approach is very insightful and easy to understand.
❣️❣️
I have always wondered what a CRM was, but you explained it perfectly, thanks.
Thanks for the tutorial Daenerys
👑🐉
awesome kudos indeed G
getting a true grasp of the
real CRM power as usual...
Kudos,
I really enjoyed this tutorial and I see it as an awesome Backend CRM.
You Nailed it.....
"Just Like So"
This looks like a fun project 🎉, excited to get started!
loved this course ❤️
Thank you so much Kunal!
Well, I am in love with the instructor. ❤️❤️
Thank you for this course and your time this is so golden
You guys are the better than a university professor :)
As expected amazing content 👍🏼🎉🙏⭐
Thanks so much Mahendra!
Thank you. Keep up the good work👍👍
Thank you for your time and amazing teaching skills!
Ania rocks, awesome videos girl!!!
.75 speed if you want to follow allong. Great tutorial, thank you so much!!
Thanks for this important tutorial 🥰
Im in love with your eyes and the way you teach 😍, will look more into your vids. Thanks a lot
Woooww! So Beautiful !
Thank you for another great video.
Thank you very much for this great video
Thank you very much. Not bad at all. well done!
Great session and very informative.
Some Ideas :
1) Please include Retool in the title as it is the main part of the video
2) In the Postgre DB creation - You need to not create the DB which took me a while to work out. In the video you say take the line out but it should be the whole section and it cuts to being rmeoved but is very hard to see.
3) It would be great if the SQL Database was tidied up with the vaa length set to 40, the DB creation part removed and for the DB entry a comment like which someone could do a replace on. ( If you cut the Craete Sales order part out of teh SQL you can still do a find and replace )
4) On the sending an email section if you are using Google Workspace you will need to enable unsecure application access for teh isnatnce and then enabe POP & IMAP. I waited 24 hours before it kicked in for the user.
I am going to try some other No Code App to see if Can link them to Sheets and SQL.
Many thanks for the great session.
How about no, no one is going to message your scam whatsapp group, gtfo
Number 4 doesnt work anymore
Which other No Code App did you try? To me, Retool didn't seem that good when doing this tutorial.
I love your way teaching code
Superb keep Rocking
Amazing, Thank you
Thank you!
Awesome dear ana for those great knowledge
Thanks so much for watching!
Thanks for the video! I'm just still exploring the best CRMs. I guess it's quite cumbersome, or maybe I don't understand something. I mean, I currently use Flowlu because it's an all-in-one CRM and it saves lots of time for me on doing boring to-dos and setting up everything on my own in techincal way. They have an open API, so it's easy to integrate it with everything.
Very good ✌️🇧🇷
Wow this would save me so much money
Thank you for taking you time to make this course simler for someone like me
Hope you enjoy! 💚
@@aniakubow Sure, i did
Beautiful information
Thank you Khalessi
You are my dream teacher Ania. What a kind of expertise and beauty, Thank You !!!!
👋👋👋🙏🇱🇰❤️👍
I am not even Techie, I just came to see and hear her talk those beautiful sea eyes and snowy hair of December winter. Like Emilia Clarke (Daenerys Targaryen) in GOT. 😍. Beauty with Brains.. 🥰💐 love from India 🇮🇳
Yea good luck implementing it for big companies
Ania Plz inform us in which platform it is more useful to benefit us. Plz describe more elaborately.
Postgres forevaaa 🔥
Thank you 🙏
Hi thanks for the video. It is usefull. I have a question please: how to make this statistic: how to make a sum of a column (statistics)?
Thank you for the course. I have been struggling for 2 weeks trying to get the emailText resource to appear in the text area from the "processing refunds in the stripe API area" and am losing hope! I double checked and have entered all of the code as shown in the video -- Please help??
Amazing
Very nice👍👍👍👍
thank you so much my pretty lecturer
Thank you 💞
Thanks for watching Usha!
great toturial. do someone know how to make the last filter search bar but using the google sheet data?
I'm struggling with how to package something like this for sale. I've built a Google sheet with a google app script front sheet entry form, but don't know how to put it together to sell. Any hints ?
Love u.... respected one
Successful people don't become that way overnight. What most people see at a glance wealth, a great career, purpose is the result of hard work and hustle over time. I pray that anyone who reads this will be Successful in life
Bitcoin is exciting because it shows
how cheap it can be. Bitcoin is better
than currency in to that you don't have
to be physiclly in the same place and of course,for large transactions, currency can get pretty Inconvenient.
Well think it's working there may be other currencies like it that may be even better. But in the meantime, there's a big industry around Bitcoin-people have made fortunes off Bitcoin, some have lost money.its is volatile,but people
make money off volatility too.
When Bitcoin currency is converted from currency into cash, that interface has to remain under some regulatory safeguards. I think the fact that within the bitcoin universe an algorithm replaces the function of the government... (that) is actually pretty Cool.
It is not a speculative investment even though it is being used as such by other people. As Bitcoin
network grows the value of Bitcoin
grows. As people move into Bitcoin for payment and receipts they stop using US Dollars,Euros and Chinese Yuan which in the long-term devalues these Currencies
Bitcoin is the beginning of something great: a currency without a government,
something necessary and imperative. But I am not familiar with the specific
product to assert whether it is the best
potential setup. And we need a long time to establish confidence.
Thank you
thanks teacher
That was a great introduction course on retool! After finishing the development of the app, how can we deploy the app on production? How can we use the app outside the retool?
1:49:14 you could simply select those lines from to and replace all within selected area
Gracias por el aporte
.
A new update in retool.
Instead of "Tab" use "Tabbed Container" to perform all these steps inside.
Thanks a ton. I was stuck at this very place, and couldn't understand how to move past this.
Wow, nice one
Cool video. We use google sheets + jotform tables.
hi, what is the prerequisite for this course, especially programming language needed?
Google Sheets API and Strapi API works mostly with JavaScript. That would be, and mySQL (for Postgre)
@@diegoalvarez437 either of those APIs can be used in multiple languages
I really would like to to know, how do you get the data into the sheet, from northwind ? You are talking very fast, and moving very fast, I am interested in your training
I want to try it
Has anyone done the video from start to finish and got the full result? Because some comments say that there is no need for a database or these parts are not explained and are incomplete. I don't want to start and be interrupted because I am not very dominant.
In a second question, I want to put a form on the contact page and want this form to fall into the crm we have created. How can we do this?
Thanks!
Hi Dear , how about user and manager access? And how to integrate asterisk with this CRM? Is it possible?
also wondering
Hello how to make a textinput search with googlesheet (at the end of the video) please?
Hello, thanks for the video. Why the refund is 1 pound but it comes out 0.01 pound on dashboard ? How to deal with currencies ? thanks
awesome! but how to create a bunch of buttons for services in menu for example? Like this -client's order is: chocolate, Cinnabon and coffee. - so every client has it inside his order? thanks a lot!
you should include how to setup database when signing up with retool.
any way to make SCM+ERP+CRM and connecting it with security devices. PLEASE its very very important
@AniaKubow What are the benefits using PostgreSQL over MySQL?
Hello, can you generate PDF report or something? maybe using a template or docx file.
I'm Using a newer version of retool , i just want to know how to hide the column as the updated version has no such options
main thing before doing this project copy the excel sheet into your own Drive. this will help you doing this project swiftly
Next video! How to make an Arc Reactor, please.
謝謝！
I want to build nocode tool what should I learn and how I can do that? Can anyone guide me
The way you explain❤
Thanks so much!!!!
Good to See Khalisi Has found a new life in IT after Game of Thrones ended so tragically
Beautiful and intelligent
can you make the id auto generated?
That's soo amazing, shame I'm ready in other course can't watch now
Thanks so much for your continuous support! On my channel and here :)
@@aniakubow Yes, I'm big fan not only for your high quality development content (specially vanilla js with games like pacman), but I also admire you as person, you are always giving superb smiles with good attitude and this cute blonde face make any RPG nerd die inside by thinking you are some elf queen who escaped the game lol.
nice
Can this work with Microsoft excel
Nice
is this free to use retool?
@freecodecamp I'm building a song request sheet with Google sheets is there anyway you could help
the dragon Queen has returned to us...
You are so so great.
this is amazing. can we build a CRM with microsoft 365 excel spreadsheets as well? thank you
Yup with some data cleaning and some power query why not?
Please make a Tutorial on how to build a CMS with PHP and MySQL or similar technologies - it would be much appreciated.
Lessssssssss go
When did Mother of Dragons started giving CRM lesson😂😂
🐉👑
thank you so much Mother of dragons