📚 Library Management System for Schools

A free, easy-to-use library management system built on Google Sheets and Google Apps Script. Perfect for small schools with limited budgets and non-technical staff.

Features

• ✅ Sign out & return books with simple dialogs
• ✅ Automatic overdue tracking with daily email reports
• ✅ Barcode scanner ready (numeric-only book IDs)
• ✅ Student & staff loans on separate tabs
• ✅ Bulk import from Excel
• ✅ Live sync with existing student/staff databases
• ✅ Zero cost — uses Google Sheets (free)

Quick Start

1. Create a new Google Sheet
2. Go to Extensions → Apps Script
3. Paste the contents of LibraryManagement.gs
4. Update the configuration (see Setup Guide)
5. Run setupLibrary function
6. Done!

See Setup-Guide.md for detailed step-by-step instructions.

Files Included

File	Description
LibraryManagement.gs	Main Apps Script code
Setup-Guide.md	Complete setup instructions
Guide-Librarian.md	Daily operations manual
Guide-Staff.md	Guide for teachers
Guide-Students.md	Bilingual guide for students

Configuration

Before running, update these values in LibraryManagement.gs:

STUDENT_SHEET_ID: 'YOUR_STUDENT_DATABASE_SHEET_ID_HERE',
STAFF_SHEET_ID: 'YOUR_STAFF_DATABASE_SHEET_ID_HERE',
FALLBACK_EMAIL: 'YOUR_ADMIN_EMAIL_HERE',

Requirements

• Google account (free)
• Google Sheets access
• Chrome or any modern browser

Screenshots

Library Menu

The custom menu provides one-click access to all functions.

Color-Coded Student Loans

• 🔴 Red = Overdue
• 🟠 Orange = Due today
• 🟡 Yellow = Due tomorrow

License

MIT License — Free to use, modify, and share.

Contributing

Issues and pull requests welcome!

---

Built for K-12 schools in India 🇮🇳