Build a CRM with Google Sheets + PostgreSQL + Stripe API Tutorial (Ecommerce Course)
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: https://www.youtube.com/aniakubow
🔗 Google sheet data: https://docs.google.com/spreadsheets/d/1aKglh0-w8dwyKssc9CJwKiOqTc-COPCuyx4zXnuv3Wg/edit?usp=sharing
🔗 Postgresql data: https://github.com/harryho/db-samples/blob/master/pgsql/northwind.sql
This course was made possible in part by a grant from Retool. Learn more about them here: https://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: https://www.freecodecamp.org
Read hundreds of articles on programming: https://freecodecamp.org/news