🔐 Secure Login
Masukkan kredensial Anda untuk melanjutkan.
👤 User Management
Hanya Super Administrator yang dapat menambah dan menghapus akun user biasa.
Add New User
| Username | Role | Action |
|---|
1 Upload / Sync Data
2 Configure Settings
3 Generate & Manage
📌 Step 1: Data Source
Auto-Sync dari Google Drive
Masukkan Link Google Apps Script Web App. URL akan disimpan otomatis di browser Anda.
📌 Klik di sini untuk panduan setup Google Apps Script (Multi-Sheet)
- Pastikan di Google Sheets Anda terdapat 4 tab/sheet bernama: Summary (atau sheet utama data), Prospek, Rejected, dan Cannot Send.
- Buka Google Sheets Anda, klik menu Ekstensi (Extensions) > Apps Script.
- Hapus kode yang ada, lalu paste kode ini:
function doGet() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var result = { data: [], prospek: [], rejected: [], cannotSend: [] }; function getSheet(sheetName) { var sheet = ss.getSheetByName(sheetName); if (!sheet) return []; var data = sheet.getDataRange().getValues(); if (data.length < 2) return []; var headers = data[0]; var rows = []; for (var i = 1; i < data.length; i++) { var row = {}; for (var j = 0; j < headers.length; j++) { row[headers[j]] = data[i][j]; } rows.push(row); } return rows; } var sheets = ss.getSheets(); if(sheets.length > 0) result.data = getSheet(sheets[0].getName()); result.prospek = getSheet("Prospek"); result.rejected = getSheet("Rejected"); result.cannotSend = getSheet("Cannot Send"); return ContentService.createTextOutput(JSON.stringify(result)).setMimeType(ContentService.MimeType.JSON); } - Klik tombol Deploy > New deployment.
- Pilih type Web app. Execute as: Me. Who has access: Anyone.
- Klik Deploy, izinkan akses, lalu salin Web app URL.
✅ Google Drive Terhubung. Klik tombol di bawah untuk memuat ulang data terbaru.
--- ATAU UPLOAD MANUAL ---
Expected columns: Area, No, Company Name, PIC Name, Section, Email, Web Site, Company Address, Product
📁
Click to select or drag Excel file here
⚙️ Step 2: Configuration
📋 Scheduling Rules
- Rate: 3 emails per minute (20-second intervals)
- Batch limit: 200 emails per batch, then 2hr 5min gap
- Daily limit: 2400 emails per day
- Working hours: 09:00–11:00 and 13:00–15:00 (recipient local time)
- Sending days: Monday–Friday only
- Same email + different product: 5-day gap
- Display time: Converted to Indonesia time (UTC+7)
- Smart Filter: Email yang sudah masuk ke bucket tidak akan ikut digenerate.
Target Position Categories
Customize Email Content
Subject Email
Introduce & Form 1
Form 3
Type
Subject Email
Introduce & Form 1
Form 3
Type
Subject Email
Introduce & Form 1
Form 3
Type
Subject Email
Introduce & Form 1
Form 3
Type
Subject Email
Introduce & Form 1
Form 3
Type
Subject Email
Introduce & Form 1
Form 3
Type
Scheduling Settings
Area Timezone Mapping (UTC Offset)
✅ Step 3: Results & Bucket Management
Generating summary... Please wait.
🗂️ Buckets
Data yang dipindahkan ke bucket akan dikeluarkan dari hasil utama (Summary).