Contact person: Business Client

Phone:Show

Email:Show

Location: Wayanad, India

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Project: Hybrid Micro-Website SaaS + Central Booking Platform

(Google Sheets + Google Apps Script + Central HTML/JS Frontend)

I am looking for a developer/agency to build a multi-tenant SaaS platform with two major components:

1️⃣ Individual Micro-Website Template for SMEs

Small businesses like homestays, resorts, restaurants, cafés, shops, tour operators, etc. should receive a fully functional micro-website generated from a central template.

Key Requirements

ONE central HTML/JS template

Data loads dynamically using URL slug from a Main Domain (eg [login to view URL], [login to view URL],[login to view URL])


Auto-Refresh Weather Widget

Replace static weather with dynamic API:

Shows icons (sunny, rainy, cloudy)

uto-rotate interesting info like:

Nearby attractions

Restaurant tips

Festival events

Local weather

Travel routes

Impact: Useful for tourists and gives dynamic feel.

Each customer gets a dedicated Google Sheet that stores:

Business info

Rooms/menu/items

Prices

Gallery links (Google Drive)

Reviews

Booking entries

A Master Config Sheet maps:
client_slug → sheet_id → api_url → business_type → theme → domain

Customer Website Features

Rooms / menu / items / packages list

Image gallery (Google Drive folder)

About, Contact, WhatsApp, Google Maps

YouTube embed & Social links

Google Reviews embed

Booking/Enquiry form → saves into customer’s Sheet via Apps Script

Customer Admin Panel

Login (Google OAuth or password login)

GUI dashboard with:

Update rooms/menu/items

Update price, offers, descriptions

Manage gallery images

View bookings

All operations must read/write to Google Sheets via APIs

Customers should NOT directly access or edit Sheets

2️⃣ Central Booking Platform ([login to view URL] Style)

A main website where:

All individual businesses are listed automatically

Users can search, filter, and view details

Clicking a property redirects to its micro-website

If a business has no website, the central platform should still provide:

A simplified detail page

A booking form (saving into a Google Sheet)

This central platform acts as both:

A directory of all micro-sites

A backup booking interface

System Flow (End-to-End)
1. Onboarding a New Customer

Admin duplicates the Customer Sheet Template

Admin fills basic details (name, location, theme, business type)

Admin updates the Master Config Sheet with:

client_slug

sheet_id

domain/subdomain

URL becomes live immediately using the central frontend.

Onboarding time: < 5 minutes

2. How a Customer Website Loads

Visitor enters:
[login to view URL] or custom domain

Frontend detects the slug → calls API → fetches sheet data

Website dynamically renders:

Rooms/items

Photos from Google Drive

Reviews

Business info

Booking form submits via Apps Script → writes to Google Sheet

3. How the Admin Panel Works

Customer logs in

Admin Dashboard loads with real-time data from Google Sheets

Customer edits content → API updates Google Sheet

All changes instantly reflect on the website (no redeploy needed)

4. How the Central Booking Platform Works

It reads the Master Config Sheet

Pulls basic data from each client’s Sheet

Generates a global marketplace with:

Property name

Pricing

Location

Photos

Availability (optional)

Booking via:

Redirect to the property’s own site

OR simple central booking form (saved into sheet)

Backend Layer (Google Apps Script APIs)
Required Endpoints:

GET /config?slug=

GET /items?slug=

GET /gallery?slug=

GET /reviews?slug=

POST /booking

POST /enquiry

POST /update (admin panel)

All APIs powered by Google Apps Script (Web App mode).

Architecture Overview

Centralized frontend (single codebase)

Distributed data (one sheet per customer)

Multi-tenant routing via slug/domain

Zero hosting (use Google Sheets, Drive, Apps Script)

Able to scale to 1000+ customer sites

Simple onboarding and minimal operations

Tech Stack

HTML / CSS / JavaScript

Google Apps Script (main backend)

Google Sheets API

Google Drive API

Optional: Cloudflare Worker for URL masking

Deliverables

Central frontend website template

Customer website template powered by Sheets

Admin Panel + Login System

Central Booking Platform

Master Config System

Google Apps Script backend

Sheet templates (Items, Config, Bookings, Gallery…)

Documentation + Setup Guide

Full Source Code & Basic Walkthrough" (client-provided description)