Metadata-Version: 2.4
Name: gsheet-loader
Version: 1.0.1
Summary: A simple package to load Google Sheets into pandas DataFrame
Home-page: https://github.com/arshadziban/gsheet_loader
Author: Arshad Ziban
Author-email: Arshad Ziban <arshadziban031201@gmail.com>
Project-URL: Homepage, https://github.com/arshadziban/gsheet_loader
Project-URL: Repository, https://github.com/arshadziban/gsheet_loader
Keywords: google sheets,pandas,dataframe,csv,data loading
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Science/Research
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.7
Classifier: Programming Language :: Python :: 3.8
Classifier: Programming Language :: Python :: 3.9
Classifier: Programming Language :: Python :: 3.10
Classifier: Programming Language :: Python :: 3.11
Classifier: Programming Language :: Python :: 3.12
Requires-Python: >=3.7
Description-Content-Type: text/markdown
Requires-Dist: pandas
Requires-Dist: requests
Dynamic: author
Dynamic: home-page
Dynamic: requires-python

# gsheet_loader

A simple Python package to load Google Sheets into pandas DataFrame.

## Installation

```bash
pip install gsheet-loader
```
## Requirements

- Python >= 3.7
- pandas
- requests

## Usage

### Basic Usage

```python
import pandas as pd
from gsheet_loader import load_sheet

# Load a Google Sheet
url = "google sheet url here"
data = load_sheet(url)
df = pd.read_csv(data)
```

## API Reference

### `load_sheet(sheet_url)`

Load a Google Sheet and return as StringIO (ready for `pd.read_csv`).

**Parameters:**
- `sheet_url` (str): The Google Sheet URL (sharing link or edit link)

**Returns:**
- `StringIO`: StringIO object containing the CSV data

**Raises:**
- `ValueError`: If the URL is not a valid Google Sheets URL
- `requests.RequestException`: If there's an error fetching the sheet

## Note

The Google Sheet must be publicly accessible (set to "Anyone with the link can view") for this package to work.

## Author

Arshad Ziban

## Version

1.0.0
