This repository contains a Python project that utilizes the Google Sheets API to work with a specific Google Sheets document. Follow the steps below to set up and run the project:
- Python: Ensure you have Python 3.x installed on your system. If not, download and install it from the official Python website.
-
Create a Virtual Environment:
Create a new virtual environment named "venv":
python -m venv venv
-
Activate the Virtual Environment:
-
On Windows:
venv\Scripts\activate
-
On Unix or MacOS:
source venv/bin/activate
-
-
Install Dependencies:
Install the project dependencies using pip and the provided
requirements.txt
:pip install -r requirements.txt
-
Google Sheets API Key:
Obtain a Google Sheets API key. Save the API key as
service_account.json
and place it in~/.config/gspread/
.
-
Copy the Google Sheets Document:
Make a copy of the Google Sheets document available at the following URL: https://docs.google.com/spreadsheets/d/1j_CulCc3jxLVv-pTeYnyd35H6sFlLlAJa9wIrr5XHMs
-
Update the Sheets URL Parameter:
Open
main.py
and update thesheets_url
parameter with the new Google Sheets document URL.
-
Run the Python Script:
Run the main Python script:
python main.py
This will execute the script and interact with the Google Sheets API.
- Ensure you have the necessary permissions and access to the Google Sheets document and the Google Sheets API for the desired operations.
- For any issues or inquiries, contact the project maintainers or contributors.
This should render properly on GitHub. Let me know if you need further assistance or adjustments.