If your secret key and web app URL aren't saved here and you can't remember them, look them up in the Google account that owns the travel-data spreadsheet:
1. In Google Drive (drive.google.com), search for your family travel data spreadsheet and open it.
2. Open Extensions → Apps Script. Near the top of the code, the SECRET_KEY value is your secret key.
3. In the Apps Script editor, click Deploy → Manage deployments and copy the Web app URL.
4. Paste both into the boxes at the top of this page and click Connect.
For Family Members: Just enter the family secret key above and click "Connect"! (Leave the web app URL field as it is.)
For Initial Setup (One-time only):
Step 1: Create a new Google Sheet with two sheets:
Sheet 1: "Travels" (for pin data)
Sheet 2: "Config" (for family member names)
Step 2: In the Config sheet, add family member names in column A (starting at A1)
Step 3: Go to Extensions → Apps Script in your sheet
Step 4: Replace the default code with this:
Step 5: Change the SECRET_KEY value ("change-this-to-a-long-random-passphrase") to a passphrase of your own. Treat it like a password.
Step 6: Click Deploy → New deployment. Next to "Select type," click the gear icon and choose Web app.
Step 7: Set "Execute as" to Me and "Who has access" to Anyone, then click Deploy and authorize when prompted. ("Anyone" only lets family members' browsers reach the script without signing in to Google — your Sheet and this code stay private; the secret key is what gates the data.)
Step 8: Copy the web app URL, paste it into the "Apps Script web app URL" box at the top of this page, enter your secret key, and click "Connect." No code editing needed — your browser remembers the URL.
Important: Share the secret key with family or friends privately. Anyone who has it can view and overwrite all your travel data.