ConverzIQ — Call Intelligence CRM

Total Leads

—

All calls

Warm

—

Active interest

Hot

—

High priority

Cold

—

Low intent

Avg QA Score

—

Out of 10

🔍

Lead Records

—

#↕	Date & Time↕	Mobile↕	Language	Lead Type↕	Intent	Sentiment	Product	Competitor	QA↕	Timeline

Warm Leads

—

Hot Leads

—

Top Product

—

Avg QA (Warm/Hot)

—

🔥 Hot Leads

🌡️ Warm Leads

With Next Steps

—

Scheduled Follow-ups

—

Overdue

0

All Follow-up Actions

Leads with defined next steps

Total Calls

—

Classified Leads

—

Positive Sentiment

—

Avg QA Score

—

Lead Type Distribution

Intent Breakdown

Sentiment Distribution

Language Distribution

Products Mentioned

Most Missed Questions

Scored Calls

—

Average Score

—

Top Score

—

Lowest Score

—

Score Leaderboard

Score Distribution

Top Coaching Tips

Calls with Competitor Mention

—

Unique Competitors

—

Top Competitor

—

Competitor Frequency

Calls Mentioning Competitors

⚙️ Google Sheets Data Source

Published CSV URL

File → Share → Publish to web → CSV format → Copy link

Current Status

Sheet URL—

Last Synced—

Total Records—

Status—

⚡ If connection fails — Google Apps Script (always works)

1. Open your Google Sheet → Extensions → Apps Script
2. Delete existing code, paste this, then Deploy → New Deployment → Web App → Access: Anyone

function doGet() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var data = ss.getActiveSheet().getDataRange().getValues();
  var headers = data[0];
  var rows = data.slice(1).map(function(row) {
    var obj = {};
    headers.forEach(function(h,i){ obj[h] = row[i]; });
    return obj;
  });
  var out = ContentService.createTextOutput(JSON.stringify(rows));
  out.setMimeType(ContentService.MimeType.JSON);
  return out;
}

3. Copy the Web App URL it gives you → paste in the URL field above → Save & Reload