lock

Admin Access Portal

Enter security PIN to view inquiries, test email routing, and manage website leads.

Default Passcode: ub2026
Operations Portal
arrow_back View Website

Executive Lead & Consultation Center

Centralized inbound lead management for Pankaj Goyal (pankajgoyal@ubexcellence.com).

Checking Multi-Device Sync...
mail
Instant Email Delivery to Your Inbox: All captured leads automatically dispatch to pankajgoyal@ubexcellence.com and pankaj@ubexcellence.com.
šŸ’” First-Time Activation: If you haven't received emails yet, search your mailbox (and Spam folder) for an email from FormSubmit with subject "Action Required: Confirm your email" and click Activate Form.
dataset
0
Total Inquiries
bolt
0
10-Sec Slide-in Leads
precision_manufacturing
0
Chatbot Consultations
contact_page
0
Contact Form Direct
search
Date / Time Source Prospect & Company Contact Details Page Source Actions

Inquiry Details

table_chart Automated Google Sheets Multi-Device Sync

This connects a private Google Sheet on your Google Drive as your central cloud database. Every visitor inquiry automatically records in Google Sheets, and every laptop, phone, and tablet you use will stay 100% in sync!

Step 1: Save Your Google Web App URL

Step 2: 1-Minute Google Apps Script Code

Open a new Google Sheet at sheets.new, go to Extensions > Apps Script, paste the code below, and click Deploy > New deployment > Web app (Anyone):

function doGet(e) { try { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var data = sheet.getDataRange().getValues(); var leads = []; if (data.length > 1) { for (var i = data.length - 1; i >= 1; i--) { if (!data[i][0] && !data[i][2]) continue; leads.push({ formattedTime: String(data[i][0]), source: String(data[i][1] || 'Website'), nameCompany: String(data[i][2] || ''), contact: String(data[i][3] || ''), page: String(data[i][4] || ''), notes: String(data[i][5] || '') }); } } return ContentService.createTextOutput(JSON.stringify({ status: "success", leads: leads })) .setMimeType(ContentService.MimeType.JSON); } catch (err) { return ContentService.createTextOutput(JSON.stringify({ status: "error", message: err.toString(), leads: [] })) .setMimeType(ContentService.MimeType.JSON); } } function doPost(e) { try { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); if (sheet.getLastRow() === 0) { sheet.appendRow(["Date & Time (IST)", "Lead Source", "Name & Company", "Contact (Phone/Email)", "Page URL", "Notes / Message"]); sheet.getRange(1, 1, 1, 6).setFontWeight("bold").setBackground("#e2e8f0"); sheet.setFrozenRows(1); } var data = JSON.parse(e.postData.contents); var now = new Date(); var timeFormatted = Utilities.formatDate(now, "Asia/Kolkata", "dd/MM/yyyy, hh:mm:ss a"); sheet.appendRow([ timeFormatted, data.source || "Website Lead", data.nameCompany || data.name || "Prospective Client", data.contact || (data.email + (data.phone ? " / " + data.phone : "")) || "", data.page || "", data.notes || data.transcriptSummary || "" ]); try { MailApp.sendEmail({ to: "pankajgoyal@ubexcellence.com", cc: "pankaj@ubexcellence.com", subject: "āš” New Website Lead: " + (data.nameCompany || data.name || "Inquiry"), body: "New inquiry captured on website:\n\nā€¢ Name & Company: " + (data.nameCompany || data.name) + "\nā€¢ Contact: " + (data.contact || data.email || data.phone) + "\nā€¢ Source: " + (data.source || "Website") + "\nā€¢ Page: " + (data.page || "/") + "\nā€¢ Time: " + timeFormatted + " IST\n\nNotes:\n" + (data.notes || "Callback requested.") }); } catch (m) {} return ContentService.createTextOutput(JSON.stringify({ result: "success" })).setMimeType(ContentService.MimeType.JSON); } catch (err) { return ContentService.createTextOutput(JSON.stringify({ result: "error", error: err.toString() })).setMimeType(ContentService.MimeType.JSON); } }