function doPost(e) {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const params = JSON.parse(e.postData.contents);
const phone = params.phone || ”;
const referrer = params.referrer || ”;
const coins = 100;
const timestamp = new Date();

const data = sheet.getDataRange().getValues();
if (data.some(row => row[0] === phone)) {
return ContentService.createTextOutput(‘This number is already registered!’); }

sheet.appendRow([phone, referrer || ‘None’, coins, timestamp]);

for (let i = 1; i < data.length; i++) {
if (data[i][0] === referrer) {
const refRow = i + 1;
const current = sheet.getRange(refRow, 3).getValue();
sheet.getRange(refRow, 3).setValue(current + 100);
return ContentService.createTextOutput(`Signup complete. You earned 100 coins. Referrer ${referrer} earned 100 too!`); }
}

return ContentService.createTextOutput(‘Signup complete. You earned 100 coins!’); }

function doGet() {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); const data = sheet.getDataRange().getValues();
const users = data.slice(1).map(row => ({
phone: row[0],
referrer: row[1],
coins: row[2],
timestamp: row[3]
}));
return ContentService.createTextOutput(JSON.stringify(users)).setMimeType(ContentService.MimeType.JSON); }