Sync all bills directly to your Google Sheet without any intermediary server fees. Simply paste your Google Apps Script Web App URL below:
function doPost(e) {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var d = JSON.parse(e.postData.contents);
sheet.appendRow([
new Date(), d.invoiceNo, d.date, d.customerName,
d.customerPhone, d.customerGst, d.itemsSummary,
d.subtotal, d.totalTax, d.grandTotal, d.status, d.balanceDue
]);
return ContentService.createTextOutput(JSON.stringify({result:'success'})).setMimeType(ContentService.MimeType.JSON);
}
| Inv # | Date | Customer | Phone | Amount | Status | Action |
|---|