Transform your Google Spreadsheet into a professional Inventory and Asset Tracking system. 

Smart Check-In System eliminates the need for expensive handheld scanners or complex software. It turns any smartphone into a powerful barcode and QR code scanner that syncs directly with Google Sheets in real-time.

Designed for schools, libraries, and IT departments, this add-on simplifies the process of checking items in and out. Whether you are managing a school library, tracking Chromebooks, or lending equipment, Smart Check-In System provides a seamless, mobile-first workflow.

Key Features:

• Mobile Scanner Web App: Instantly generate a secure QR code to launch a mobile-friendly scanner on any device (iOS or Android). No app installation required for staff.

• Check-In / Check-Out: Easily toggle between "Issue" and "Return" modes. Scan a User ID once, then scan multiple items in a batch.

• Real-Time Dashboard: Automatically calculates inventory status. Know exactly which items are "Checked Out" and who is holding them directly inside your Google Sheet.

• Smart Metadata: The scanner displays item details (like Book Title or Device Model) and User Names instantly upon scanning for verification.

• Audit Logs: Keeps a permanent, timestamped log of every transaction, including the email of the staff member who performed the scan.

• Secure Access: Uses Google Drive permissions to ensure only authorized staff can scan items into your database.

Perfect for:

• School Libraries: Manage book lending and student returns.

• IT Asset Management: Track Chromebooks, iPads, and AV equipment distribution.

• Equipment Cribs: Monitor tools and machinery checkout.

• Event Management: Track attendee check-ins.

How it works:

1. Install the add-on and click "Setup Sheets" to generate your database.

2. Paste your Inventory and User lists.

3. Generate the "Scanner QR" and let your staff start scanning immediately!