Real Google Sheets Login

Login with Google Sheets
Available Users for Testing
ID Email Password Name Role Status
1 john.doe@example.com password123 John Doe user active
2 jane.smith@example.com securepass456 Jane Smith admin active
3 bob.johnson@example.com bobpass789 Bob Johnson user active
4 alice.williams@example.com alicepass101 Alice Williams editor active
5 charlie.brown@example.com charliepwd202 Charlie Brown user inactive
6 diana.prince@example.com dianapwd303 Diana Prince user active
7 edward.stark@example.com edwardpwd404 Edward Stark admin active
8 fiona.green@example.com fionapwd505 Fiona Green user active
9 george.miller@example.com georgepwd606 George Miller editor active
10 hannah.baker@example.com hannahpwd707 Hannah Baker user inactive
About This Page

This page demonstrates a real login system using Google Sheets as a user database:

  • Displays all users from your Google Sheet for testing
  • Authenticates users against the actual data in your Google Sheet
  • Shows user-specific data after successful login
Note: Make sure your Google Spreadsheet has:
  1. A sheet named 'users' with columns: id, email, password, name, role, status
  2. A sheet named 'user_data' with columns: user_id, data_field_1, data_field_2, etc.
Back to Main Page