When your diary is in your own Google Sheet, Daybook has no server for it. Everything you log goes straight from your phone or browser to a Google Sheet you own, through a small script (called an Apps Script Web App) that lives inside that Sheet. You deploy your own copy — it's free, and Google never sees Daybook, only you.
You'll do steps 1–6 once, in Google's own site. Step 7 is back here.
Signing in with a Dhruvanta account is entirely optional and has no effect on any of this — it's still step 7 either way. It only adds a later, optional choice in Settings to sync this same URL and key across your devices.
Create a Google Sheet
Make a new, blank spreadsheet. Name it anything — e.g. "Daybook Log".
Open Google Sheets ↗Open Apps Script
In the Sheet's menu: Extensions → Apps Script. A new tab opens with a default Code.gs file containing a stub myFunction().
Paste in the backend script
Select all of the default code, delete it, and paste this in its place.
It's copied straight from this build (84 KB) — what you paste is exactly what shipped. If clipboard access is blocked, use "View on GitHub" and copy it from there (requires access to the private repo).
Set your API key
In the Apps Script editor: the gear icon (Project Settings) → Script Properties → Add script property. Name it API_KEY, value a long random passphrase — this is what keeps your log private, since the deployed URL from step 6 is technically public.
Run setup() once
Back in the editor (the <> icon): in the function dropdown next to "Debug", pick setup, then click Run.
After it finishes, check the spreadsheet: you should see new tabs — Events, Tags, People, Categories, Config, Security, Prefs.
Deploy → New deployment → Web app
Deploy → New deployment, click the gear next to "Select type", choose Web app, then set:
- Execute as: Me
- Who has access: Anyone
"Anyone" sounds alarming, but Apps Script has no other way to let a browser call it — what actually protects your log is the unguessable deployment URL below, plus the API key from step 4 that every request must send.
Click Deploy, authorize again if asked, then copy the Web App URL — it looks like:
https://script.google.com/macros/s/AKfycb.../execConnect Daybook
Paste the URL from step 6. The API key is already filled in if you generated it in step 4 — double check it matches Script Properties exactly, then paste it into Script Properties there if you haven't yet.
Already have a URL and key from somewhere else? Go straight to Settings.