Blog automation,
made simple.

📋 코드 복사 function doPost(e) { try { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var payload = JSON.parse(e.parameter.payload || '{}'); // 시트가 비어있으면 헤더 자동 추가 if (sheet.getLastRow() === 0) { sheet.appendRow([ '가입일시', '이메일', '전화번호', '유입경로', '관심사항', '동의', '마지막로그인', '비고' ]); sheet.getRange(1, 1, 1, 8) .setBackground('#CC785C').setFontColor('#FFFFFF').setFontWeight('bold'); sheet.setFrozenRows(1); } var users = payload.type === 'sync_all' ? (payload.users || []) : [payload.user]; users.forEach(function(u) { sheet.appendRow([ u.createdAt || new Date().toISOString(), u.email || '', u.phone || '', u.source || '', (u.interests || []).join(', '), u.consent ? 'O' : 'X', u.lastLogin || '', payload.type === 'signup' ? '신규가입' : '동기화' ]); }); return ContentService .createTextOutput(JSON.stringify({ok: true, count: users.length})) .setMimeType(ContentService.MimeType.JSON); } catch (err) { return ContentService .createTextOutput(JSON.stringify({ok: false, error: err.toString()})) .setMimeType(ContentService.MimeType.JSON); } }