Add Contacts

Add Destination

Manual Contact

CSV Import

Google Sheet Mapping

ID	Destination	Sheet	Tab	Active	Actions
6	Kerala	1tN03yzzW9OxcgICoC-_38VoZSLHcR0g2yOAogIaINOA	Sheet1	Yes	Edit Map Columns
5	Lonavala	1o-EKnpUyE_F6jp18AdJrpnsRDN-8iAorn1YVuo11RvY	Sheet1	Yes	Edit Map Columns
1	Mahabaleshwar	1o-EKnpUyE_F6jp18AdJrpnsRDN-8iAorn1YVuo11RvQ	Sheet1	Yes	Edit Map Columns

Now Add a New Sheet Tab Config in A1 type map_id and in B1 add id after this go to googlesheet>Extensions>Apps Scripts>Paste the given script and add the triggers

const API_URL =
"https://database.regentastays.com/sync_leads.php";

function getConfig()
{
  const cfg =
    SpreadsheetApp
    .getActiveSpreadsheet()
    .getSheetByName("Config");

if (!cfg)
    throw new Error("Config sheet missing");

const vals =
    cfg.getDataRange().getValues();

let obj = {};

vals.forEach(r=>{
    const k =
      String(r[0]||'')
      .trim()
      .toLowerCase();

const v =
      String(r[1]||'')
      .trim();

if(k) obj[k]=v;
  });

return obj;
}

function syncLeads()
{
  try
  {
    Logger.log("Starting sync");

const config =
      getConfig();

const mapId =
      parseInt(config.map_id);

if(!mapId)
      throw new Error(
        "map_id missing in Config"
      );

const sheet =
      SpreadsheetApp
      .getActiveSpreadsheet()
      .getActiveSheet();

const rows =
      sheet.getDataRange()
      .getDisplayValues();

if(rows.length < 2)
    {
      Logger.log("No rows");
      return;
    }

let headers =
      rows[0];

let syncedIndex =
      headers.findIndex(
        h => String(h)
        .trim()
        .toLowerCase() === "synced"
      );

if(syncedIndex === -1)
    {
      syncedIndex =
        headers.length;

sheet
      .getRange(1,syncedIndex+1)
      .setValue("synced");
    }

let data = [];
    let markRows = [];

for(let i=1;i<rows.length;i++)
    {
      const synced =
        String(
          rows[i][syncedIndex]||''
        )
        .trim()
        .toUpperCase();

if(synced==="YES")
        continue;

let obj = {};

headers.forEach((h,idx)=>{
        obj[h]=rows[i][idx];
      });

data.push(obj);
      markRows.push(i+1);
    }

if(!data.length)
    {
      Logger.log("No new leads");
      return;
    }

const payload = {
      map_id: mapId,
      rows: data
    };

Logger.log(
      JSON.stringify(payload)
    );

const res =
      UrlFetchApp.fetch(
        API_URL,
        {
          method:"post",
          contentType:"application/json",
          payload:JSON.stringify(payload),
          muteHttpExceptions:true
        }
      );

const raw =
      res.getContentText();

Logger.log(raw);

const result =
      JSON.parse(raw);

if(result.success)
    {
      markRows.forEach(r=>{
        sheet
        .getRange(r,syncedIndex+1)
        .setValue("YES");
      });

Logger.log(
        "Inserted: "
        + result.inserted
      );
    }
  }
  catch(err)
  {
    Logger.log(err.message);
  }
}

Add Contacts

Add Destination

Manual Contact

CSV Import

Google Sheet Mapping

Edit Mapping

Column Mapping

Google Script Code