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
users user_data
Sheet Data: user_data
user_id data_field_1 data_field_2 data_field_3 date_created
1 Project Alpha In Progress High Priority 2023-04-01
1 Project Beta Completed Medium Priority 2023-03-15
1 Project Gamma Not Started Low Priority 2023-04-10
2 Client Meeting Scheduled High Priority 2023-04-05
2 Proposal Draft In Progress Medium Priority 2023-03-20
2 Budget Review Completed High Priority 2023-02-28
3 Research Task In Progress Medium Priority 2023-04-02
3 Documentation Not Started Low Priority 2023-04-12
3 Team Meeting Scheduled High Priority 2023-04-08
1 Project Delta In Progress Medium Priority 2023-04-15
2 Client Presentation Not Started High Priority 2023-04-20
3 Code Review Scheduled Medium Priority 2023-04-18
Essential Features
Documentation
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