System Design
"Standard form submissions are boring. I wanted a system that triggers an instant email notification every time a student submits a query, using Google Apps Script as a microservice."
Apps Script Webhook
function doPost(e) {
const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
const data = e.parameter;
sheet.appendRow([new Date(), data.name, data.email, data.msg]);
MailApp.sendEmail(data.email, "StackRepo Confirmation", "We received your data.");
return ContentService.createTextOutput("200 OK").setMimeType(ContentService.MimeType.TEXT);
}