Create GoogleSheets Logs

📊 Google Sheets Integration (via SheetDB)

You can create up to two sheets for free at SheetDB. If you need more, a paid plan is required.

Enabling Google Sheets Logging

In your g-dutyV2/src/shared/sv_config.lua, set up the following:

SV_CONFIG.GoogleSheetsLogs = {
	Enable = false, -- If this is true, the script will save duty data to Google Sheets.
	Api = "https://sheetdb.io/api/v1/",
	Sheets = {
		["police"] = "", -- sheet id - replace this link with your sheetdb.io link (https://sheetdb.io/)
		-- can add more
	},
}

Replace "YOUR_SHEETDB_ID" with your actual ID from the SheetDB URL. Example: If your API endpoint is https://sheetdb.io/api/v1/abc123xyz, then use "abc123xyz".

Required Google Sheet Columns

Your Google Sheet must contain the following column headers in the first row:

identifier,job_name,name,last_clock_out,total_time