แยกไฟล์ใน Google Drive อัตโนมัติ จากชื่อไฟล์ ด้วย ChatGPT + Apps Script

/**
* Google Apps Script: แยกไฟล์อัตโนมัติจาก “ชื่อไฟล์” ไปยังโฟลเดอร์ย่อย
* รองรับกฎ: PREFIX_UNDERSCORE, BRACKET_TAG, REGEX_MAP
* มี Dry-Run, Log ลงชีต และ Undo ได้ด้วย runId
*/

const CONFIG = {
SOURCE_FOLDER_ID: ‘PUT_SOURCE_FOLDER_ID_HERE’,
DESTINATION_ROOT_ID: ”, // เว้นว่าง = สร้างโฟลเดอร์ย่อยใน SOURCE
LOG_SHEET_ID: ”, // ใส่ Google Sheet ID ถ้าต้องการบันทึก Log
RULE: ‘PREFIX_UNDERSCORE’, // ‘PREFIX_UNDERSCORE’ | ‘BRACKET_TAG’ | ‘REGEX_MAP’
PREFIX_SEPARATOR: ‘_’,
REGEX_MAP: [
{ pattern: ‘^INV’, target: ‘ใบแจ้งหนี้’ },
{ pattern: ‘^Q[UO]T’, target: ‘ใบเสนอราคา’ },
{ pattern: ‘^IMG|^PHOTO’, target: ‘ภาพ’ },
{ pattern: ‘REPORT|SUMMARY’, target: ‘รายงาน’ },
],
DRY_RUN: false,
SKIP_GOOGLE_FILES: false,
MAX_PER_RUN: 500
};

function separateFilesByName() { coreSeparate_(false); }
function previewSeparation() { coreSeparate_(true); }

function undoRun() {
const runId = Browser.inputBox(‘ใส่ runId ที่ต้องการย้อนกลับ:’);
if (!runId || runId === ‘cancel’) return;
coreUndo_(runId);
}

function coreSeparate_(forceDryRun) {
const runId = new Date().toISOString();
const dryRun = forceDryRun ? true : !!CONFIG.DRY_RUN;

const src = DriveApp.getFolderById(CONFIG.SOURCE_FOLDER_ID);
const root = CONFIG.DESTINATION_ROOT_ID ? DriveApp.getFolderById(CONFIG.DESTINATION_ROOT_ID) : src;

const folderCache = {};
const files = src.getFiles();
let processed = 0;

const sheet = getLogSheet_();
if (sheet && sheet.getLastRow() === 0) {
sheet.appendRow([‘timestamp’,’runId’,’fileId’,’fileName’,’fromFolderId’,’fromFolderName’,’toFolderId’,’toFolderName’,’category’,’action’,’dryRun’]);
}

while (files.hasNext()) {
const file = files.next();
if (CONFIG.SKIP_GOOGLE_FILES && String(file.getMimeType()).startsWith(‘application/vnd.google-apps’)) continue;

const baseName = file.getName();
const category = extractCategory_(baseName);
const safeCategory = sanitizeFolderName_(category || ‘Uncategorized’);
const toFolder = getOrCreateFolder_(root, safeCategory, folderCache);

const action = dryRun ? ‘SIMULATED’ : ‘MOVED’;
if (!dryRun) {
try { file.moveTo(toFolder); }
catch (e) { logRow_(sheet, runId, file, src, toFolder, safeCategory, ‘ERROR:’ + e.message, dryRun); continue; }
}

logRow_(sheet, runId, file, src, toFolder, safeCategory, action, dryRun);
processed++;
if (processed >= CONFIG.MAX_PER_RUN) break;
}

Logger.log(‘RunId: %s | Processed: %s | DryRun: %s’, runId, processed, dryRun);
}

function coreUndo_(runId) {
const sheet = getLogSheet_();
if (!sheet) { Browser.msgBox(‘ยังไม่ได้ตั้งค่า LOG_SHEET_ID จึง Undo ไม่ได้’); return; }

const data = sheet.getDataRange().getValues();
const header = data.shift();
const map = Object.fromEntries(header.map((h,i)=>[h,i]));
let undone = 0;

data.forEach((row, idx) => {
if (row[map[‘runId’]] !== runId || row[map[‘action’]] !== ‘MOVED’) return;
try {
const file = DriveApp.getFileById(row[map[‘fileId’]]);
const fromFolder = DriveApp.getFolderById(row[map[‘fromFolderId’]]);
file.moveTo(fromFolder);
sheet.getRange(idx+2, map[‘action’]+1).setValue(‘UNDONE’);
undone++;
} catch (e) {
sheet.getRange(idx+2, map[‘action’]+1).setValue(‘UNDO_ERROR:’+e.message);
}
});

Browser.msgBox(‘ย้อนกลับสำเร็จ: ‘ + undone + ‘ ไฟล์ สำหรับ runId: ‘ + runId);
}

function extractCategory_(fileName) {
const base = removeExtension_(fileName);

if (CONFIG.RULE === ‘BRACKET_TAG’) {
const m = base.match(/\[([^\]]+)\]/);
if (m) return m[1].trim();
}

if (CONFIG.RULE === ‘REGEX_MAP’) {
for (const rule of CONFIG.REGEX_MAP) {
const re = new RegExp(rule.pattern, ‘i’);
if (re.test(base)) return rule.target;
}
}

const sep = CONFIG.PREFIX_SEPARATOR || ‘_’;
if (base.includes(sep)) return base.split(sep)[0].trim();
if (base.includes(‘-‘)) return base.split(‘-‘)[0].trim();
const m2 = base.match(/^(\d{2,})/);
if (m2) return m2[1];
return ‘Uncategorized’;
}

function removeExtension_(name) {
const i = name.lastIndexOf(‘.’);
return i > 0 ? name.slice(0, i) : name;
}

function sanitizeFolderName_(name) {
return String(name).replace(/[\\/:*?”<>|#]+/g, ‘ ‘).trim().slice(0,128) || ‘Uncategorized’;
}

function getOrCreateFolder_(parent, name, cache) {
if (cache[name]) return cache[name];
const it = parent.getFoldersByName(name);
const folder = it.hasNext() ? it.next() : parent.createFolder(name);
cache[name] = folder;
return folder;
}

function getLogSheet_() {
if (!CONFIG.LOG_SHEET_ID) return null;
try { return SpreadsheetApp.openById(CONFIG.LOG_SHEET_ID).getSheets()[0]; }
catch (e) { Logger.log(‘เปิดชีตไม่สำเร็จ: ‘ + e.message); return null; }
}

function logRow_(sheet, runId, file, fromFolder, toFolder, category, action, dryRun) {
if (!sheet) return;
sheet.appendRow([new Date(), runId, file.getId(), file.getName(), fromFolder.getId(), fromFolder.getName(), toFolder.getId(), toFolder.getName(), category, action, dryRun]);
}