Build a CRM with Google Sheets + PostgreSQL + Stripe API Tutorial (Ecommerce Course)

Ecommerce Empire Academy

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:

🔗 Google sheet data:
🔗 Postgresql data:

This course was made possible in part by a grant from Retool. Learn more about them here:

⭐️ 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:

Read hundreds of articles on programming:

And subscribe for new videos on technology every day:

36 thoughts on “Build a CRM with Google Sheets + PostgreSQL + Stripe API Tutorial (Ecommerce Course)”

  1. The Last Minute Trade

    I am looking forward to this course.
    Your approach is very insightful and easy to understand.

  2. Code with Ania Kubów

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

    1. Cook with Subbhu😍

      Hello mam.. I’m ur new subscriber.. Wanna talk wit u
      … U r so sweet actually.. Really amazing ur presentation is …

  3. So awesome! The best YT channel with great instructors! Thank you Ania for your time and amazing teaching skills! 😍

    1. Code with Ania Kubów

      This is super kind of you to say! Thank you so much for the kind words and support. 💚

  4. 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 🙌🏻

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

  6. Ania Plz inform us in which platform it is more useful to benefit us. Plz describe more elaborately.

  7. Please make a Tutorial on how to build a CMS with PHP and MySQL or similar technologies – it would be much appreciated.

    1. whatsap➕➊➒⓿➑➑➒➑➌➋➋➏

      👆👆message the projected line above for questions and proper consultations

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

    1. whatsap➕➊➒⓿➑➑➒➑➌➋➋➏

      👆👆message the projected line above for questions and proper consultations. Thank you for watching

    2. Which other No Code App did you try? To me, Retool didn’t seem that good when doing this tutorial.

  9. Sarah Alegretti Marques Lima

    Hi I have been following the steps of this course but when I got to the point where I need to do a 4th query to have the employees names I get the following error:
    error:”Not Found”
    message:”Unable to retrieve information about the query “query4″”

    Any ideas to what might have happened? All the other queries (done the day before) worked just fine

    Thank you!

  10. Amazing Content and I have learn so much from you and hope to see more projects like this in future 😊

  11. Kudos,

    I really enjoyed this tutorial and I see it as an awesome Backend CRM.

    You Nailed it…..
    “Just Like So”

  12. LenguaDeGato250

    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)?

  13. Brahmajit Mohapatra

    A new update in retool.
    Instead of “Tab” use “Tabbed Container” to perform all these steps inside.

  14. this is amazing. can we build a CRM with microsoft 365 excel spreadsheets as well? thank you

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

Comments are closed.