Building Full Stack Python Web Apps Backed By Google Sheets

Focused View

Andy Bek

12:00:14

0 View

1 - Python vs Worksheets

1 -Welcome!.mp4

02:54

2 -My Other Work.mp4

00:46

2 - Introduction To The Google Sheets API

1 -High-Level Concepts.mp4

02:53

2 -Credentials And Service Account.mp4

07:47

3 -Virtual Environment And Dependencies.mp4

06:02

4 -Setting Up The Sheets Service.mp4

05:03

5 -Inserting Values Into Existing Sheet.mp4

05:55

6 -Programmatically Creating New Sheets.mp4

07:17

7 -Managing Permissions Through The Drive API.mp4

04:17

8 -The Discovery Document.mp4

02:50

3 - Building The Python API Layer

1 -Setup And Dependencies.mp4

03:16

1 - Section Resources + All The Code Files.html

2 -Scaffolding The API.mp4

05:06

3 -Defining A Sheets Abstraction.mp4

06:46

4 -Service Account Credentials.mp4

07:14

5 -Injecting Dependencies In FastAPI.mp4

05:00

6 -Creating A New Sheet.mp4

07:46

7 -Permissioning A Specific User Or Anyone.mp4

06:12

8 -Pydantic Models.mp4

05:29

9 -Swagger UI API Documentation.mp4

04:25

10 -API Routers.mp4

07:30

11 -Rename Spreadsheet Operation.mp4

07:48

12 -Adding The Route Handler.mp4

08:13

13 -Deleting Spreadsheets.mp4

06:59

14 -Extra Centralizing Exception Handling.mp4

09:06

15 -The Worksheets API Router.mp4

13:30

16 -Navigating Between Sheet Names And Ids.mp4

09:30

17 -Renaming A Worksheet.mp4

10:10

18 -Reading Worksheet Data And Returning JSON.mp4

13:20

19 -Writing Data To A Worksheet.mp4

11:14

20 -Handling Rows With Asymmetric Dimensions.mp4

10:36

21 -Appending Records With New Dimensions.mp4

20:50

22 -Handling Multiple New Columns Correctly.mp4

08:22

23 -Implementing Auto-Incrementing Ids.mp4

10:23

24 -Adding New Worksheets.mp4

04:47

25 -Clearing All Worksheet Content.mp4

04:20

26 -Deleting A Worksheet.mp4

04:46

27 -Introducing Environment Variables.mp4

05:12

28 -Creating Expirable JSON Web Tokens.mp4

07:28

29 -Implementing The token Endpoint.mp4

09:12

30 -Adding Some Missing Dependencies.mp4

02:34

31 -Authentication And JWTs.mp4

06:16

32 -Defining An Auth Dependency.mp4

08:30

33 -Protecting Routes With Token-Based Authentication.mp4

07:22

34 -Finishing Touches.mp4

04:11

35 -Relaxing The CORS Policy.mp4

05:25

36 -Deployment Checklist.mp4

02:25

37 -Locking Dependencies And Config.mp4

03:56

38 -Git And .gitignore.mp4

04:52

39 -GitHub Remote Repository.mp4

03:50

40 -Deploying To The World Wide Web.mp4

05:18

4 - Creating User Interfaces With React And Next.js

1 -The Big Picture.mp4

02:54

1 -gsheets-ui-main-repo.zip

1 - Section Resources + All The Code Files.html

2 -JavaScript, Node, React, And Next.js.mp4

06:00

3 -Setting Up A New Project.mp4

03:19

4 -Running The App.mp4

04:49

5 -Our First Component.mp4

13:25

6 -Controlling Components With JavaScript.mp4

05:30

7 -Styling Interfaces With Tailwind CSS.mp4

14:40

8 -Obtaining the JWT From The Backend.mp4

11:15

9 -Adding Interactivity To The Form.mp4

11:49

10 -Next.js Environment Variables.mp4

03:27

11 -Client-side Accessible Env Variables.mp4

03:10

12 -Conditionally Rendering On Successful Login.mp4

07:22

13 -Passing Down Props To Other Components.mp4

05:02

14 -Creating A New Workbook For Our Online Store.mp4

05:42

15 -Seeding Our Inventory.mp4

02:40

16 -Fetching Inventory Data Via The API.mp4

11:31

17 -Rendering Products.mp4

07:21

18 -Styling The Products Grid.mp4

06:24

19 -Defining A New ProductCard Component.mp4

04:22

20 -AddToCart Functionality.mp4

05:06

21 -Header With View Cart Button.mp4

04:21

22 -Opening And Closing The Cart.mp4

06:27

23 -Cart Container.mp4

02:32

24 -Displaying Items In The Cart.mp4

04:45

25 -Removing Items From The Cart.mp4

05:03

26 -Unique Cart Item Ids.mp4

04:10

27 -Calculating And Rendering TotalAmount.mp4

07:02

28 -Introducing A Checkout Button.mp4

03:47

29 -Creating The Orders Worksheet.mp4

02:43

30 -HandleCheckout From The UI.mp4

11:27

31 -Generating Unique Order Ids.mp4

05:07

32 -Updating Cart State On Order Checkout.mp4

04:54

33 -Persisting The Authentication Token.mp4

08:32

34 -Deploying The User Interface.mp4

02:52

35 -Deployed App.mp4

02:15

36 -Thank You!.mp4

00:46

5 - Appendix - Python Fundamentals

1 -Data Type.mp4

02:35

1 -notebook resource.zip

1 - A Quick Note + Section Resources.html

2 -Variables.mp4

08:27

3 -Arithmetic And Augmented Assignment Operators.mp4

07:16

4 -Ints And Floats.mp4

08:54

5 -Booleans And Comparison Operators.mp4

05:12

6 -Strings.mp4

07:52

7 -Methods.mp4

06:29

8 -Containers I Lists.mp4

06:08

9 -Lists vs. Strings.mp4

06:53

10 -List Methods And Functions.mp4

07:54

11 -Containers II Tuples.mp4

04:43

12 -Containers III Sets.mp4

10:32

13 -Containers IV Dictionaries.mp4

05:15

14 -Dictionary Keys And Values.mp4

08:14

15 -Membership Operators.mp4

04:28

16 -Controlling Flow if, else, And elif.mp4

08:21

17 -Truth Value Of Non-booleans.mp4

03:28

18 -For Loops.mp4

05:05

19 -The range() Immutable Sequence.mp4

05:10

20 -While Loops.mp4

05:55

21 -Break And Continue.mp4

04:15

22 -Zipping Iterables.mp4

03:39

23 -List Comprehensions.mp4

07:47

24 -Defining Functions.mp4

10:18

25 -Function Arguments Positional vs Keyword.mp4

06:54

26 -Lambdas.mp4

05:28

27 -Importing Modules.mp4

05:38

Description

Develop and deploy a full-stack application using Python, Google Sheets, FastAPI, React, Next.js, and Tailwind CSS

What You'll Learn?

Build a universal Python JSON API that connects to a virtually infinite number of Google Sheets
Gain terrific, hands-on practice building and deploying full stack Python applications
Enable authentication with JSON Web Tokens (JWT) and protect routes and operations
Build and deploy a modern user interface with React, Next JS, and Tailwind CSS
Practice using Google Sheets as application databases for Python APIs
Explore the Google Sheets and Drive APIs from the ground up in Python

Who is this for?

Enthusiastic beginners or developers looking to build full-stack Python applications backed by Google Sheets

What You Need to Know?

A computer (Windows/Mac/Linux). That's all!

Some experience with python would be a plus, but is not required.

No prior experience with web development is required.

More details

Description
Welcome to the best resource online for learning full-stack Python web development with Google Sheets.

This course offers a truly unique learning experience on Udemy. While there are hundreds of online Python courses to choose from, very few get you building real-world applications that have actual utility from the ground up.

By the end of this course you will have deployed a universal Python web API that could connect to a virtually infinite number of workbooks. Functionally, this will be quite similar to several SaaS (software-as-a-service) businesses that you find on the web, services like SheetDB, SteinHQ, SheetBest, Sheety that offer JSON APIs on top of Google Sheets - obviously for $/month.

In this course, you will develop a Python application that does just that! Except we will write every line of code together and in the end deploy the application to the web for free!

We are going to do this step-by-step, starting with the very basics of setting up service accounts to enable the sheets and drive APIs, then moving on to the implementation of operations like creating and managing worksheets, reading, writing, and appending data, automating common tasks, managing updates, protecting our routes with authentication, and a lot more.

The course features four in-depth sections that guide you from the basics of python all the way to creating and deploying fully functional modern APIs and user interfaces.

In the first section you will:

Uncover the power of Google Sheets as a flexible, cloud-based database alternative
Understand the details of authentication using service accounts
Set up a professional development environment with virtual environments
Learn to programmatically create, read, update, and delete Google Sheets through Python
Explore the secret weapon of API developers: the Discovery Document

Then, we'll dive head-first into Python to:

Craft a robust API using FastAPI, the most modern and lightweight Python web framework
Design elegant object-oriented abstractions for Google Sheets interactions
Implement industry-standard authentication with JSON Web Tokens (JWT)
Master advanced data handling techniques for asymmetric and dynamic data
Build a full CRUD (Create, Read, Update, Delete) API for Google Sheets
Dive deep into error handling and security best practices
Learn deployment strategies to take your API from local to global

Finally, we'll switch gears to user interface (UI) design and development. You will:

Jumpstart your journey into the world of React and Next.js
Design highly responsive, modern UIs with Tailwind CSS
Implement authentication flows
Design an e-commerce storefront from scratch
Master state management for complex user interactions
Deploy your user interface to the web

And if you're new to python, don't worry! There is a full-length python primer included in the course that will get you up to speed in no time. This is included as an appendix to the course and covers all the basics of Python programming. It is designed to be a quick reference for those who are new to Python or need a refresher on the basics.

By the end of this course, you will have:

Built a production-ready universal API that interfaces with Google Sheets
Mastered the full stack: from the backend to the middleware API to the user interface
Gained real-world experience in Python, FastAPI, React, and Next.js
Developed and deployed a portfolio-worthy project to showcase your new skills

I'm excited to have you on board. Let's get started!
Who this course is for:
Enthusiastic beginners or developers looking to build full-stack Python applications backed by Google Sheets

User Reviews

Rating

average 0

Total votes0

Focused display

Python

Andy Bek

Instructor's Courses

Hi! I'm Andy. I'm freelance software developer and capital markets consultant. I've spent close to a decade working with data, using code to automate business workflows, and consulting financial institutions on data-intensive applications.Aside from teaching, I run a AI and data consulting firm that targets fintechs in the post-trade services niche.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.