function doPost(e) { const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const data = JSON.parse(e.postData.contents); // Format skills as readable string let skillsStr = ''; if (data.skills && data.skills.length) { skillsStr = data.skills.map(s => `${s.skill} (${s.rate})`).join(', '); } // Append row sheet.appendRow([ new Date().toLocaleString('en-US', { timeZone: 'UTC' }), data.name, data.email || '', data.contactMethod, data.contactValue, data.availability, data.bio || '', skillsStr, data.extras?.verified ? 'Yes' : 'No', data.extras?.portfolio ? 'Yes' : 'No', data.extras?.nda ? 'Yes' : 'No', data.extras?.urgent ? 'Yes' : 'No' ]); return ContentService.createTextOutput(JSON.stringify({ success: true })) .setMimeType(ContentService.MimeType.JSON); }