ENQUIRIES
TOTAL ENQUIRIES
—
All time submissions
NEW (UNREAD)
—
Awaiting response
REPLIED
—
Responded to
URGENT
—
Needs immediate action
MEMBERS
TOTAL MEMBERS
—
All registrations
PENDING VERIFICATION
—
Awaiting payment check
ACTIVE MEMBERS
—
Verified & active
INSTITUTIONS
—
Org memberships
Recent Enquiries
Last 5 submissions
| NAME | SUBJECT | CITY | DATE | STATUS | ACTIONS |
|---|---|---|---|---|---|
| Loading… | |||||
Recent Member Registrations
Last 5 submissions
| NAME | CATEGORY | PLAN | AMOUNT | DATE | STATUS | ACTIONS |
|---|---|---|---|---|---|---|
| Loading… | ||||||
All Enquiries
—
| # | NAME / EMAIL | PHONE | SUBJECT | MESSAGE | CITY | DATE | STATUS | ACTIONS |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Showing 0 entries
All Members
—
| # | NAME / EMAIL | PHONE | CATEGORY | PLAN | AMOUNT | TRANSACTION REF | PAYMENT DATE | STATUS | ACTIONS |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
Showing 0 entries
Connection Status
Live status of both Google Sheet data feeds.
Not configured — EnquiriesPaste CSV URL below.
Not configured — MembersPaste Members CSV URL below.
Setup Guide
Two Apps Scripts — one for Contact/Enquiries, one for Membership registrations.
1
Enquiry form already set up — paste its Enquiries sheet CSV URL in Config below.
2
Membership Script: Open script.google.com → New Project → paste
membership-script.gs → run setupMembersSheet() once. Then Deploy → Web App → Anyone → copy URL → paste into membership.html as MEMBERSHIP_SCRIPT_URL.3
Members CSV URL: In your Google Sheet, go to the Members tab → use:
Get the GID from the tab URL (number after
https://docs.google.com/spreadsheets/d/SHEET_ID/export?format=csv&gid=MEMBERS_GIDGet the GID from the tab URL (number after
#gid=). Paste in Config below.4
WhatsApp alerts (optional): WhatsApp +34 644 60 24 91:
I allow callmebot to send me messages → paste API key into WA_APIKEY in both scripts → redeploy.Dashboard Configuration
Saved locally in your browser.
Members Sheet — Column Mapping
membership-script.gs writes these columns in order. The admin reads by column index, so exact header names don't matter.
| COL | FIELD | SOURCE |
|---|---|---|
| A | Timestamp | Auto-generated (IST) |
| B | Name | Membership form |
| C | Membership form | |
| D | Phone | Membership form |
| E | City / Location | Membership form |
| F | Category | Individual / Institution |
| G | Plan | Annual / Lifetime |
| H | Amount (INR) | Numeric value (e.g. 500) |
| I | Transaction Ref | UTR / UPI reference |
| J | Payment Date | Date entered by member |
| K | Notes | Optional notes |
| L | Status | Set to "Pending Verification" |