Live Properties (0)
To edit or delete a property: click Open Sheet → and edit the row directly. Changes appear on website within 60 seconds.
Form Submissions (0)
All form submissions from the website appear here (requirement, NRI, contact, inquiry). Also stored in your Google Sheet → Leads tab.
⚙️ Apps Script URL
This URL connects the admin panel to your Google Sheet. Without it, Save Property will not work.
How to get this URL:
1. Open your Google Sheet → Extensions → Apps Script
2. Delete all → paste Code.gs → Save (Ctrl+S)
3. Run → testSetup → Authorize when asked → check sheet for "Test" tab
4. Deploy → New Deployment → Web App → Execute as: Me → Access: Anyone → Deploy → Authorize
5. If "App not verified" appears: Advanced → Go to project (unsafe) → Allow
6. Copy the URL ending in /exec → paste below
How to get this URL:
1. Open your Google Sheet → Extensions → Apps Script
2. Delete all → paste Code.gs → Save (Ctrl+S)
3. Run → testSetup → Authorize when asked → check sheet for "Test" tab
4. Deploy → New Deployment → Web App → Execute as: Me → Access: Anyone → Deploy → Authorize
5. If "App not verified" appears: Advanced → Go to project (unsafe) → Allow
6. Copy the URL ending in /exec → paste below
📋 Google Sheet Tabs
📊 Properties → all properties (add here via admin, or edit directly in sheet)
📥 Submissions → "List Your Property" from website visitors
📋 Leads → all form submissions (requirement, NRI, contact, inquiry)
📋 Requirements → "Post Requirement" form
📋 NRI Requests → NRI consultation form
📋 Contact → Contact page form
📋 Inquiries → Property detail page inquiry
🔑 Change Password