Streamlit CRUD Application with Google Sheets

This project is a simple CRUD (Create, Read, Update, Delete) application built using Streamlit for the frontend and Google Sheets as the backend.

Prerequisites

To run this project, you'll need:

• Python 3.8+
• VS Code
• Google Cloud Project with Sheets API enabled
• A Google Sheets API credentials.json file ( Watch the video to know how to get the file)

Installation

1. Clone the Project

Clone this repository to your local machine:

2. Open in Visual Studio Code

Open the project folder in VS Code:

git clone https://github.com/pritamsharma45/streamlit-googlesheet
cd streamlit-googlesheet

3. Set Up Virtual Environment (optional)

It's recommended to use a virtual environment to manage dependencies:

# For macOS/Linux
python3 -m venv venv
source venv/bin/activate

# For Windows
python -m venv venv
.\venv\Scripts\activate

4. Install Dependencies Install the required dependencies using pip:

pip install -r requirements.txt

4.Running the Application

Run the Streamlit app using the following command:

streamlit run app1.py   # aap1.py or app2.py

This will open the app in your browser at http://localhost:8501