/google-sheets

Connect to Google Sheets to read, analyze and write data. Pure Ruby, zero gems — stdlib only.

Structure

scripts/
├── auth.rb          # JWT auth + sheets_request helper (required by all scripts)
├── check_setup.rb   # Check if key file exists (outputs OK or SETUP_NEEDED)
├── save_key.rb      # Save a Service Account JSON key
├── list_sheets.rb   # List tabs in a spreadsheet
├── read.rb          # Read data (entire tab or specific range)
├── write.rb         # Write to a range
└── append.rb        # Append rows at the end

Setup (check before using)