Set up your business once. We'll remember it forever.
Pick the design that fits your brand
Business Β· Template
Optional β CGST, SGST, IGSTβ¦
No taxes. Tap "+ Add Tax" to add GST etc.
Send invoice directly to customer's email β no app opens.
Customer's phone number (optional). Opens WhatsApp with bill summary pre-filled.
Save this invoice to your Google Sheet. Each item gets its own row.
function doPost(e) {
try {
var data = JSON.parse(e.postData.contents);
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var rows = data.rows;
for (var i = 0; i < rows.length; i++) {
var r = rows[i];
sheet.appendRow([r.serial, r.invoice, r.item, r.qty, r.cost, r.date]);
}
return ContentService
.createTextOutput(JSON.stringify({status:'ok'}))
.setMimeType(ContentService.MimeType.JSON);
} catch(err) {
return ContentService
.createTextOutput(JSON.stringify({status:'error',message:err.toString()}))
.setMimeType(ContentService.MimeType.JSON);
}
}