Settings
Google Sheets configuration and setup guide
Environment Variables
Create a .env.local file in the project root with the following variables:
GOOGLE_PROJECT_IDYour Google Cloud project ID
Required
GOOGLE_CLIENT_EMAILService account email address
Required
GOOGLE_PRIVATE_KEYService account private key (with \n for newlines)
Required
GOOGLE_SHEET_IDThe ID from your Google Spreadsheet URL
Required
Google Sheet Structure
Create a Google Spreadsheet with two sheets named exactly as shown below. Share the spreadsheet with your service account email (Editor access).
Projects
ID
Project Name
Client Name
Description
Allocated Hours
Clocked Hours
Consumed Hours
Balance Hours
Status
Created Date
Time Entries
ID
Project ID
Project Name
Employee Name
Date
Task Title
Task Description
Hours Worked
Created Date
Setup Steps
- 1Go to Google Cloud Console and create a project
- 2Enable the Google Sheets API
- 3Create a Service Account and download the JSON key
- 4Create a Google Spreadsheet with 'Projects' and 'Time Entries' sheets
- 5Share the spreadsheet with the service account email
- 6Copy credentials to .env.local and restart the dev server
Google Sheets is the only database. No SQL or NoSQL databases are used. All data is stored and retrieved directly via the Google Sheets API.