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.
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.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.