We just released Spreadsheet Web Scraper — extract public google sheets data to csv/json via api key.

What it does

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

Get it

Download Spreadsheet Web Scraper for $29 →

Built by OddShop — Python automation tools for developers and small businesses.