Google Sheets Database Demo

Connect to Google Sheet
The Spreadsheet ID is the value between /d/ and /edit in the Google Sheet URL.
Example: https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit
Sheet Data: users
id email password name role created_at last_login status
1 john.doe@example.com password123 John Doe user 2023-01-15 2023-04-25 active
2 jane.smith@example.com securepass456 Jane Smith admin 2023-01-20 2023-04-27 active
3 bob.johnson@example.com bobpass789 Bob Johnson user 2023-02-05 2023-04-20 active
4 alice.williams@example.com alicepass101 Alice Williams editor 2023-02-10 2023-04-26 active
5 charlie.brown@example.com charliepwd202 Charlie Brown user 2023-02-15 2023-04-22 inactive
6 diana.prince@example.com dianapwd303 Diana Prince user 2023-03-01 2023-04-24 active
7 edward.stark@example.com edwardpwd404 Edward Stark admin 2023-03-10 2023-04-27 active
8 fiona.green@example.com fionapwd505 Fiona Green user 2023-03-15 2023-04-21 active
9 george.miller@example.com georgepwd606 George Miller editor 2023-03-20 2023-04-23 active
10 hannah.baker@example.com hannahpwd707 Hannah Baker user 2023-04-01 2023-04-25 inactive
Essential Features
Sheet Setup Instructions
  1. Create two sheets in your Google Spreadsheet:
    • users - For user authentication data
    • user_data - For user-specific data
  2. Download the CSV templates above and import them into the corresponding sheets
  3. Make sure to share your Google Sheet with your service account email
  4. Use the "Load Data" button above to view your sheet data
  5. Try the "Test User Login" feature to test authentication