Make Web App using Google Sheets, Python and Streamlit

TechLever · Beginner ·🔧 Backend Engineering ·1y ago

About this lesson

Join our Whatsapp Channel: https://whatsapp.com/channel/0029VanDeVpDTkK5Kxdh0u1N In this video, I’ll show you how to build a simple data entry web app using Python and Streamlit, with Google Sheets as the backend database. You’ll learn how to authenticate with Google Sheets using ServiceAccountCredentials, read and write data, and construct dynamic forms with Streamlit. Perfect for beginners in web development, data entry, or Python projects! 📌 Topics Covered: Connecting Python to Google Sheets Building dynamic forms with Streamlit Data entry and management using Google Sheets API Using Service Account credentials for Google API 🔗 Helpful Links: CODE: https://github.com/pritamsharma45/streamlit-googlesheet Google Cloud Console: https://console.cloud.google.com/welcome?project=gspreadquickstart Streamlit docs: https://docs.streamlit.io/ My Other Featured Videos: COMPLETE CRUD WEB APPLICATION USING GOOGLE SHEETS https://www.youtube.com/watch?v=ZdDB5VVW8HM Google Sheets | Data Entry using HTML Form https://www.youtube.com/watch?v=5Ta8TrPsdN8 Google Sheets | Multi Page CRUD Web APPLICATION https://www.youtube.com/watch?v=E4UaHrxCmJs Dynamically Populate Google Form's Dropdown using Google Sheets https://www.youtube.com/watch?v=5s-2A1WhI9w Invoicing Web App using Google Sheet and Apps Script https://www.youtube.com/watch?v=c4kXtSKBtGo How to Manage Client's Projects & Tasks with This Free Web Application | Google Sheets Integration https://www.youtube.com/watch?v=z7YcojVpgUc Google Sheets | Data Entry using Modal Form https://www.youtube.com/watch?v=VDuAQZJdbaA Support Me: ☕️😊 Buy me a coffee! ☕️💖 https://buymeacoffee.com/pritamsharma https://paypal.me/pritamsharma45 ------------------------------------------------------------------- ✨ Buy Multi Page CRUD Web App for only $9! ✨ It features: 📄 Customizable Multi Page Apps 📁 File Uploads 🔽 Dynamic Dropdown 🔗 Dependent and Computed Fields 🖼️ Formatting support for Image, Avatar ➕ Additional fi

Original Description

Join our Whatsapp Channel: https://whatsapp.com/channel/0029VanDeVpDTkK5Kxdh0u1N In this video, I’ll show you how to build a simple data entry web app using Python and Streamlit, with Google Sheets as the backend database. You’ll learn how to authenticate with Google Sheets using ServiceAccountCredentials, read and write data, and construct dynamic forms with Streamlit. Perfect for beginners in web development, data entry, or Python projects! 📌 Topics Covered: Connecting Python to Google Sheets Building dynamic forms with Streamlit Data entry and management using Google Sheets API Using Service Account credentials for Google API 🔗 Helpful Links: CODE: https://github.com/pritamsharma45/streamlit-googlesheet Google Cloud Console: https://console.cloud.google.com/welcome?project=gspreadquickstart Streamlit docs: https://docs.streamlit.io/ My Other Featured Videos: COMPLETE CRUD WEB APPLICATION USING GOOGLE SHEETS https://www.youtube.com/watch?v=ZdDB5VVW8HM Google Sheets | Data Entry using HTML Form https://www.youtube.com/watch?v=5Ta8TrPsdN8 Google Sheets | Multi Page CRUD Web APPLICATION https://www.youtube.com/watch?v=E4UaHrxCmJs Dynamically Populate Google Form's Dropdown using Google Sheets https://www.youtube.com/watch?v=5s-2A1WhI9w Invoicing Web App using Google Sheet and Apps Script https://www.youtube.com/watch?v=c4kXtSKBtGo How to Manage Client's Projects & Tasks with This Free Web Application | Google Sheets Integration https://www.youtube.com/watch?v=z7YcojVpgUc Google Sheets | Data Entry using Modal Form https://www.youtube.com/watch?v=VDuAQZJdbaA Support Me: ☕️😊 Buy me a coffee! ☕️💖 https://buymeacoffee.com/pritamsharma https://paypal.me/pritamsharma45 ------------------------------------------------------------------- ✨ Buy Multi Page CRUD Web App for only $9! ✨ It features: 📄 Customizable Multi Page Apps 📁 File Uploads 🔽 Dynamic Dropdown 🔗 Dependent and Computed Fields 🖼️ Formatting support for Image, Avatar ➕ Additional fi
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related AI Lessons

Up next
This Cop Was Held Accountable For His Brutality! #police #lawyer
Hampton Law
Watch →