🧪 POC: Google Sheets Task Tracker

Proof of Concept - Shows it actually works!

📋 Setup Steps:

Create Google Sheet with columns: Task, Week, Date, Completed
Add sample data: Task in column A, 1 in column B, "Nov 4" in column C, FALSE in column D
Share publicly: Share > Anyone with link can view
Get Sheet ID: Copy from URL between /d/ and /edit
For WRITE capability: Deploy the Apps Script (see google-apps-script.js file)

Google Sheet ID: Sheet Name (tab): Apps Script URL (optional - for writes):

Connect to your Google Sheet above, or click "Load Demo" to see how it works

💡 How This Works:
• READ: Uses public Google Sheets API (no auth needed)
• WRITE: Uses Google Apps Script you deploy once
• SYNC: Auto-refreshes every 30 seconds
• CROSS-DEVICE: Emily's phone, Michael's laptop - same data!
• NO SERVER NEEDED: Google Sheets IS your database

🚀 Quick Setup (10 minutes):
1. Open the google-apps-script.js file
2. Follow the instructions at the top to deploy it
3. Paste the Web App URL into "Apps Script URL" above
4. Click "Connect to Sheet" - you now have full read/write!

Demo Mode: Click "Load Demo" to test without any setup