A Python CLI tool that fetches data from published Google Sheets using only the sheet ID and API key. Ideal for analysts and developers who need to pull live spreadsheet data into local files without browser automation or OAuth.
Features
- Fetch entire sheet or specific range by A1 notation
- Output to CSV, JSON, or Excel format
- Support for multiple sheets within one spreadsheet
- Automatic handling of pagination for large datasets
- Configurable via command-line arguments or config file
Usage
python gsheets_scraper.py --sheet-id 'abc123' --api-key 'YOUR_KEY' --range 'Sheet1!A1:D100' --output data.csv
Requirements
Python 3.8+. Install dependencies:
pip install -r requirements.txt
Download
Buy once, download immediately. ZIP includes the full script, README, and usage examples.
License
Personal & Commercial Use. You may use this tool in your own personal and commercial projects. Redistribution or resale of the source code is not permitted.