One AIESEC in Belgium

Welcome back

MCP / MCVP → full entity & full allocation
LCP / LCVP → own LC allocation
TL → see & manage own team's leads
Member → own assigned leads + CRM

⚙ Backend / database config

Apps Script URL (enables shared CRM for all members)

📧 Add email alerts to your Apps Script (click to expand)

// ── Paste this inside your doPost(e) function in Apps Script ──
// Place it BEFORE the final return statement

if (data.action === 'sendAlert') {
  try {
    var to      = data.to      || '';
    var cc      = data.cc      || '';
    var subject = data.subject || '[CRM Alert]';
    var body    = data.body    || '';

    if (!to && !cc) return ContentService
      .createTextOutput(JSON.stringify({ok:false,error:'No recipients'}))
      .setMimeType(ContentService.MimeType.JSON);

    // Primary recipient = assigned member; CC = LCP + LCVP + VPs
    MailApp.sendEmail({
      to:      to,
      cc:      cc,
      subject: subject,
      htmlBody: body,
      name:    'AIESEC Belgium CRM',
      replyTo: 'no-reply@aiesec.net'
    });

    return ContentService
      .createTextOutput(JSON.stringify({ok:true,sent:true}))
      .setMimeType(ContentService.MimeType.JSON);

  } catch(err) {
    return ContentService
      .createTextOutput(JSON.stringify({ok:false,error:err.message}))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

Paste this block inside your doPost(e) function, then re-deploy the script as a new version. The CRM will automatically email the assigned member + CC LCP, LCVP, and VPs when a lead goes critical.

oGX Funnel

Feb 2025 →

Status Mix

Programs

LC Performance

Top Contributors

Score

🏆 oGX Best LC Competition

Live rankings · Points drive from EXPA status updates via Google Sheet

Score: Open=1 · Applicant=4 · Accepted=4 · Approved=5 · Realized=8 · Finished=10 · Completed=12

🥇 Top Members Podium

LC Score Race

LC Performance Breakdown

LC	Members	SUs	Contacted	Applicants	Approved	Realized	Completed	Conv. Rate	Score	Pts/SU

Pipeline Progress by LC

Funnel stages — how far each LC's SUs have progressed

Full Member Leaderboard

Leads — GIS People —

—

GIS ID	Name	Assigned To	Email	Phone	DOB	Signed Up	Apps	Home LC	Programs	GIS Status ↕	CRM Phase ↕	Referral

—

My Leads to Work —

🔄

Re-contact List

Leads marked as "Withdraw / Not Interested" — try re-approaching them. Reassign and update their tracking phase.

Withdrawn Leads — Re-approach Pipeline —

Unassigned Leads 0

Team Structure

Member	LC	Role	Team Leader	Assigned Leads	Actions

Member	LC	Role	TL	Leads	Contacted	Approved	Score

LC	Members	Leads	Contacted	Approved	Realized	Completed	Conv %

Welcome back

Signing you in…

Set / Reset Password

🏆 oGX Best LC Competition