Welcome back

Sign in with your credentials

Setup incomplete: Apps Script URL not configured in the file.
Forgot Password?

No account? Contact your Admin.

EduJunior CRM
0
Total Staff
0
Present Today
0
On Leave
0
Competitions

📞 Calling Stats

0
Interested
0
Not Interested
0
No Answer
0
Total Called

📚 Classes & Fees (This Month)

0
Total Classes
0
Completed
₹0
Fees Received
₹0
Fees Pending
₹0
Teacher Payout Pending (All Time)

💰 Stipend (This Month)

₹0
Stipend Paid
₹0
Stipend Pending
₹0
Total Paid (All Time)

Today's Attendance

Loading...

Mark Today's Attendance

Monthly Calendar

0
Emails Sent
0
Leaves
0
Absent
0%
Attendance

Today —

This Month Summary

InternSentLeavesAbsentAttendance %

All Interns 0

NameEmailSheets
DateInternSchoolUpdated PhoneUpdated EmailUpdated PrincipalNotes
0
Paid Days
₹0
Per Day
₹0
This Month

Payment Details

Add your UPI ID so Admin can pay your stipend

Day-by-Day Breakdown

Payment History

What you've been paid, month by month.

Billing Mode

"Per Day" pays exactly days × rate, every month. "Per Day + Monthly Cap" still counts per day the same way, but caps the total so it never crosses the limit you set — useful so a 31-day month doesn't pay more than a 30-day one.

Default Per Day Amount

Default daily stipend for all interns. You can override per-intern in the table below. Sundays are auto-counted as paid (holiday).

per day

Monthly History

Total stipend paid out, month by month — across all interns.

Intern Payments —

InternPaid DaysRate/dayAmount DueUPI IDPayStatus

Server Connection

WhatsApp Notifications (Meta API)

Stipend paid hone par staff ko, aur fee paid hone par parent ko auto WhatsApp jaata hai. Apna Meta access token + phone number ID daalein. Templates: stipend aur fees banayein jisme {{1}}=naam, {{2}}=amount ho.

Email (SMTP) — for form confirmation emails

Confirmation emails reliably bhejne ke liye, pehle Hostinger hPanel → Emails mein ek account banao (e.g. noreply@edujr.com), phir uski details yahan daalo. Hostinger SMTP host usually smtp.hostinger.com, port 465.

📮 Parcel "From" Address — shown on every label

This appears as the sender on every parcel label you print.

🤖 Gemini AI Key — for parcel photo scanning

Get a free API key at aistudio.google.com/apikey. Used for AI-powered parcel scan (auto-detect Name, School, Tracking ID from photo).

Import Email Data (CSV)

Upload a CSV file of email data. First row = column headers. This becomes a "sheet" you can assign to interns.

Existing Sheets

My Profile

?

Add Subject

All Subjects

Date & TimeStudentContactSubject TeacherPaymentStatusActions
Loading…
Kaise kaam karta hai: Har day ke liye time windows add karo (e.g. Monday 16:00–20:00). Iske andar ke 30-minute slots students ke demo booking form pe available dikhenge. Aap us window me nahi ho to koi book nahi kar sakega.

Razorpay Keys

Enter your Razorpay keys to enable online payments for students

WordPress Registration Sync

Lets edujr.com automatically push new competition registrations into All Submissions. Paste this key into the plugin's "CRM Sync" settings on edujr.com — it's the shared password that lets that site talk to this one.

Student Fees —

StudentSubjectMonthly FeeStatusAction

Teacher Payouts —

TeacherDonePer ClassTotalUPIPayStatus
0
Total Classes
0
Completed
0
Upcoming
Subject

Join Your Class

Next Classes

0
Total Classes
0
Completed
0
Upcoming
₹0
This Month

My Subjects

Next Classes

0
Total Reviews
Avg Rating
0
5-Star Reviews
0
Total Reviews
Avg Rating
0
5-Star Reviews
0
Low Ratings (≤2)
Select a contact from the left

Writers

All Tasks

0
Total Tasks
0
Completed
0
Pending

Google Sheet Write-Back — so CRM updates the sheet's dropdown

Deploy the "Calling Sheet Sync" Apps Script as a Web App (Deploy → New deployment → Web app → Execute as Me → Anyone), then paste the /exec URL here. When a telecaller picks a Response in the CRM, that cell updates live in your Google Sheet.

Add Call Lists

Recommended: Keep your calling data in one Google Sheet (one tab per competition + a Parcel Tracking tab) and use the "Calling Sheet Sync" Apps Script — it auto-fetches every tab into the CRM in one click, no manual upload needed. Re-sync anytime; telecaller responses are never lost.

Or upload a one-off CSV below. "Response" and "Remark" are tracked separately, so re-syncing won't overwrite them.

Telecallers

Call Data — view a caller's progress

0
Total Leads
0
Called
0
Pending
0
Interested
0
Not Interested

🏢 Organizer Name

Shown in body text (red bold) on every certificate.

🖼️ Certificate Background Template (required)

Upload your blank Canva certificate (with corners, watermark, "FROM", "DATE" / "PROGRAM MANAGER" labels — but no recipient details). A4 landscape PNG/JPG recommended (3508×2480 px).

✍️ Signature Image (optional — falls back to cursive font)

Upload Pradeep's signature image. Black background OK — code automatically removes it using blend mode. PNG/JPG (transparent or solid black bg both work).

💡 Quick Setup Guide:
  1. In Canva, open your certificate design and delete only the name, school, body text, date value, and signature — keep everything else
  2. Export as PNG (A4 landscape, high quality)
  3. Upload it above as Background Template
  4. Upload signature image (any background — code handles it)
  5. Go to All Submissions → click any "🏆 Cert" button → preview

🔤 Custom Fonts (upload TTF, OTF, WOFF, WOFF2)

Any font you upload here becomes available in the Typography dropdowns below. Ibarra Real Nova, Montserrat, Tangerine, Unna, League Spartan, Sacramento, and Amsterdam Four are already available via Google Fonts.

🎨 Typography (font, size, color per element)

Configure the fonts used for each part of the certificate. These apply to Winner, Runner-Up, and Participation certificates alike. Values save when you click Save Typography below.

📋 Template Details:
  • Template name: edujunior_marketing (Meta approved)
  • Variable: {{1}} = Recipient Name (auto-filled)
  • Button: Static "Visit Website" (no dynamic URL)
  • Tier 1 limit: 1,000 messages / day
  • Rate: 1 message per 0.5 sec (safe pacing)

1. Choose Recipients

📋 Info:
  • SMTP: smtp.hostinger.com:465 (default)
  • Each email ID can send 100 emails/day as per Hostinger limit
  • Recommended: 5 IDs per intern (total 500/day capacity)
  • Passwords encrypted (AES-256) before storage
💡 Why this matters: Every hard bounce and spam complaint lowers your domain reputation with Gmail/Outlook. Run a Health Check on high-bounce interns' lists and remove the flagged addresses — invalid, dead domains, typos, and previously-bounced emails — before the next campaign goes out.
🌡️ How Warmup Works:
New email IDs sending 100+ emails on day 1 get flagged as spam. Warmup gradually increases limits over 7 days:
Day 1: 10 emails  ·  Day 2: 20  ·  Day 3: 40  ·  Day 4: 60  ·  Day 5: 80  ·  Day 6: 90  ·  Day 7+: Full limit
Send actual emails daily during warmup — empty inboxes hurt reputation.
🎯 How it works:
  1. Select an email ID to send from (each can send 100/day)
  2. Copy data from Google Sheets (with headers like School / Principal / Email)
  3. Paste below → click "Parse"
  4. Write your email (use {{Principal}}, {{School}} for personalization)
  5. Send → wait → switch to next email ID → next 100 → repeat

📧 Step 1: Send From

Loading email IDs...

📋 Step 2: Paste Recipients

Copy cells from Google Sheets (include header row) and paste into the spreadsheet below (Ctrl+V / Cmd+V on the box). Email column is auto-detected.

✍️ Step 3: Compose Email

📋 Info:
  • WhatsApp template: online_certificate (Meta approved · 4 vars: Name, Competition, School, Cert Link)
  • Email: Branded HTML with download button
  • Cert Link: Auto-generated from each entry (Position = "Participation")
  • ⚠️ Only for participatories — winners get separate certs

1. Choose Recipients

📋 Info:
  • WhatsApp template: parent_parcel_tracking (Meta approved · 4 vars: Name, Competition, Track Link, Email)
  • Email: Branded HTML with green "Track Your Parcel" button
  • Tracking link auto-generated from Speed Post tracking ID (saved in Parcels module)
  • Source: Sent Parcels DB — all parcels with tracking ID

1. Choose Recipients

Recipients List

Manually add OR upload sheet/CSV with headers: Contact Person Name, School Name, Address, PIN Code, Contact Numbers

0 recipients
0
Total Staff
0
Present Today
0
On Leave
0
Absent

By Role

Today's Attendance

0
Total Assigned
0
On The Way
0
Delivered
0
Received Confirmed
0
Total Interns
0
Pending Tasks
0
Posts to Review
0
Approved Posts

Team

All Tasks

Posts Awaiting Review

0
My Tasks
0
Pending Review
0
Approved
0
Published

Active Tasks

Recent Feedback

0
Drafts
0
Sent
0
Paid
0
Overdue

🏢 Company Details

🖼️ Logo — shown on invoice / receipt PDFs

PNG/JPG/SVG · Max 2MB · Best size 400×200px

🔢 Numbering & Defaults

Format: EJ-2026-001

Format: RCP-2026-001

How it works: Looks for a Merge Status (or Status) column in each assigned sheet and counts EMAIL_SENT / EMAIL_OPENED / EMAIL_CLICKED / EMAIL_REPLIED values automatically written by Mail Merge.
0
Total Sent
0
Opened
0
Clicked
0
Replied
📖 How this works:
  • Add each Hostinger email account (e.g. info@edujr.com) with its password
  • Password is encrypted before saving — only this server can decrypt it
  • Hostinger defaults are pre-filled: IMAP imap.hostinger.com:993 SSL · SMTP smtp.hostinger.com:465 SSL
  • Click Test Connection before saving to verify credentials
  • Once added, mailboxes appear in Mailbox → Inbox

HR Email (SMTP)

Configure the HR official mailbox. All HR emails will be sent from this address. Leave blank to use the system-wide SMTP.