Setup Guide: Google Sheets Automatic Sync

To sync your orders with Google Sheets in real-time, follow these simple steps:

1. Open a new Google Sheet.
2. Go to Extensions > Apps Script.
3. Delete the default code and paste the following script:

   function doPost(e) {
     var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
     var data = JSON.parse(e.postData.contents);
     
     var orderId = data.orderId;
     var rows = sheet.getDataRange().getValues();
     var foundRowIndex = -1;
     
     // Search for the Order ID in the first column
     for (var i = 1; i < rows.length; i++) {
       if (String(rows[i][0]).trim() === String(orderId).trim()) {
         foundRowIndex = i + 1;
         break;
       }
     }
     
     var rowData = [
       data.orderId,
       data.date,
       data.customerName,
       data.phone,
       data.email,
       data.address,
       data.landmark,
       data.items,
       data.subtotal,
       data.deliveryCharge,
       data.totalAmount,
       data.paymentMethod,
       data.deliverySlot,
       data.status
     ];
     
     if (foundRowIndex !== -1) {
       sheet.getRange(foundRowIndex, 1, 1, rowData.length).setValues([rowData]);
     } else {
       sheet.appendRow(rowData);
     }
     
     return ContentService.createTextOutput(JSON.stringify({result: "success"})).setMimeType(ContentService.MimeType.JSON);
   }

4. Click Deploy > New Deployment. Select type Web App. Set "Execute as" to "Me" and "Who has access" to "Anyone".
5. Deploy, copy the Web App URL, and paste it into the setting field above.