📢

Live Experiential Learning

Your workspace is ready.

Showing content for your enrolled programs.

Next Sessions

Upcoming Schedule

View all →

Continue Watching

Latest Recordings

Library →

Your Enrollment

My Enrolled Programs

All your active Skilled Sapiens programs, content counts and progress at a glance.

Recording Library

Session Recordings

All mentor session recordings from your enrolled programs.

Self-Paced Learning

Your Self-Paced Cohorts

Pre-recorded sessions and PDF resources for your self-paced cohorts. Learn at your own pace.

No self-paced cohorts assigned yet.

Live Calendar

Upcoming Sessions

All upcoming classes, workshops and mentor sessions from your enrolled programs. Click the Meet link to join.

May — June 2026

Study Materials

Templates, Briefs & Downloads

Curated compendiums, templates, briefs and support files relevant to your enrolled programs.

Student Help Desk

Support & Guidelines

Portal guidance, live program FAQs, query submission and live project support documents in one place.

Portal Guide

Use the LMS as your Skilled Sapiens workspace.

Start from Dashboard for the latest activity, then move between classes, recordings, resources and live project support as your program progresses.

Daily Navigation

Check Dashboard for upcoming sessions and recent recordings.
Use Schedule to join live classes and mentor sessions at the listed time.
Use Recordings after a session is marked completed.
Use Resources for templates, guidebooks and downloadable files.
Use Live Project Hub for briefs, deliverables and submission links.

Best Practices

Join live sessions with the same email used for portal access.
Download project templates before starting your assignment.
Keep your cohort name and program track handy while raising queries.
Submit project work only through the links shown in the portal.

Live Program FAQs

Refer to the official FAQ document for common questions on session flow, recordings, resources, project submissions and program expectations.

Open FAQ Document →

Use this document first for standard live program questions. If your issue is student-specific, raise a query from the next tab.

Raise a Student Query

Use the query form for access issues, missing resources, recording concerns, schedule clarifications, project doubts or cohort-specific support.

Mention your full name, registered email, cohort and program.
Describe the issue clearly and include links or screenshots where relevant.
For urgent live-session access issues, submit the form before the session starts.

Submit Query Form →

Live Project Support Data

Use the support document for live project instructions, reference data, support notes and project-specific clarifications shared by the Skilled Sapiens team.

Open Support Document →

For submission links and deadlines, continue to rely on the Live Project Hub page because it is tied to your enrolled program.

Live Project Hub

Your Active Projects

Project briefs, key tasks, support documents, deliverables and submission links in one place per Skilled Sapiens program.

Verified Achievements

My Certificates

Verify your issued certificates and download temporary PDF copies when available.

Administration

Skilled Sapiens Admin Panel

Overview, cohort management, student roster and Google Sheets integration guide.

👥

Total Students

🏫

Cohorts

🎬

Recordings

⏳

Pending Recording Links

📅

Upcoming Sessions

🟢

Active Last 1 Hour

Sheet Status

Live Data Summary

Operations

System Health

Audit

Recent Admin Actions

Errors

Recent Issues

Audit Trail

Admin Activity

🔍

🔒

Verified admin audit log
Rows are read from Supabase audit_logs after validating the current Supabase admin session.

Open Analytics to load current metrics.

Programs

Program Performance

Load analytics to view program performance.

Operations

Operational Health

Load analytics to view operational health.

Cohorts

Cohort Breakdown

Load analytics to view cohort performance.

Enrollment Queue

Admin Review System

🔍

Webhook Logs

Razorpay Webhook Audit Trail

🔍

S. No.	Dual	Full Name	College	Email ID	Alt Email	Phone	Cohorts	Slot	Live Project Domain(s)	WA Group	Onboarding Date	Programs	Status	Actions

Zoom Integration

Schedule a New Meeting

Session Title *

Date *

Time (IST) *

Duration (minutes)

Zoom Account *

Tag to Cohorts *

🔍

Loading cohorts…

Select one or more cohorts — this session will appear in each cohort's schedule.

Agenda / Notes

Workshop Pipeline

All Sessions

Attach Recording

Only workshops explicitly marked Completed appear here. Add or edit at least one recording link.

Resources

Resource Library

🔍

Editor

Add Resource

Resource ID *

Status

Title *

Resource Type

Resource Mode

Program Key Auto-populated from selected active/upcoming cohorts.

domain_key

Share With (Cohorts)

Loading cohorts…

Select one or more active/upcoming cohorts. Program Key and domain_key update automatically.

Access Type

Currency

Price

Payment Link

GoogleDriveLink *

Description

Created At

Updated At

Master Data

Project Roles

Projects

Live Project Library

🔍

Editor

Add Project

Project ID *

Status

Project Title *

Live Company Name

Project Role *

Programs *

Select one or more programs. The first selected program is stored as primary program_key.

Program Name

Brief

Objectives

Action Items

Deliverables

Resources

Deadline

Created At

Updated At

Submission Management

Project Submission Requests

Issuance

Leadership Certificates

Configuration

Leadership Modules

Review Queue

Live Project Certificate Requests

Registry

Issued Certificates

Student Portal

Feature Visibility Controls

👁️

Controls apply to student-facing modules only.
Visible modules work normally, Coming Soon modules stay listed but show a message, and Hidden modules are removed from the student sidebar.

Email Center

Send Student Communication

Email Phase *

Template *

Send To

Subject *

Message Body * Templates are managed below and saved to the shared Supabase database.

Bulk onboarding: sends the next Pending students in a controlled batch. Respects dry-run and campaign limit.

Preview

Email Summary

Select a template and recipients to preview this message.

Saved Templates

Email Templates

No templates loaded yet.

Admin Ops Status

Monitor recent Supabase exports, controlled imports, failures, and operational timestamps without opening Apps Script logs.

Ops status has not been loaded.

Performance Health

Performance samples have not been loaded.

No performance samples loaded.

Recent Imports

No import history loaded.

Recent Exports

No export history loaded.

Supabase Operations Export

Create reporting snapshots from Supabase in dedicated Export_* tabs. Operational and bulk-import tabs are never overwritten.

Export status has not been loaded.

Controlled Operations Import

Manually UPSERT approved bulk changes from dedicated Import_* sheets into Supabase. Imports never read from Export_* tabs and never delete records.

Import Module

Initialize the import sheets, add approved rows, then validate and preview before importing.

Community Payments

Razorpay orders and paid entitlements are verified by Apps Script and stored in Supabase. Keys remain server-side.

Recent Payment Orders

Manual Access Grant

Active Paid Access

📋 Sheet: Recordings

TABRecordings

Column	Type	Required	Example
title	string	✓	Workshop title
program_type	program dropdown	✓	Management Consulting Leadership Program
program_key	mclp/smlp/...	Optional	mclp
topic	string	✓	fin
date	YYYY-MM-DD	✓	2026-05-08
YouTube Video URL	URL	✓	https://youtube.com/...
duration	string	Optional	1h 45m

📅 Sheet: Schedule

TABSchedule

Column	Type	Required
session	string	✓
program_type	program dropdown	✓
program_key	mclp/smlp/...	Optional
date	YYYY-MM-DD	✓
time	HH:MM IST	✓
meet_link	URL	✓
duration_mins	number	Optional

📁 Sheet: Resources

TABResources

Column	Type	Required
title	string	✓
program_type	program dropdown	Optional
material_type	resource dropdown	✓
category	template/general/…	Optional
file_link	URL	✓
file_type	pdf/xlsx/pptx/doc	✓

👥 Sheet: Students

TABStudents

Column	Type	Required
name	string	✓
email	email	✓
cohort	string	✓
domains	legacy only	Optional
programs	mclp,flp_er,live_qf	✓
enrolled_date	YYYY-MM-DD	Optional

📊 Sheet: Progress

TABProgress

Column	Type	Required
student_email	email	✓
module_name	string	✓
pct_complete	number 0–100	✓
program_key	mclp/flp_er/...	✓

🚀 Sheet: Projects

TABProjects

Column	Type	Required
program_keys	mclp,flp_er,live_qf,...	✓
program_name	string	Optional
project_id	unique id	Optional
project_title	string	✓
role_id	active role_master id	✓
brief	problem statement	✓
objectives	line-separated text	Optional
action_items	line-separated text	✓
deliverables	line-separated text	✓
resources	Title\|URL\|type\|note	Optional
deadline	YYYY-MM-DD	✓
status	active/inactive	Optional

⚙️ Apps Script — Single Bundle Fetch

doGet(e) — returns full student data bundle in one call

// Google Apps Script — deploy as Web App → Anyone function doGet(e) { const email = e.parameter.email; const ss = SpreadsheetApp.openById('YOUR_SHEET_ID'); // 1. Authenticate: find student row const student = findStudent(ss, email); if (!student) return json({ error: 'not_found' }); // 2. Get enrolled domains/programs e.g. ['cep','live'] and ['mclp','flp_er'] const domains = student.domains.split(',').map(d => d.trim()); const programs = student.programs.split(',').map(p => p.trim()); // 3. Build one bundle — filter all sheets by domains const bundle = { student, recordings : getSheet(ss,'Recordings').filter(r => domains.includes(r.domain)), schedule : getSheet(ss,'Schedule').filter(s => domains.includes(s.domain)), resources : getSheet(ss,'Resources').filter(r => domains.includes(r.domain)), progress : getSheet(ss,'Progress').filter(p => p.student_email === email), projects : getSheet(ss,'Projects').filter(p => programs.includes(p.program_key) && p.status !== 'inactive'), }; // 4. Return everything — 1 API call total per login return json(bundle); } function json(data) { return ContentService .createTextOutput(JSON.stringify(data)) .setMimeType(ContentService.MimeType.JSON); }

💡 Integration Tips

💾

Cache in sessionStorage: Store the bundle on login. Zero further API calls during the session. Students can browse all pages freely.

🔒

Domain filtering: The domains column in Students sheet controls everything. Change it → student's view changes next login.

📱

CORS: Apps Script doGet naturally supports CORS when deployed as Web App → Anyone. No extra headers needed.

🚀

Zero write calls: Students only read. All updates (progress, resources) made directly in Sheets by admin. No concurrent write risk.

Notification Centre

Send Notification

Notification Type

📢

General

All students

🚨

Alert

Urgent update

📅

Session

Class reminder

📁

Resource

New material

🚀

Project

Project update

✏️

Custom

Your own emoji

Send To

Target preview: all active students

Priority

Status

Start Date

End Date

Title *

Message *

📌 Pin this notification (shows at top)

Preview

How it looks

Fill in the form to see a preview.

History

Sent Announcements

No notifications sent yet.

Updates & Alerts

Announcements

Stay up to date with session reminders, new resources, and announcements from your team.

Community

Community Hub

Groups, admin-led posts and controlled comments for students.

Controlled Community

Groups first. Posts inside groups.

Students can open eligible groups, unlock paid groups later, and comment only where admin allows it.

🏛️

Browse Groups

Live learning.Real growth.

Welcome back

Your workspace is ready.

Upcoming Schedule

Latest Recordings

My Enrolled Programs

Session Recordings

Your Self-Paced Cohorts

Upcoming Sessions

Templates, Briefs & Downloads

Support & Guidelines

Use the LMS as your Skilled Sapiens workspace.

Daily Navigation

Best Practices

Live Program FAQs

Raise a Student Query

Live Project Support Data

Your Active Projects

My Certificates

Skilled Sapiens Admin Panel

Live Data Summary

System Health

Recent Admin Actions

Recent Issues

Admin Activity

Program Performance

Operational Health

Cohort Breakdown

Admin Review System

Razorpay Webhook Audit Trail

Schedule a New Meeting

✅ Zoom Meeting Scheduled

All Sessions

Resource Library

Add Resource

Project Roles

Live Project Library

Add Project

Project Submission Requests

Leadership Certificates

Leadership Modules

Live Project Certificate Requests

Issued Certificates

Feature Visibility Controls

Send Student Communication

Email Summary

Email Templates

Admin Ops Status

Performance Health

Recent Imports

Recent Exports

Supabase Operations Export

Controlled Operations Import

Community Payments

Recent Payment Orders

Manual Access Grant

Active Paid Access

📋 Sheet: Recordings

📅 Sheet: Schedule

📁 Sheet: Resources

👥 Sheet: Students

📊 Sheet: Progress

🚀 Sheet: Projects

⚙️ Apps Script — Single Bundle Fetch

doGet(e) — returns full student data bundle in one call

💡 Integration Tips

Send Notification

How it looks

Sent Announcements

Announcements

Community Hub

Groups first. Posts inside groups.

Available Groups

Add Email Template

Session Title

Submit Project Report

Add New Cohort

📹 Recording Sessions

📄 PDF Resources

Enroll New Student

Live learning.
Real growth.