Data Automation
SheetAlchemy
Google Sheets ORM for Python with Django-style queries
Overview
A Python library providing an ORM interface for Google Sheets. Interact with spreadsheet data using Python objects and Django-like query syntax.
Features
- Model-based approach — define Python classes for Google Sheets tabs
- Rich field types — String, Integer, Date, Boolean, Decimal, List, Custom
- Django-style queries — familiar filtering with field lookups
- Data validation — built-in type validation and error handling
- Load policies — configure eager or lazy data loading
- Data transformation — automatic cleaning of spreadsheet issues
- Authentication management — seamless Google Sheets API auth
Installation
pip install sheet-alchemy — requires Python 3.8+
Status
Active development