📌 Post Details
👤 Names
💰 Pricing
📊 Margin Preview
Profit Margin
Rs 0
Enter prices above
Recent Orders
0
No orders yet.
Add your first order!
🔗 Google Sheet Connection
Step 1: Google Sheet mein ek Apps Script lagao (neeche instructions hain)
Step 2: Script ka Web App URL yahan paste karo
Step 3: Save karo — bas! 🎉
Step 2: Script ka Web App URL yahan paste karo
Step 3: Save karo — bas! 🎉
📋 Apps Script Code (Copy Karo)
1
Apni Google Sheet kholo → Extensions → Apps Script
2
Neeche wala pura code copy karo aur paste karo
function doPost(e) {
try {
var data = JSON.parse(e.postData.contents);
var sheet = SpreadsheetApp.getActiveSpreadsheet()
.getActiveSheet();
// Add header if first row empty
if (sheet.getLastRow() === 0) {
sheet.appendRow([
"Website / Live Link",
"Vendor Name",
"Client Name",
"Vendor Price (PKR)",
"Client Price (PKR)",
"Margin (PKR)",
"Margin (%)",
"Date"
]);
}
sheet.appendRow([
data.liveLink,
data.vendorName,
data.clientName,
data.vendorPrice,
data.clientPrice,
data.margin,
data.marginPct,
data.date
]);
return ContentService
.createTextOutput(JSON.stringify({status:"ok"}))
.setMimeType(ContentService.MimeType.JSON);
} catch(err) {
return ContentService
.createTextOutput(JSON.stringify({status:"error",msg:err.toString()}))
.setMimeType(ContentService.MimeType.JSON);
}
}
function doGet(e) {
return ContentService
.createTextOutput(JSON.stringify({status:"active"}))
.setMimeType(ContentService.MimeType.JSON);
}
3
Deploy → New Deployment → Type: Web App → Execute as: Me → Who has access: Anyone → Deploy → URL copy karo
4
URL upar wale field mein paste karo aur Save karo ✅