Code.gs

/**
 * SUPERTEAM BRASIL — Submissão de Projetos
 * Google Apps Script Web App: recebe submissões do site,
 * salva os arquivos no Google Drive e loga numa Sheet.
 */

// =================================================================
// CONFIG — substitua pelos seus IDs
// =================================================================

// 1. Crie uma pasta no Drive (ex: "Submissões Superteam BR"),
//    abra ela, e copie o ID da URL:
//    drive.google.com/drive/folders/AQUI_VEM_O_ID
const FOLDER_ID = "PASTE_YOUR_DRIVE_FOLDER_ID";

// 2. Crie uma Google Sheet nova, copie o ID da URL:
//    docs.google.com/spreadsheets/d/AQUI_VEM_O_ID/edit
const SHEET_ID = "PASTE_YOUR_SHEET_ID";

// =================================================================
// MAIN HANDLER
// =================================================================

function doPost(e) {
  try {
    const data = JSON.parse(e.postData.contents);

    const safeName = (data.projectName || "sem-nome")
      .replace(/[^\w\s-]/g, "")
      .replace(/\s+/g, "-")
      .slice(0, 40);

    const timestamp = Utilities.formatDate(
      new Date(),
      "America/Sao_Paulo",
      "yyyy-MM-dd_HH-mm"
    );
    const submissionId = Utilities.getUuid().slice(0, 8);
    const folderName = `${timestamp}_${safeName}_${submissionId}`;

    const parentFolder = DriveApp.getFolderById(FOLDER_ID);
    const submissionFolder = parentFolder.createFolder(folderName);

    const fileLinks = [];
    if (Array.isArray(data.files)) {
      for (const file of data.files) {
        const blob = Utilities.newBlob(
          Utilities.base64Decode(file.base64),
          file.mimeType || "application/octet-stream",
          file.name
        );
        const driveFile = submissionFolder.createFile(blob);
        fileLinks.push(`${file.name}: ${driveFile.getUrl()}`);
      }
    }

    const metaContent = [
      `Projeto: ${data.projectName}`,
      `Founder: ${data.founderName}`,
      `Email: ${data.email}`,
      `Telegram: ${data.telegram}`,
      `Track: ${data.track}`,
      `Estágio: ${data.stage}`,
      `Website: ${data.website || "—"}`,
      `Vídeo: ${data.videoUrl || "—"}`,
      ``,
      `Descrição:`,
      data.description,
      ``,
      `Submetido em: ${new Date().toISOString()}`,
      `ID: ${submissionId}`,
    ].join("\n");
    submissionFolder.createFile("_INFO.txt", metaContent, "text/plain");

    const sheet = SpreadsheetApp.openById(SHEET_ID).getSheets()[0];
    if (sheet.getLastRow() === 0) {
      sheet.appendRow([
        "Timestamp",
        "ID",
        "Projeto",
        "Founder",
        "Email",
        "Telegram",
        "Track",
        "Estágio",
        "Descrição",
        "Website",
        "Link Vídeo",
        "Pasta Drive",
        "Arquivos",
        "Status",
      ]);
    }
    sheet.appendRow([
      new Date(),
      submissionId,
      data.projectName,
      data.founderName,
      data.email,
      data.telegram,
      data.track,
      data.stage,
      data.description,
      data.website || "",
      data.videoUrl || "",
      submissionFolder.getUrl(),
      fileLinks.join("\n"),
      "Pendente",
    ]);

    return jsonResponse({
      success: true,
      id: submissionId,
      folderUrl: submissionFolder.getUrl(),
    });
  } catch (err) {
    console.error(err);
    return jsonResponse({ success: false, error: err.toString() });
  }
}

function jsonResponse(obj) {
  return ContentService.createTextOutput(JSON.stringify(obj)).setMimeType(
    ContentService.MimeType.JSON
  );
}

function doGet() {
  return jsonResponse({
    status: "Superteam BR submission endpoint OK",
    timestamp: new Date().toISOString(),
  });
}