V2 Multi-City Hub Mandsaur • Indore • Bhopal • Ujjain | Full Website Prompts & Filterable CRM

BizOutreach Pro V2

22 Leads

Multi-City Discovery • Detailed Pitches • Full AI Prompts • Hisaab CRM

Total Leads
22
Active Deals
0
Advance Collected
0
Pending Balance
0
Showing: 22 Businesses
City:
Category:

Full Website Builder Prompt

Copy and paste this into Google AI Studio, Gemini, or Google Stitch


            

Add New Business Lead

Google Sheet 2-Way Realtime Sync

Phone par tick karte hi Sheet me real-time update hoga!

1-Minute Setup Guide:

  1. Apni Client_CRM_and_Deal_Tracker Sheet kholein.
  2. Upar menu me Extensions ➔ Apps Script par click karein.
  3. Purana code mita kar neeche diya gaya Script Code paste karein.
  4. Upar blue Deploy ➔ New deployment par click karein (Type: Web app, Who has access: Anyone).
  5. Milne wala Web app URL copy karke neeche box me paste kar dein!
function doPost(e) {
  try {
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheets()[0];
    var data = JSON.parse(e.postData.contents);
    var rows = sheet.getDataRange().getValues();
    
    for (var i = 1; i < rows.length; i++) {
      if (rows[i][0] == data.clientId || rows[i][1] == data.name) {
        var rowNum = i + 1;
        if (data.status) sheet.getRange(rowNum, 5).setValue(data.status);
        if (data.advancePaid !== undefined) sheet.getRange(rowNum, 6).setValue(data.advancePaid ? "Yes" : "No");
        if (data.advanceAmount !== undefined) sheet.getRange(rowNum, 7).setValue(data.advanceAmount);
        if (data.totalDeal !== undefined) sheet.getRange(rowNum, 8).setValue(data.totalDeal);
        if (data.websiteUrl !== undefined) sheet.getRange(rowNum, 10).setValue(data.websiteUrl);
        if (data.revisionsNotes !== undefined) sheet.getRange(rowNum, 11).setValue(data.revisionsNotes);
        if (data.maintenanceActive !== undefined) sheet.getRange(rowNum, 12).setValue(data.maintenanceActive ? "Yes" : "No");
        sheet.getRange(rowNum, 13).setValue(new Date().toISOString().split("T")[0]);
        
        return ContentService.createTextOutput(JSON.stringify({result: "success", row: rowNum}))
          .setMimeType(ContentService.MimeType.JSON);
      }
    }
    return ContentService.createTextOutput(JSON.stringify({result: "not_found"})).setMimeType(ContentService.MimeType.JSON);
  } catch (err) {
    return ContentService.createTextOutput(JSON.stringify({result: "error", error: err.toString()})).setMimeType(ContentService.MimeType.JSON);
  }
}

Ek baar paste karte hi aapke phone ka har tick aur payment direct sheet me save hoga.

Action completed successfully!