01
Database Setup
Use Google Sheets™ as your primary database.
Required Tabs
Create FIVE tabs with these exact names: Tests, Users, Responses, System_Activity, Settings.
Tab: Tests
id, title, description, category, difficulty, duration, image_url, certificate_enabled, passing_threshold
02
Backend Bridge
Connect the frontend to your sheet using Google Apps Script.
GAS Template
Open Extensions > Apps Script in your sheet and paste the code below.
Deployment
Type: Web App
Execute as: Me
Access: Anyone
Copy the provided URL for the next step.
03
Frontend Deployment
Run the interface and connect it to your database.
1. Initialization
Clone the repository and install dependencies.
git clone <repo-url> npm install npm run dev
2. Connection
Set your API URL in the environment configuration.
Set API_URL in .env.local