⚙ Google Sheets Setup — One-Time Steps

function doPost(e) { const data = JSON.parse(e.postData.contents); const sheet = SpreadsheetApp.openById('YOUR_SHEET_ID').getActiveSheet(); if (sheet.getLastRow() === 0) { sheet.appendRow(['Timestamp','Name','Email','Delta Champ','Gamma Champ', 'Theta Champ','Vega Champ','Semifinal 1','Semifinal 2','Champion','Full Picks']); } sheet.appendRow([data.timestamp, data.name, data.email, data.delta_champ, data.gamma_champ, data.theta_champ, data.vega_champ, data.semifinal1, data.semifinal2, data.champion, data.full_picks]); return ContentService.createTextOutput('ok'); }